Create a record

To create a record for a table, use the POST method. The POST body must contain a single record's data in JSON format.

Component

Description

HTTP method

POST

URL

https://host/fmi/odata/version/database-name/table-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

Example: /fmi/odata/v4/ContactMgmt/Contacts
Parameters

JSON example:

Copy 
{
  "PrimaryKey": "BJONES",
  "Name": "Bob Jones",
  "Zone": 1,
  "Title": "SouthWest Sale Manager",
  "Company": "Example, Inc.",
  "Website": "www.example.com"
 }

Atom example:

Copy 
<entry xmlns="https://www.w3.org/2005/Atom"
    xmlns:metadata="https://docs.oasis-open.org/odata/ns/metadata"
    xmlns:data="https://docs.oasis-open.org/odata/ns/data">
  <content type="application/xml">
    <metadata:properties>
      <data:PrimaryKey>BJONES</data:PrimaryKey>
      <data:Name>Bob Jones</data:Name>
      <data:Zone metadata:type="Decimal">1</data:Zone>
      <data:Title>SouthWest Sale Manager</data:Title>
      <data:Company>Example, Inc.</data:Company>
      <data:Website>www.example.com</data:Website>
    </metadata:properties>
  </content>
</entry>

FileMaker information

  • Values for individual repetitions in a repeating field are provided by specifying the repetition number in brackets (for example, Name[4]).

  • If you create a record with empty data objects in JSON format, at least one field must allow null values.

  • FileMaker global fields are read-only and cannot be updated with OData.