FileMaker 2023 (v20) added minor functionality to the FileMaker Data API. Here, we’ll cover an overview of the new date format parameters, Save Record as PDF script step, and several bug fixes.
We’re providing a tutorial file for learning more and trying out various REST and cURL functionality with FileMaker’s Data API. Enjoy!
FileMaker Data API: A Brief History
Comparing FileMaker Data API vs. OData
The FileMaker Data API and the OData protocol, both offer methods for interfacing with web services, but they have distinct features and use cases.
The FileMaker Data API is a RESTful service that allows web services to interact with databases hosted on FileMaker Server or FileMaker Cloud. It’s designed to perform database operations such as creating, updating, and deleting records, and retrieving data in JSON format, which is widely used for web applications. This API is particularly strong in its integration with FileMaker’s own environment, allowing the use of FileMaker scripts to automate and enhance database interactions.
OData, on the other hand, allows FileMaker data to be accessed alongside other OData-compliant data sources. OData stands out by providing a uniform way to query and manipulate data sets through CRUD operations (Create, Read, Update, Delete) using standard web technologies such as HTTP. It supports a range of features like filtering, sorting, and paging data, making it versatile for use in various types of applications, including integration with other services and platforms. FileMaker OData is well-suited for applications that need to interact with multiple database systems or replace traditional database connectivity options like ODBC and JDBC. The OData API does not require the installation of additional drivers or software on the client, which simplifies deployment and maintenance.
It is also feasible to use OData in conjunction with microservices such as Node-RED to offer functionalities that might not be directly possible within FileMaker alone. OData’s standardization and compatibility with various tools and platforms allow it to seamlessly integrate into broader, service-oriented architectures. This makes it a suitable choice for scenarios where interoperability and flexibility across different systems and services are required.