v1

latestOpenAPI 3.1.02026-07-267154122.0 KB

Workspace

List rows (typed cells; ?cells=flat / ?format=csv)

Returns Row objects ({ object: "row", id, cells }) with polymorphic typed cells by default (scalar / value (+run) / sequence), in the canonical list envelope plus total (the filtered row count for the query's scope). ?cells=flat returns the v1-style { slug: value } rows (deliberately unstamped); ?format=csv streams CSV. Supports slug-keyed filters / sort JSON and cursor pagination — this endpoint allows limit up to 200.

get/tables/{tableId}/rows

Query parameters

cursorstring

Opaque pagination cursor. Pass the nextCursor from the previous page to fetch the next one; omit for the first page.

limitinteger

Max rows to return. Default 50; rows allow up to 200 (vs. 100 elsewhere).

filtersstring

JSON array of { column, operator, value } filters. column is an input-column slug; operators: contains, not_contains, equals, not_equals, is_empty, is_not_empty, greater_than, greater_than_or_equal, less_than, less_than_or_equal. Unknown columns → UNKNOWN_COLUMN.

sortstring

JSON object { column, direction: "asc"|"desc" } (slug-keyed).

cells'flat'

Pass flat for v1-style { slug: value } rows instead of typed cells.

format'csv'

Pass csv to stream the (flat) rows as CSV.

defaults'true' | 'false'

Pass false to disable the table's default filters/sort.

Response

A page of rows (list envelope + total).

object'list' required

nextCursorstring nullable required

Cursor for the next page; null means this is the last page.

urlstring required

The path this list was fetched from (query string excluded).

totalinteger required

Total row count for the query's scope (all pages).