ORorigami
Workspace

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

Changed on

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

Request

  • Base URL
    https://origami.chat/api/v2
  • URL
    https://origami.chat/api/v2/tables/{tableId}/rows
  • Auth
    HTTP bearer

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, or one of the row-level fields (relevance_score, duplicates, excluded, disapproved, triage_state); 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. Supplying this replaces the table's saved filters entirely, even when the array is empty.

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'

Whether to apply the table's saved filters and sort order - the same ones shown in the Origami dashboard. Defaults to true. Most tables carry a quality filter that hides disqualified rows, so this is usually the difference between the dashboard's row count and the full table. Pass false to get every row, in insertion order.

Duplicate, excluded and removed rows are hidden by default on every read; defaults=false does not surface them. Include them with an explicit filter ({"column":"duplicates","operator":"equals","value":"include"}, likewise excluded and disapproved), or leave defaults=true on a table whose saved view already unhides them.

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) - i.e. after the request's filters, or the table's saved filters when defaults is left on, and always after the invariant hiding of duplicate, excluded and removed rows.

Changes