Query option $select

Use the $select query option to request a limited set of fields for each table. The default is to return all fields except container fields.

Component Description

HTTP method

GET

URL

https://host/fmi/odata/version/database-name/table-name?$select=field 1, field 2

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

field 1, field 2 - the name of the fields

Example: /fmi/odata/v4/ContactMgmt/Contacts?$select=Company,Website

The request above returns the Company and Website data for all records in the Contacts table.

FileMaker information

  • The ROWID and ROWMODID system field is included in the result set by specifying them with the $select query option. For example: $select=ROWID, ROWMODID.

  • ROWID is equivalent to the value returned by the Get (RecordID) function, and ROWMODID is equivalent to the value returned by the Get (RecordModificationCount) function.

  • $select queries can be nested within other $select queries and within other query options. For example:

    GET http://localhost/odata/Categories?$expand=Products&$select=Name,Products/Name