Skip to main content
POST
List records
Fetches records from a table with advanced filtering, sorting, and pagination options using either the table ID or table name.

Pagination

Use hasMore to determine if additional pages exist. Increment offset by limit for each subsequent request.

Sorting

When no sort parameter is provided, records are returned in ascending order by creation time (createdAt ASC).
fieldId is also accepted for backward compatibility, but field is preferred.

Filtering

Use the filter parameter to query records. Filters support nested AND/OR logic for complex queries.
Use and or or to combine multiple conditions:
Filters can be nested for complex logic:
Filter by single select:
Filter by number range:
Filter by date:
Filter by multiple values:
Filter for empty/non-empty:

Authorizations

Authorization
string
header
required

Enter your Zite API key. Format: Bearer <api_key>

Path Parameters

databaseId
string
required

The unique identifier of the database

tableId
string
required

The unique identifier of the table. You can also use the table name instead of the ID.

Body

application/json
limit
integer
default:500

Number of records to return (default: 500, max: 2000)

Required range: 1 <= x <= 2000
offset
integer
default:0

Integer-based offset - Number of records to skip for pagination

Required range: x >= 0
sort
object[]

Array of sort objects. When not provided, records are returned in ascending order by creation time (createdAt ASC). All queries include an internal tie-breaker to ensure deterministic ordering across paginated requests.

filter
object

Filter condition to query records. Supports nested AND/OR logic. Each condition requires field (field ID or name) and one operator (equals, does_not_equal, contains, greater_than, in, etc.). See Filtering documentation for details.

Example:

Response

List of records

records
object[]
required

Array of records

total
integer
required

Total number of records matching the query

hasMore
boolean
required

Whether there are more records available beyond this page

Last modified on April 28, 2026