- Offset-based (AG-Grid model) — used by POST endpoints that return tabular data. Covered in detail on this page.
- Typesense page/per_page — used by the
/search-public/*endpoints. See the Public Search group for query-string parameters.
Offset-based pagination
Tabular endpoints (companies at an address, watchlist members, person companies, etc.) accept a POST request whose JSON body specifies the row range, sort order, and filters.Request body
The page size is
endRow - startRow. For example, startRow: 0, endRow: 50 returns the first 50 rows.
Response
How to paginate
Uselastrow to determine if there are more pages:
lastrow == -1— more rows available, request the next pagelastrow >= 0— this is the last page,lastrowis the total row count
Sorting
Add asortModel array to sort by one or more columns:
Filtering
Add afilterModel object to filter results server-side. Each key is a column name; the value describes the filter.
Text filter
Number filter
Date range filter
Set filter (match any of the values)
Multiple conditions on the same column
Supported filter operators
Combining conditions
Use theoperator field with "AND" or "OR" to combine multiple conditions on the same column.