Claris FileMaker OData API

Name: Claris FileMaker OData API API
Brand: Claris FileMaker OData API
Availability: InStock

★ Only Publicly Available OpenAPI DocumentStorageDatabasebasic, apiKey7 EndpointsREST

For Agents

Query FileMaker tables as OData entity sets — list, filter, and update records using the OData 4.01 standard.

Connect the Claris FileMaker OData API to your agent

Jentic One is a self-hosted execution layer for AI agents. It lets your agent call the Claris FileMaker OData API, or any other public or private API you need. You set the rules, the agent never sees your credentials, and every call is logged.

Install Jentic One Beta (Self-Hosted)

Jentic One Host machine

# On the machine that will host your Jentic One instance:
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh

Agent machine

# On the machine where your agent runs (keep this separate from the instance):
curl -fsSL https://raw.githubusercontent.com/jentic/jentic-one/main/tools/install.sh | sh
jentic register       # connects your agent to your Jentic One instance

Jentic One is in public beta. The setup above keeps your agent separate from the instance, which is what you want before using real credentials: an agent running as the same OS user as Jentic One can read its stored keys directly. Just evaluating? A single local install is fine to start. See the secure deployment guide for the tiers.

Capabilities

What an agent can do with Claris FileMaker OData API API.

Discover available FileMaker tables via the OData service document

Retrieve the EDM $metadata document so OData clients can introspect the schema

Query records from a table using OData $filter, $select, and $orderby

Fetch a single record by primary key using OData entity-set syntax

GET STARTED

Start building with Claris FileMaker OData API API

Explore with Jentic

View OpenAPI Document

Use for: I need to query a FileMaker table from Power BI through OData, I want to update a FileMaker record by primary key, List all rows of a FileMaker table that match an OData filter, Get the OData metadata document for a FileMaker database

Not supported: Does not administer FileMaker Server, run FileMaker scripts, or upload container data — use the Admin API for server ops and the Data API for FileMaker-native record work; this OData API is for OData-shaped record queries and CRUD only.

Jentic publishes the only available OpenAPI document for Claris FileMaker OData API, keeping it validated and agent-ready.

Jentic publishes the only available OpenAPI specification for Claris FileMaker OData API, keeping it validated and agent-ready. The FileMaker OData API exposes hosted FileMaker databases through the Open Data Protocol 4.01 standard, so OData-aware tools such as Power BI, Excel, and Tableau can query records without a FileMaker-specific connector. It supports a service document, an EDM metadata document, entity set queries with $filter and $select, and standard CRUD on individual entities by primary key. This is the right surface when the consuming application already speaks OData.

Use Cases

Patterns agents use Claris FileMaker OData API API for, with concrete tasks.

★ Power BI Reporting on FileMaker Data

Analysts can connect Power BI directly to a FileMaker database through the OData service document and pull tables as datasets without a custom gateway. The OData $filter and $select query options let dashboards request only the rows and columns they need, keeping refresh times short. This avoids exporting CSVs by hand and keeps Power BI reports current with the live FileMaker solution.

GET /{database} for the service document, then GET /{database}/{tableName}?$filter={query} to load a filtered slice into the BI tool.

Excel Live Refresh of FileMaker Tables

Operations users who live in Excel can use Get Data from OData to point at a FileMaker database and refresh on demand or on a schedule. Each FileMaker table appears as an entity set, and Excel handles the OData query negotiation. This pattern keeps spreadsheets in sync with the source without an Excel macro reaching into FileMaker directly.

Configure Excel to GET /{database}/{tableName} on the OData endpoint and refresh the workbook on a schedule.

Standardised CRUD from External Systems

Integration teams that already have OData clients for other systems can reuse them against FileMaker without writing FileMaker-specific code. POST creates a new entity, PATCH updates, and DELETE removes a record, all keyed by the FileMaker primary key. This reduces integration code and keeps a consistent OData mental model across data sources.

POST /{database}/{tableName} with the new row, then PATCH /{database}/{tableName}({primaryKey}) to apply later updates.

AI Agent Querying FileMaker via OData

