Skip to main content
GET
/
tables
/
{tableId}
/
rows
Read table rows
curl --request GET \
  --url https://origami.chat/api/v1/tables/{tableId}/rows \
  --header 'Authorization: Bearer <token>'
{ "columns": {}, "rows": [ { "id": "3c90c3cc-0d44-4b50-8888-8dd25736052a" } ], "total": 123, "page": 123, "pageSize": 123 }

Authorizations

​
Authorization
string
header
required

API key with og_live_ prefix. Create keys in Settings → API Keys.

Pass in the Authorization header:

Authorization: Bearer og_live_abc123...

Path Parameters

​
tableId
string<uuid>
required

The table UUID. Use GET /tables to list available tables.

Query Parameters

​
page
integer
default:0

Zero-based page index.

Required range: x >= 0
​
pageSize
integer
default:50

Number of rows per page (max 500).

Required range: 1 <= x <= 500
​
filters
string

JSON-encoded array of filter objects. Each filter uses a column slug (from GET /tables), an operator, and a value.

Operators: contains, not_contains, equals, not_equals, is_empty, is_not_empty, greater_than, greater_than_or_equal, less_than, less_than_or_equal.

When provided, the table's default filters are replaced by these.

​
sort
string

JSON-encoded sort object with a column slug and direction. When provided, the table's default sort is replaced by this.

​
columns
string

Comma-separated list of column slugs to include in the response. Omit to return all columns. Use slugs from GET /tables.

​
defaults
enum<string>
default:true

Whether to apply the table's saved filters and sort order (the same ones shown in the Origami dashboard). Set to false to get all rows unfiltered, in insertion order.

Available options:
true,
false
​
format
enum<string>
default:json

Response format. Use csv for spreadsheet-compatible export.

Available options:
json,
csv

Response

Rows retrieved successfully.

​
columns
object
required

Map of column slug → display name. Use this to resolve the slug keys in each row object to human-readable column names.

​
rows
object[]
required
​
total
integer
required

Total number of rows matching the query (before pagination).

​
page
integer
required

Current page index (zero-based).

​
pageSize
integer
required

Number of rows per page.