Request an individual field value

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

Component Description

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

HTTP method

GET

URL

https://host/fmi/odata/version/database-name/table-name(primary-key-value)/field-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 or FileMaker Table ID (FMTID)

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

field-name - the name of the field or FileMaker Field ID (FMFID)

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

Example: /fmi/odata/v4/ContactMgmt/FMTID:123456789('ALFKI')/FMFID:123456789

FileMaker information

In a URL, when requesting an individual repetition, use brackets ([ ]) or forward slash (/) to specify the repetition index.

Examples:
- /fmi/odata/v4/ContactMgmt/Contacts('ALFKI')/Name[1]
- /fmi/odata/v4/ContactMgmt/Contacts('ALFKI')/Name/1
If the repetition field is a container field, only the first repetition is returned unless the repetition index is specified. Otherwise, all repetitions are returned.