FileMaker OData Explorer

Node.js Proxy Enabled: This page uses your Node.js proxy server to handle authentication and CORS. The proxy automatically includes the required credentials when connecting to FileMaker.

OData Endpoints

1. Service Root

Shows the available tables in the FileMaker database.

https://fms.gwmacs.com/fmi/odata/v4/zfm_test

Open in New Tab

Response:

2. Metadata

Shows the schema definition with tables, fields, and relationships.

https://fms.gwmacs.com/fmi/odata/v4/zfm_test/$metadata

Open in New Tab

Response:

3. Notes Table

Shows all records in the Notes table.

https://fms.gwmacs.com/fmi/odata/v4/zfm_test/Notes

Open in New Tab

Response:

4. Filtered Query

Shows Notes containing the word "Test".

https://fms.gwmacs.com/fmi/odata/v4/zfm_test/Notes?$filter=contains(Note,'Test')

Open in New Tab

Response:

5. Single Record

View a specific record by ID (change the ID if needed).

https://fms.gwmacs.com/fmi/odata/v4/zfm_test/Notes(1)

Open in New Tab

Response:

Custom Query

Build Your Own Query

Enter a custom OData query parameter to explore the data.

Query Parameter:

https://fms.gwmacs.com/fmi/odata/v4/zfm_test/Notes?$filter=Status eq 'Active'

Response: