Web API

Press shift + S to search API reference.

Tables

Create table

posthttps://api.airtable.com/v0/meta/bases/{baseId}/tables

Creates a new table and returns the schema for the newly created table.

Refer to field types for supported field types, the write format for field options, and other specifics for certain field types. Supported field types have a write format shown.

At least one field must be specified. The first field in the fields array will be used as the table's primary field and must be a supported primary field type. Fields must have case-insensitive unique names within the table.

A default grid view will be created with all fields visible.

Requirements

AuthenticationPersonal access token, OAuth integration
Scopeschema.bases:write
User role

Base creator

Billing plansAll plans

Path parameters

baseId
string

Request body

name
string

The name for the table.

description
optional<string>

The description for the table (optional). If present, must be a non-empty string no longer than 20,000 characters.

fields
array of Field Configs

A list of JSON objects representing the fields in the table. Refer to field types for supported field types, the write format for field options, and other specifics for certain field types.

Response format

Table model
Request (example)
Copy
$
curl -X POST "https://api.airtable.com/v0/meta/bases/{baseId}/tables" \
-H "Authorization: Bearer YOUR_TOKEN" \
-H "Content-Type: application/json" \
--data '{
"description": "A to-do list of places to visit",
"fields": [
{
"description": "Name of the apartment",
"name": "Name",
"type": "singleLineText"
},
{
"name": "Address",
"type": "singleLineText"
},
{
"name": "Visited",
"options": {
"color": "greenBright",
"icon": "check"
},
"type": "checkbox"
}
],
"name": "Apartments"
}'
200 – Response (example)
{
"description": "A to-do list of places to visit",
"fields": [
{
"description": "Name of the apartment",
"id": "fld1VnoyuotSTyxW1",
"name": "Name",
"type": "singleLineText"
},
{
"id": "fldoi0c3GaRQJ3xnI",
"name": "Address",
"type": "singleLineText"
},
{
"id": "fldumZe00w09RYTW6",
"name": "Visited",
"options": {
"color": "redBright",
"icon": "star"
},
"type": "checkbox"
}
],
"id": "tbltp8DGLhqbUmjK1",
"name": "Apartments",
"primaryFieldId": "fld1VnoyuotSTyxW1",
"views": [
{
"id": "viwQpsuEDqHFqegkp",
"name": "Grid view",
"type": "grid"
}
]
}