An AI agent that already supports OData can call FileMaker through Jentic without learning the FileMaker Data API's find syntax. Jentic exposes the OData operations with their schemas, isolates the FileMaker credentials in its vault, and lets the agent translate a question into an OData $filter expression. This is the simplest path when the agent's other tools are also OData-shaped.

Search Jentic for 'query a filemaker table via odata', load the GET /{database}/{tableName} schema, and execute with the appropriate $filter.

Key Endpoints

7 endpoints — jentic publishes the only available openapi specification for claris filemaker odata api, keeping it validated and agent-ready.

METHOD

PATH

DESCRIPTION

GET

/{database}

Get the OData service document

GET

/{database}/$metadata

Get the OData EDM metadata document

GET

/{database}/{tableName}

List records from a table with OData query options

POST

/{database}/{tableName}

Create a record on a table

GET

/{database}/{tableName}({primaryKey})

Get a single record by primary key

PATCH

/{database}/{tableName}({primaryKey})

Update a record by primary key

DELETE

/{database}/{tableName}({primaryKey})

Delete a record by primary key

GET

/{database}

Get the OData service document

GET

/{database}/$metadata

Get the OData EDM metadata document

GET

/{database}/{tableName}

List records from a table with OData query options

POST

/{database}/{tableName}

Create a record on a table

GET

/{database}/{tableName}({primaryKey})

Get a single record by primary key

Why though Jentic?

Three things that make agents converge on Jentic-routed access.

Credential isolation

FileMaker Basic credentials and FMID tokens are stored in the Jentic vault. Each OData request is signed by Jentic at execution time, so the agent never sees the raw credentials.

Intent-based discovery

Agents search by intent (e.g., 'query a filemaker table via odata') and Jentic returns the matching OData operation with its input schema, including the OData query option parameters.

Time to first call

Direct OData integration: 1-2 days to wire up auth and query option encoding. Through Jentic: under an hour to search, load, and execute the first OData query.

Related APIs

Alternatives and complements available in the Jentic catalogue.

Alternative

Claris FileMaker Data API

FileMaker-native JSON record API with find requests and container uploads

Choose the Data API when the agent needs FileMaker-specific find logic, container uploads, or script execution; choose OData when the consumer already speaks OData.

Complementary

Claris FileMaker Admin API

Server-level administration of FileMaker databases

Pair OData for data access with the Admin API when the agent also needs to open, close, or schedule the database.

Alternative

Airtable API

Hosted database with REST API

Pick Airtable for new builds without on-prem requirements; pick FileMaker OData when the data lives in a FileMaker solution and the consumer is OData-shaped.

FAQs

Specific to using Claris FileMaker OData API API through Jentic.

Why is there no official OpenAPI spec for Claris FileMaker OData API?

Claris does not publish an OpenAPI specification for the OData endpoint — the official documentation describes OData 4.01 conformance instead. Jentic generates and maintains an OpenAPI-shaped description so AI agents and developers can call Claris FileMaker OData API via structured tooling. Get started at https://app.jentic.com/sign-up.

What authentication does the FileMaker OData API use?

The OData endpoint accepts HTTP Basic authentication and Claris ID (FMID) token authentication via the Authorization header. There is no separate session-token exchange — credentials are sent on each request. Jentic stores the credentials in its vault and signs each call without exposing them to the agent.

Can I use OData $filter against FileMaker tables?

Yes. GET /{database}/{tableName} accepts standard OData query options including $filter, $select, $orderby, $top, and $skip. The FileMaker OData server translates these into FileMaker query operations against the underlying table.

What are the rate limits for the FileMaker OData API?

Claris does not publish a public rate limit table for OData. Effective throughput is bounded by the FileMaker Server's CPU and licensed concurrent connection count. Use $select to fetch only needed columns and $top with paging instead of pulling whole tables.

How do I update a FileMaker record by primary key through Jentic?

Search Jentic for 'update a filemaker odata record', load the PATCH /{database}/{tableName}({primaryKey}) schema, and execute with the primary key and the changed fields. Jentic handles authentication via the vault.

Does the OData API support container fields?

Container fields are not exposed through the OData endpoint in the same way as scalar fields — for upload and binary retrieval, use the FileMaker Data API's container endpoint. The OData API is best for tabular data access by OData-aware clients.