Write OData API calls

OData uses the following HTTP methods:

• POST

  Used with Create a table, Create a field index, Create a record, Update record references, and Run scripts

• GET

  Used with Database structure and metadata, Query options, and Request data

• PATCH

  Used with Update a record, Update record references, Update container fields in a record using base64-encoded data, Update a container field in a record using binary data, and Add fields into a table

• DELETE

  Used with Delete a table, Delete a field from a table, Delete a record, and Update record references

OData uses the following headers:

• Authorization: must be provided with all requests. For the required format, see Creating an authenticated connection to the host.

• Accept: indicates the format of the expected response. If specified, must be one of the following:

  • application/json (default)

  • application/atom+xml (or application/xml)

  • text/html

  For JSON applications, the following JSON-specific option is supported: IEEE754Compatible=true and indicates that fields with type Edm.Int64 and Edm.Decimal are returned as string values. See OData 4.01 JSON format.

  The value is overridden by the value of $format query option, if specified. See "Header Accept" in OData 4.01 Protocol.

• Content-Type: indicates the format of the request body for POST and PATCH methods. If specified, it must be one of the following:

  • application/json (default)

  • application/atom+xml (or application/xml)

  • multipart/mixed (for $batch operations)

  • or, for updating a container field using binary data, a value defined in Update a container field in a record using binary data

  See "Header Content-Type" in OData 4.01 Protocol.

• OData-Version: indicates the version of the OData protocol. FileMaker Cloud and FileMaker Server support OData 4.0. See "Header OData-Version" in OData 4.01 Protocol.

• OData-MaxVersion: indicates the maximum version for OData protocol. FileMaker Cloud and FileMaker Server support OData 4.0. See "Header OData-MaxVersion" in OData 4.01 Protocol.

• Prefer: the following values are supported:

  • odata.continue-on-error

  • odata.maxpagesize

  • return=representation

  • return=minimal

  See "Header Prefer" in OData 4.01 Protocol.

https://host/fmi/odata/version/database-name

host – FileMaker Cloud or FileMaker Server host name

version – the OData version, always v4

database-name – the name of the hosted database

Example: /fmi/odata/v4/ContentMgmt