Parameters
| Parameter | Type | Default | Description |
|---|---|---|---|
limit | integer | 50 | Items per page (1-100) |
offset | integer | 0 | Items to skip |
Response format
| Field | Description |
|---|---|
total | Total number of items matching the query |
limit | Page size used |
offset | Number of items skipped |
has_more | Whether more items exist beyond this page |
Iterating through all results
Filtering and sorting
Most list endpoints support filtering and sorting via query parameters. Filters use operator-based syntax:| Operator | Example | Description |
|---|---|---|
eq.value | ?global_status=eq.new | Equals |
neq.value | ?global_status=neq.archived | Not equals |
gt.value | ?created_at=gt.2026-01-01 | Greater than |
gte.value | ?created_at=gte.2026-01-01 | Greater than or equal |
lt.value | ?amount=lt.50000 | Less than |
lte.value | ?amount=lte.50000 | Less than or equal |
like.%value% | ?first_name=like.%Sophie% | Case-sensitive match |
ilike.%value% | ?first_name=ilike.%sophie% | Case-insensitive match |
is.null | ?archived_at=is.null | Is null |
is.not_null | ?archived_at=is.not_null | Is not null |
sort parameter with - prefix for descending order: