Request an individual record

To request an individual record in a database table, specify the database name and table name, and the primary key value for the record.

Component Description

Component	Description
HTTP method	GET
URL	https://`host`/fmi/odata/`version`/`database-name`/`table-name`(`primary-key-value`) `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 `primary-key-value` - the unique identifier value of the record Example: `/fmi/odata/v4/ContactMgmt/Contacts('ALFKI')`

HTTP method

GET

URL

https://host/fmi/odata/version/database-name/table-name(primary-key-value)

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

primary-key-value - the unique identifier value of the record

Example: /fmi/odata/v4/ContactMgmt/Contacts('ALFKI')

FileMaker information

The primary key value specified in the URL is the field designated as the primary key, or the ROWID system field if no primary key has been designated. See Get metadata. For repeating fields, the value of the first repetition is included. To get individual repetitions, see Request an individual field value.