Update record references
To create, update, or delete record relationships, use the $ref option with an HTTP DELETE, PATCH, PUT, or POST method with the record that you want to update in the URL.
| Component | Description |
|---|---|
|
HTTP method |
POST, PATCH, PUT, DELETE |
| URL |
https://host/fmi/odata/version/database-name/table-name (primary-key-value)/related-table/$ref host – FileMaker Cloud or FileMaker Server host name version – the OData version, always database-name – the name of the hosted database table-name - the name of the table related-table - the name of the related table primary-key-value - the unique identifier value of the record Example: |
|
Parameters |
Detach (DELETE) the related record from the parent JSON example:
Add (PATCH, PUT, or POST) a related record reference to the parent JSON example:
Copy
|
FileMaker information
-
Container values are updated either by providing a base64-encoded value as described in Update a record with an image or PDF container field, or by providing the binary data described in Update a record with an image or PDF container field with binary data.
-
Values for individual repetitions of repeating fields are provided by specifying the repetition index in brackets (for example,
Name[4]). Specifying a repetition of a container field is not supported when updating a record. -
You can update multiple records by specifying
$filtercriteria.