Request records from a table

To return a collection of records from the FileMaker Pro database, use the HTTP GET method with the table name included in the URL.

Component Description

Component	Description
HTTP method	GET
URL	https://`host`/fmi/odata/`version`/`database-name`/`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 Example: `/fmi/odata/v4/ContactMgmt/Contacts`

HTTP method

GET

URL

https://host/fmi/odata/version/database-name/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

Example: /fmi/odata/v4/ContactMgmt/Contacts

FileMaker information

Container fields are not included in the response result when you get all records or a single record. See Request an individual field value for information about requesting container field values.
A maximum of 10,000 records are returned at a time. If the total records in a request exceeds 10,000, the nextLink value is also returned providing the next set of records.