Paginating Data API results with _limit and _offset

Intermediate

Control how many records the Data API returns per request and navigate through large result sets using the _limit, _offset, and _totalCount response field.

What you'll learn

How _limit and _offset control which slice of records is returned
How to use _totalCount to know when you have fetched all records
How to page through a large result set in a FileMaker script loop

The Data API never returns an entire found set in one call by default — you control page size and position with _limit and _offset query parameters.

1/3

Set _limit and _offset on a find request

Add _limit and _offset as fields in the JSON body of a _find request. _limit defaults to 100 if omitted; _offset defaults to 1 (1-based).

HTTP

POST /fmi/data/v1/databases/{db}/layouts/Orders/_find
Authorization: Bearer {token}
Content-Type: application/json

{
  "query": [{ "Status": "Open" }],
  "limit": 50,
  "offset": 1
}

Deleting a record with DELETE /records/{recordId}Sorting Data API results with the sort parameter