OData & Custom App API
Query FileMaker data with OData, the Custom App API, and standards-based integrations.
What Is OData and Why Does FileMaker Support It?
Understand the OData protocol, what FileMaker exposes via it, and when to use it instead of the Data API.
Authenticating to the FileMaker OData Endpoint
How to authenticate with Basic auth and obtain access to FileMaker data through OData.
Querying Records with OData
Read records from FileMaker tables using OData GET requests and understand the response format.
Filtering OData Results with $filter
Use OData $filter expressions to return only the records you need from a FileMaker table.
Selecting Fields and Sorting with $select and $orderby
Control which fields are returned and how results are sorted using OData system query options.
Creating and Updating Records via OData
Use OData POST and PATCH requests to create new records and update existing ones in FileMaker.
Deleting Records via OData
Use OData DELETE requests to remove records from FileMaker tables.
Reading the OData Metadata Document
Use the $metadata endpoint to discover the schema of a FileMaker database exposed via OData.
Connecting Power BI to FileMaker via OData
Step-by-step guide to building a live Power BI report connected directly to a FileMaker database.
Live Excel Reports from FileMaker via OData
Connect Excel to FileMaker data with OData for reports that refresh with a click instead of manual exports.
Navigation Properties and $expand in FileMaker OData
Use OData navigation properties to traverse FileMaker relationships and fetch related data in a single request.
OData Batch Requests
Send multiple OData requests in a single HTTP call using OData batch to improve performance and enable atomic operations.
Connecting Tableau to FileMaker via OData
Set up Tableau Desktop to connect to FileMaker data using the OData connector for live or extract-based analytics.
The FileMaker Custom App API
Understand the Custom App API -- what it is, how it relates to OData, and when to use it.
Real-Time Data Patterns with FileMaker OData
OData is request-response only -- understand how to build near-real-time data feeds using polling and webhooks alongside OData.
Running FileMaker Scripts via OData
Use OData stored procedures to trigger FileMaker scripts from an external system.
OData Error Handling and Debugging
Interpret OData error responses, debug FileMaker OData issues, and build resilient integrations.
OData vs. ODBC: Choosing the Right FileMaker Integration
Compare OData and ODBC/JDBC for FileMaker integrations and understand when each is the right choice.
Optimizing FileMaker OData Performance
Techniques to improve the speed and efficiency of OData queries against FileMaker Server.
OData Integration Patterns for FileMaker
Proven architectural patterns for integrating external systems with FileMaker via OData.