v13

latestOpenAPI 3.1.0Apache 2.0raw.githubusercontent.com2026-08-015232292.9 KB
Tables

List Rows

Query rows from a table with optional filtering, sorting, and pagination. Filters and sorts are passed as JSON-encoded query parameters.

get/api/v1/tables/{tableId}/rows

Path parameters

tableIdstring required
Example:tbl_92e4c6a8b0d24f1e8a3c5d7b9f0e2a14

The unique identifier of the table.

Query parameters

workspaceIdstring required

The unique identifier of the workspace.

filterstring

JSON-encoded filter object. Example: {"status": "active"} or {"age": {"$gt": 18}}.

sortstring

JSON-encoded sort object. Example: {"createdAt": "desc"}. Built-in columns are camelCase: id, createdAt, updatedAt.

limitinteger

Maximum rows to return (1-1000, default 100).

offsetinteger

Number of rows to skip for pagination (default 0).

Response

Rows matching the query.

successboolean

Indicates whether the request was successful.

Example response

{
  "data": {
    "rows": [
      {
        "id": "row_6b8d0f2a4c3e4e5da28f7c9b1d3f5a07"
      }
    ]
  }
}