List rows
Read rows with optional field selection and pagination.
Request
GET /v1/lookup-tables/{table_id}/rows
Lists a table's rows, one page at a time. To find rows by their values, use Query rows.
Requires lookup_tables:read. The connection also needs access to the relevant tables, objects, or workflows.
MCP action: list_lookup_rows. Its argument names match the fields below; an HTTP header is passed using its argument name in MCP.
Parameters
| Name | Send in | Required | Type or allowed values | Notes |
|---|---|---|---|---|
table_id |
path | Yes | string | |
fields |
query | No | array of string | Repeat this query parameter or separate its values with commas. |
limit |
query | No | integer | Default: 100. |
cursor |
query | No | string | |
segment |
query | No | integer | Default: 0. |
total_segments |
query | No | integer | Default: 1. |
Response
| HTTP status | Result |
|---|---|
200 |
A page of rows, in id order. |
Required fields are required within their containing object. Notes identify fields that apply only to a particular response alternative.
| Response field | Type | Required in object | Notes |
|---|---|---|---|
data |
array of object | Yes | |
data[].id |
string (uuid) | Yes | |
data[].object |
"lookup_row" |
Yes | |
data[].values |
object | Yes | |
data[].version |
integer | Yes | |
data[].roster_verified_at |
string (date-time) | No | |
pagination |
object | Yes | |
pagination.next_cursor |
string or null | Yes |
Errors
| HTTP status | Meaning |
|---|---|
400 |
One of: invalid_request, invalid_filter, invalid_value, invalid_cursor, credential_in_url. |
401 |
One of: missing_credential, invalid_credential, credential_expired, credential_revoked. |
402 |
One of: payment_overdue. |
403 |
One of: plan_required, not_available, insufficient_scope, operation_not_allowed, field_not_writable, plan_capacity_exceeded. |
404 |
One of: resource_not_found. |
409 |
One of: table_filling, table_fill_failed, lookup_key_required, key_conflict, version_conflict, table_busy, table_capacity_exceeded, idempotency_conflict. |
413 |
One of: request_too_large. |
422 |
One of: batch_rejected. |
423 |
One of: organization_reopening. |
428 |
One of: customer_agreement_required. |
429 |
One of: rate_limited. |
503 |
One of: service_unavailable. |
See errors and recovery and safe retries before repeating a write.
The public OpenAPI document lists generally available API families. Alpha operations may not appear in that document; their request and response fields are listed on this page. Use the API Playground to inspect a real response with your connection's access.