ByteChef LogoByteChef
OpenapiRows

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.

GET
/workspaces/{workspaceId}/data-tables/{name}/rows

Path Parameters

workspaceId*integer

The id of a workspace.

Formatint64
name*string

The table name.

Query Parameters

filter?array<string>

A column:OPERATOR:value condition. Repeat the parameter to add conditions.

sort?array<string>

A column:ASC or column:DESC ordering. Repeat to add tie-breakers; id:ASC is always last.

expand?array<string>

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.

pageNumber?integer

The zero-based page to return.

Formatint32
Default0
pageSize?integer

Rows per page; at most 500.

Formatint32
Default50

Header Parameters

X-Environment?string

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?