Skip to main content
GET
/
bases
/
{databaseId}
/
tables
/
{tableId}
/
records
/
{recordId}
Get record by ID
curl --request GET \
  --url https://tables.fillout.com/api/v1/bases/{databaseId}/tables/{tableId}/records/{recordId} \
  --header 'Authorization: Bearer <token>'
{
  "id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "fields": {
    "Name": "John Doe",
    "Email": "john.doe@newcompany.com",
    "Priority": "low"
  },
  "record": {
    "fwtJyga6dso": "John Doe",
    "k8mNp2xQ9rL": "john.doe@newcompany.com",
    "vB3zXc7Hf2w": "low"
  },
  "createdAt": "2023-11-07T05:31:56Z",
  "updatedAt": "2023-11-07T05:31:56Z"
}
Fetches a single record by its unique identifier with all field data using either the table ID or table name.

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.

​
recordId
string<uuid>
required

The UUID of the record

Response

Record details

​
id
string<uuid>
required

Unique UUID identifier for the record

​
fields
object
required

Record data with field names as keys

Example:
{
  "Name": "John Doe",
  "Email": "john.doe@newcompany.com",
  "Priority": "low"
}
​
record
object
required

Record data with field IDs as keys

Example:
{
  "fwtJyga6dso": "John Doe",
  "k8mNp2xQ9rL": "john.doe@newcompany.com",
  "vB3zXc7Hf2w": "low"
}
​
createdAt
string<date-time>
required

ISO timestamp of when the record was created

​
updatedAt
string<date-time>
required

ISO timestamp of when the record was last updated

⌘I