n8n-nodes-filemaker-odata

This is an n8n community node that lets you interact with FileMaker databases via the OData API.

n8n is a fair-code licensed workflow automation platform.

FileMaker is a low-code database platform by Claris (Apple subsidiary).

Installation

$3

1. Go to Settings → Community Nodes
2. Click Install a community node
3. Enter n8n-nodes-filemaker-odata
4. Click Install

$3

``bash
npm install n8n-nodes-filemaker-odata
`

Operations

This node supports the following operations:

$3

| Operation | Description |
|-----------|-------------|
| Get Many | Query records with filtering, sorting, and pagination |
| Get | Get a single record by primary key |
| Get Count | Get the count of records (optionally filtered) |
| Get Field Value | Get a specific field value from a record |
| Get Related | Navigate to related records via relationships |
| Create | Create a new record |
| Update | Update an existing record |
| Delete | Delete a record |

$3

| Operation | Description |
|-----------|-------------|
| List Tables | Get all tables in the database |
| Get Metadata | Get OData schema metadata |

$3

| Operation | Description |
|-----------|-------------|
| Create Table | Create a new table with fields |
| Add Fields | Add fields to an existing table |
| Delete Table | Delete a table |
| Delete Field | Delete a field from a table |

$3

| Operation | Description |
|-----------|-------------|
| Run Script | Run a FileMaker script with optional parameter |

Credentials

This node requires FileMaker OData API credentials. You can authenticate using:

$3

If you're using OttoFMS:

- Host: Your FileMaker Server URL (e.g., https://your-server.example.com)
- Database: Your FileMaker database name
- Authentication Type: OttoFMS API Key
- OttoFMS API Key: Your API key (starts with dk_)

$3

Using FileMaker account credentials:

- Host: Your FileMaker Server URL
- Database: Your FileMaker database name
- Authentication Type: Basic Auth
- Username: FileMaker account username
- Password: FileMaker account password

Examples

$3

`
Resource: Record
Operation: Get Many
Table: Customers
Options:
Filter: Status eq 'Active'
Select: Name, Email, Phone
Order By: Name asc
Limit: 50
`

$3

`
Resource: Record
Operation: Create
Table: Orders
Data: {"CustomerID": "12345", "Product": "Widget", "Quantity": 5}
`

$3

`
Resource: Script
Operation: Run Script
Table: Customers
Script Name: ProcessNewOrder
Script Parameter: {"orderID": "ORD-001"}
`

OData Filter Syntax

The node uses OData v4 filter syntax. Examples:

| Filter | Description |
|--------|-------------|
| Name eq 'John' | Name equals "John" |
| Age gt 21 | Age greater than 21 |
| Status ne 'Closed' | Status not equal to "Closed" |
| contains(Name, 'Smith') | Name contains "Smith" |
| startswith(Email, 'john') | Email starts with "john" |
| Date ge 2024-01-01 | Date on or after Jan 1, 2024 |
| Active eq true and Age gt 18 | Combine with AND |
| Status eq 'Open' or Status eq 'Pending'` | Combine with OR |

Resources

- n8n community nodes documentation
- FileMaker OData API documentation
- fmodata library
- OttoFMS

License

MIT