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).

Changes

No recorded changes to this endpoint across all 1 revision of this API.