Skip to content

Tables

List rows

List rows in default order with cursor pagination. Pages default to a 5 MiB limit and may contain fewer rows than requested; continue until `nextCursor` is null. Use Query rows for filtering and sorting. `includeRunState=true` adds per-group run outcomes and reduces the row limit. OAuth scope: `api:read`.

GET/api/v2/tables/{tableId}/rows

List rows in default order with cursor pagination. Pages default to a 5 MiB limit and may contain fewer rows than requested; continue until nextCursor is null. Use Query rows for filtering and sorting. includeRunState=true adds per-group run outcomes and reduces the row limit.

OAuth scope: api:read.

Authentication

Send a personal or workspace API key in X-API-Key. See key types and access; operations that reject workspace keys say so in their description.

Send X-API-Key in the request header.

Alternatively

Send a Sim OAuth access token in Authorization: Bearer. See OAuth authentication and scopes.

Authorization: Bearer YOUR_ACCESS_TOKEN

Required scopes: api:read

OAuth flows
json
{
  "authorizationCode": {
    "authorizationUrl": "https://www.sim.ai/api/auth/oauth2/authorize",
    "tokenUrl": "https://www.sim.ai/api/auth/oauth2/token",
    "refreshUrl": "https://www.sim.ai/api/auth/oauth2/token",
    "scopes": {
      "api:read": "Read your workspaces, workflows, files, tables, and logs",
      "api:write": "Read, create, change, run, and delete resources in your workspaces",
      "offline_access": "Stay signed in without asking again"
    }
  }
}

OAuth scope: api:read.

Path parameters

tableIdstringRequired

Unique table identifier.

minLength
1

Query parameters

workspaceIdstringRequired

Workspace that owns the table.

minLength
1
maxLength
128
limitinteger

Maximum rows to return per page. Must be a whole number from 1 to 1000. Defaults to 100.

default
100
minimum
1
maximum
1000
cursorstring

Opaque cursor from the previous page. Send it back with the same sort and filters; only limit may change. Change anything else and pagination must restart without a cursor.

minLength
1
includeRunStateboolean

Include per-workflow-group run outcomes on every row. Off by default. Caps limit at 200. Run state above 2 MiB returns 413; request fewer rows or omit run state.

Responses

200

A page of table rows.

object

A cursor-paginated page of table rows.

2 fields
dataarrayRequired

Items in the current page.

Schema details
Array itemobject

A table row with user-defined cell values.

5 fields
idstringRequired

Unique row identifier.

dataobjectRequired

Row cells keyed by column name.

Schema details
Additional propertiesvalue

User-defined cell value interpreted by its column definition.

runStateobject

Per-workflow-group run state keyed by group identifier. Present only when the read requested includeRunState.

Schema details
Additional propertiesobject

Run outcome for one workflow group on one row.

7 fields
statusstringRequired

Lifecycle state of the most recent run for this cell: pending, queued, running, completed, error, or canceled.

executionIdvalueRequired

Workflow execution identifier, or null before a worker claimed the cell.

Schema details

Any of

Option 1string
Option 2null
workflowIdstringRequired

Workflow the group runs for this cell.

errorvalueRequired

Failure reason, or null when the run did not fail.

Schema details

Any of

Option 1string
Option 2null
runningBlockIdsarrayRequired

Block identifiers currently mid-execution.

Schema details
Array itemstring
blockErrorsobjectRequired

Per-block failure messages keyed by block identifier.

Schema details
Additional propertiesstring
canceledAtvalueRequired

ISO 8601 timestamp when the cell was canceled, or null.

Schema details

Any of

Option 1string
format
date-time
pattern
^(?:(?:\d\d[2468][048]|\d\d[13579][26]|\d\d0[48]|[02468][048]00|[13579][26]00)-02-29|\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\d|30)|(?:02)-(?:0[1-9]|1\d|2[0-8])))T(?:(?:[01]\d|2[0-3]):[0-5]\d(?::[0-5]\d(?:\.\d+)?)?(?:Z))$
Option 2null

Additional properties are not allowed.

createdAtstringRequired

ISO 8601 timestamp when the row was created.

format
date-time
pattern
^(?:(?:\d\d[2468][048]|\d\d[13579][26]|\d\d0[48]|[02468][048]00|[13579][26]00)-02-29|\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\d|30)|(?:02)-(?:0[1-9]|1\d|2[0-8])))T(?:(?:[01]\d|2[0-3]):[0-5]\d(?::[0-5]\d(?:\.\d+)?)?(?:Z))$
updatedAtstringRequired

ISO 8601 timestamp when the row was last modified.

format
date-time
pattern
^(?:(?:\d\d[2468][048]|\d\d[13579][26]|\d\d0[48]|[02468][048]00|[13579][26]00)-02-29|\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\d|30)|(?:02)-(?:0[1-9]|1\d|2[0-8])))T(?:(?:[01]\d|2[0-3]):[0-5]\d(?::[0-5]\d(?:\.\d+)?)?(?:Z))$

Additional properties are not allowed.

nextCursorvalueRequired

Opaque cursor for the next page. Send it back as cursor; null means there are no more pages. Do not construct a cursor yourself.

Schema details

Any of

Option 1string
Option 2null

Additional properties are not allowed.

Response headers

X-RateLimit-Limitinteger

Maximum requests allowed in the current window.

minimum
0
maximum
9007199254740991
X-RateLimit-Remaininginteger

Requests remaining in the current window.

minimum
0
maximum
9007199254740991
X-RateLimit-Resetstring

ISO 8601 timestamp when the current rate-limit window resets.

format
date-time
pattern
^(?:(?:\d\d[2468][048]|\d\d[13579][26]|\d\d0[48]|[02468][048]00|[13579][26]00)-02-29|\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\d|30)|(?:02)-(?:0[1-9]|1\d|2[0-8])))T(?:(?:[01]\d|2[0-3]):[0-5]\d(?::[0-5]\d(?:\.\d+)?)?(?:Z))$
Was this helpful?
Suggest an edit