Request the number of records in a table

To request the number of records in a FileMaker Pro database, use the HTTP GET request with $count appended to the URL of the table.

Component Description

HTTP method

GET

URL

https://host/fmi/odata/version/database-name/table-name/$count

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/$count

FileMaker information

  • The response Content-Type for this request is text/plain.

  • You can specify a $filter criteria in the URL to get the number of matching records.