Guides/Pagination & filters

Pagination & filters

Cursor pagination and equality filters on list records.

Pagination & filters

GET /tables/{tableId}/records uses a cursor (keyset of created_at,id descending). This API is table records only.

Cursors

Each list response includes next_cursor. Pass it back as cursor:

# First page
GET /tables/{tableId}/records?limit=50

# Next page
GET /tables/{tableId}/records?limit=50&cursor=<opaque-string>

When next_cursor is null, you have reached the end. Default limit is 50, maximum 100.

GET /tables returns the full catalog (no cursor).

Filtering

Only equality on stored, non-computed columns. Query:

?{exactColumnName}=eq.{urlencodedValue}

Examples:

?Status=eq.Open
?Status=eq.Open&Priority=eq.High

Type	Compare
TEXT, EMAIL, PHONE, URL, SELECT	string equality on the stored field
BOOLEAN	`true` or `false`
NUMBER	finite number
DATETIME	ISO-8601 string equality

Unknown column → 422. Computed / FILE / REFERENCE / MULTISELECT / LONGTEXT → 400 filter.unsupported. No gt / like / in / OR. No sort parameter — order is always newest first.