Airtable · JSON Structure

Airtable Record Structure

An Airtable record representing a single row in a table. Records are the fundamental data units in Airtable, containing field values that correspond to the table's column definitions.

Type: object Properties: 3 Required: 3
ApplicationsCollaborationDataDatabasesLow-CodeProductivitySpreadsheets

Airtable Record is a JSON Structure definition published by Airtable, describing 3 properties, of which 3 are required. It conforms to the https://json-structure.org/meta/core/v0/# meta-schema.

Properties

id createdTime fields

Meta-schema: https://json-structure.org/meta/core/v0/#

JSON Structure

Raw ↑ 
{
  "$schema": "https://json-structure.org/meta/core/v0/#",
  "$id": "https://raw.githubusercontent.com/api-evangelist/airtable/refs/heads/main/json-structure/airtable-record-structure.json",
  "name": "Airtable Record",
  "description": "An Airtable record representing a single row in a table. Records are the fundamental data units in Airtable, containing field values that correspond to the table's column definitions.",
  "type": "object",
  "properties": {
    "id": {
      "type": "string",
      "description": "The unique identifier for the record. Record IDs always start with the 'rec' prefix.",
      "pattern": "^rec[a-zA-Z0-9]+$",
      "examples": [
        "recABC123def456"
      ]
    },
    "createdTime": {
      "type": "datetime",
      "description": "The date and time when the record was created, in ISO 8601 format."
    },
    "fields": {
      "type": "object",
      "description": "A mapping of field names (or field IDs when returnFieldsByFieldId is enabled) to their cell values. The keys and value types depend on the table's schema definition.",
      "additionalProperties": true
    }
  },
  "required": [
    "id",
    "createdTime",
    "fields"
  ],
  "additionalProperties": false
}