List records

GET/v1/bases/{baseId}/records

Authorization

bearerAuth

AuthorizationBearer <token>

API token issued from the dashboard (Settings → API Tokens). Sent as Authorization: Bearer <token>.

In: header

Query Parameters

tableId*string

Required. Identifies which table inside the base to read from.

Match

^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$

Formatuuid

limit?integer

Default100

Range1 <= value <= 1000

offset?integer

Default0

Range0 <= value <= 9007199254740991

sort?string

Sort spec fieldId:asc|desc (bare fieldId = asc). Repeatable for multi-level sort — first is primary, max 3 levels.

fields?string

Comma-separated field ids to project the returned data down to.

filterByField?string

Simple equality filter fieldId=value. Repeatable — multiple values are AND-combined.

filter?string

JSON FilterGroup for advanced filtering: {"logic":"and|or","conditions":[{"fieldId":"...","operator":"...","value":"..."}]}. When both filter and filterByField are present, filter wins. Malformed filters return 400.

Response Body

`application/json`

cURL

curl -X GET "https://example.com/bases/497f6eca-6276-4993-bfeb-53cbbbba6f08/records?tableId=497f6eca-6276-4993-bfeb-53cbbbba6f08"

{
  "records": [
    {
      "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
      "tableId": "073fbfcb-cd05-4203-be18-a1ce6f8e4d2d",
      "orgId": "25b2c2d5-a7fc-47d0-89e4-8709a1560bfa",
      "data": {
        "property1": null,
        "property2": null
      },
      "computedData": {
        "property1": null,
        "property2": null
      },
      "version": -9007199254740991,
      "createdBy": "25a02396-1048-48f9-bf93-102d2fb7895e",
      "updatedBy": "b0efe45f-0520-4e21-90f0-7e35f137732e",
      "createdAt": "2019-08-24T14:15:22Z",
      "updatedAt": "2019-08-24T14:15:22Z"
    }
  ],
  "pagination": {
    "limit": -9007199254740991,
    "offset": -9007199254740991,
    "total": 0,
    "hasMore": true
  }
}

{
  "error": "validation_failed",
  "message": "string",
  "issues": null
}

{
  "error": "unauthorized"
}

{
  "success": false,
  "error": "API key lacks write permission"
}

Authorization

Path Parameters

Query Parameters

Response Body

200application/json

400application/json

401application/json

403application/json

`application/json`

`application/json`

`application/json`

`application/json`