Skip to main content
read_table

Authorizations

Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Body

application/json
tableId
string
required

Table or worksheet id.

Minimum string length: 1
Pattern: ^[A-Za-z0-9_-]+$
limit
integer

Defaults to 100.

Required range: 1 <= x <= 1000
offset
integer

Zero-based row offset.

Required range: 0 <= x <= 9007199254740991
columnIds
string[]

Columns to return; omit for all.

Maximum array length: 50

Column id, not its label.

Minimum string length: 1
orderBy
object[]

Sort keys in priority order. Ties break on the primary key except on external tables, so their pages can overlap.

Maximum array length: 10
where
object[]

AND-combined filters. They narrow within any admin Table View filters, which the server applies to every read and aggregation.

Maximum array length: 20
arrayExpansions
object[]

Explode array columns into one row per element, referenced by alias; empty arrays yield no rows, and counts describe elements, not records.

Maximum array length: 3

Response

200

Tool result.