Query option $expand

Use the $expand query option to include related records along with the records in the response.

Component Description

HTTP method

GET

URL

https://host/fmi/odata/version/database-name/table-name?$expand=related-table-name

host – FileMaker Cloud or FileMaker Server host name

version – the OData version, always v4

database-name – the name of the hosted database

table-name - the name of the table

related-table-name - the name of the related table

Example: /fmi/odata/v4/ContactMgmt/Contacts?$expand=Orders