Get table rows - Autotouch AI

This page documents the canonical HTTP contract for this endpoint.

The response sample is abridged; the serializer also returns cellStatus and cellStates. Each row is a flattened row read-model object. Use projection=grid when you only need visible-column values; hidden-column values are omitted in that projection.

Path parameters

table_idrequired
string
The table ID.

Name	Type	Description
table_idrequired	string	The table ID.

Query parameters

page_size · optional
integer
Rows per page (1–1000; default 50).
cursor · optional
string
Pagination cursor from a previous response.
projection · optional
string
Optional grid projection. projection=grid omits values for hidden columns from each row; the default projection includes them. This controls response shape and does not change table data.
filters · optional
string
JSON object with filters[] entries (columnKey, operator; optional columnId/jsonPath, value/value2; jsonPath requires columnId) and mode and/or (default and). Operators: equals, notEquals, contains, notContains, startsWith, endsWith, isEmpty, isNotEmpty, in, notIn, greaterThan, greaterThanOrEqual, lessThan, lessThanOrEqual, between, isTrue, isFalse, before, after, dateBetween. between/dateBetween require value and value2; empty/boolean operators take neither.
sort · optional
string
JSON object with column (column key) and direction (asc or desc). Example: {"column":"name","direction":"asc"}; sort is applied when both fields are present.

Name	Type	Description
page_size	integer	Rows per page (1–1000; default 50).
cursor	string	Pagination cursor from a previous response.
projection	string	Optional grid projection. projection=grid omits values for hidden columns from each row; the default projection includes them. This controls response shape and does not change table data.
filters	string	JSON object with filters[] entries (columnKey, operator; optional columnId/jsonPath, value/value2; jsonPath requires columnId) and mode and/or (default and). Operators: equals, notEquals, contains, notContains, startsWith, endsWith, isEmpty, isNotEmpty, in, notIn, greaterThan, greaterThanOrEqual, lessThan, lessThanOrEqual, between, isTrue, isFalse, before, after, dateBetween. between/dateBetween require value and value2; empty/boolean operators take neither.
sort	string	JSON object with column (column key) and direction (asc or desc). Example: {"column":"name","direction":"asc"}; sort is applied when both fields are present.

Errors

Status	Meaning
400	Invalid filter or sort JSON.
401	Authentication required.
403	Access denied.
404	Table not found.

Example

bash

curl -X GET "https://app.autotouch.ai/api/tables/67bd.../rows?page_size=25" \
  -H "Authorization: Bearer stk_your_key_id.your_secret"

Response example

json

{
  "rows": [
    {
      "_id": "67bd8c39c7d3e80f0a95b563",
      "table_id": "67bd8c39c7d3e80f0a95b560",
      "position": 0,
      "company_name": "Acme Corp",
      "website": "acme.com"
    }
  ],
  "cellStatus": {},
  "cellStates": {},
  "nextCursor": "eyJ...",
  "totalCount": 1247,
  "hasMore": true,
  "unfilteredTotalCount": 1500
}