Skip to main content
POST
/
bases
/
{databaseId}
/
tables
/
{tableId}
/
records
/
list
List records
curl --request POST \
  --url https://tables.fillout.com/api/v1/bases/{databaseId}/tables/{tableId}/records/list \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '{
  "filters": {
    "Name": {
      "contains": "John"
    },
    "Age": {
      "gte": 18,
      "lt": 65
    },
    "Status": {
      "in": [
        "Active",
        "Pending"
      ]
    },
    "Department": {
      "not": "Admin"
    }
  },
  "limit": 100,
  "offset": 0
}'
{
  "records": [
    {
      "id": "rec_abc123",
      "fields": {
        "Name": "John Doe",
        "Email": "john.doe@newcompany.com",
        "Priority": "low"
      },
      "record": {
        "fwtJyga6dso": "John Doe",
        "k8mNp2xQ9rL": "john.doe@newcompany.com",
        "vB3zXc7Hf2w": "low"
      },
      "createdAt": "2024-01-01T00:00:00.000Z",
      "updatedAt": "2024-01-01T00:00:00.000Z"
    }
  ],
  "hasMore": true,
  "offset": "eyJpZCI6InJlY19hYmMxMjMifQ=="
}
Fetches records from a table with advanced filtering, sorting, and pagination options using either the table ID or table name.
  • Supports various filter operators (contains, in, not, lt, gt, etc.)
  • Results can be sorted by any field ID
  • Pagination available with offset/limit or cursor-based approach

Authorizations

​
Authorization
string
header
required

Enter your Fillout API key. Format: Bearer <api_key>

Path Parameters

​
databaseId
string
required

The unique identifier of the database

​
tableId
string
required

The unique identifier of the table. You can also use the table name instead of the ID.

Body

application/json
​
limit
integer
default:500

Number of records to return (1-2000, default: 500)

Required range: 1 <= x <= 2000
​
offset
integer
default:0

Number of records to skip for pagination

Required range: x >= 0
​
filters
object

Filter conditions using field IDs or field names as keys. Supports exact matches, operators (contains, not, in, notIn, lt, lte, gt, gte), and select field filtering

Response

List of records

​
records
object[]
required

Array of records

​
hasMore
boolean
required

Whether there are more records available beyond this page

​
offset
string | null
required

Offset string for next page of results, or null if no more pages

⌘I