Query rows
Query rows. Filters are ANDed; each is `column:OPERATOR:value` with OPERATOR one of EQ, NEQ, IN, CONTAINS, STARTS_WITH, GT, GTE, LT, LTE, BETWEEN. IN and BETWEEN take comma-separated values. `id` and `externalId` may be filtered and sorted like any column. The `where` parameter is reserved for a future expression filter and must not be sent.
Path Parameters
The id of a workspace.
int64The table name.
Query Parameters
A column:OPERATOR:value condition. Repeat the parameter to add conditions.
A column:ASC or column:DESC ordering. Repeat to add tie-breakers; id:ASC is always last.
Comma-separated link column names whose values are returned as the linked row object {id, externalId, values} instead of the linked row id. One level deep.
The zero-based page to return.
int320Rows per page; at most 500.
int3250Header Parameters
The environment whose physical table is addressed. PRODUCTION when omitted.
Value in
- "DEVELOPMENT"
- "STAGING"
- "PRODUCTION"
Response Body
application/json
application/problem+json
application/problem+json
curl -X GET "https://example.com/workspaces/0/data-tables/string/rows"{ "number": 0, "size": 0, "numberOfElements": 0, "totalPages": 0, "totalElements": 0, "content": [ { "id": 0, "externalId": "string", "values": {} } ]}How is this guide?