Querying Records with OData

Beginner

Read records from FileMaker tables using OData GET requests and understand the response format.

What you'll learn

  • GET requests for collections and individual records
  • The OData JSON response format
  • Pagination with $top and $skip
  • The $count system query option

Querying records in OData uses standard HTTP GET requests to a collection URL. The response is a JSON object containing the records as an array of objects. Understanding the URL structure and response format is foundational to using FileMaker OData effectively.

1/4
1

GET a collection

Request all records from a table:

HTTP
GET /fmi/odata/v4/{database}/{TableName}
Authorization: Basic {credentials}

// Response:
{
  "@odata.context": "...",
  "value": [
    { "id": "1", "FirstName": "Alice", "LastName": "Smith" },
    { "id": "2", "FirstName": "Bob", "LastName": "Jones" }
  ]
}
Authenticating to the FileMaker OData EndpointFiltering OData Results with $filter

Sign in to track your progress and pick up where you left off.

Sign in to FM Dojo