filemaker-odata

n8n community node for FileMaker OData API - Query, create, update, and delete records in FileMaker databases

Package Information

Downloads: 0 weekly / 35 monthly
Latest Version: 0.3.0
Author: Proofgeist

Available Nodes

FileMaker OData icon
FileMaker OData
Interact with FileMaker databases via OData API

Documentation

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

In n8n (Recommended)

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

Via npm

npm install n8n-nodes-filemaker-odata

Operations

This node supports the following operations:

Records

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

Tables

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

Schema

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

Scripts

Operation Description
Run Script Run a FileMaker script with optional parameter

Credentials

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

OttoFMS API Key (Recommended)

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_)

Basic Authentication

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

Query Records with Filter

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

Create a Record

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

Run a Script

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

License

MIT

Discussion