Pagination with _offset and _limit

Expert

Retrieve large record sets page by page using _offset and _limit query parameters to avoid timeouts and oversized responses.

What you'll learn

How _offset and _limit parameters control which records are returned
How to detect when you have reached the last page
A practical loop pattern for fetching all records across pages

The FileMaker Data API returns up to 100 records by default and up to 100,000 per request. For large found sets, paginating with _offset and _limit keeps response times predictable, avoids memory pressure on both client and server, and lets you process results incrementally.

1/3

_offset and _limit parameters

_limit sets the maximum number of records to return (max 100,000). _offset sets the starting position (0-based). Combine them to page through a found set.

HTTP

GET /fmi/data/v1/databases/MyDB/layouts/Contacts/records
  ?_limit=100&_offset=0    // page 1: records 1–100
  ?_limit=100&_offset=100  // page 2: records 101–200
  ?_limit=100&_offset=200  // page 3: records 201–300

Data API best practices: sessions, scripts, and rate limits Handling FileMaker Data API errors