Insert rows
curl --request POST \
--url https://api.airscale.io/v1/tables/{table_id}/rowsconst url = 'https://api.airscale.io/v1/tables/{table_id}/rows';
const options = {method: 'POST'};
fetch(url, options)
.then(res => res.json())
.then(json => console.log(json))
.catch(err => console.error(err));import requests
url = "https://api.airscale.io/v1/tables/{table_id}/rows"
response = requests.post(url)
print(response.text)Insert rows
Add up to 1,000 rows to a table. Rate limit: 10 write requests per minute per workspace, one write at a time per workspace, plus 60 requests per minute per API key. Rows count toward 5,000 rows per minute and 100,000 rows per UTC day per workspace.
POST
/
v1
/
tables
/
{table_id}
/
rows
Insert rows
curl --request POST \
--url https://api.airscale.io/v1/tables/{table_id}/rowsconst url = 'https://api.airscale.io/v1/tables/{table_id}/rows';
const options = {method: 'POST'};
fetch(url, options)
.then(res => res.json())
.then(json => console.log(json))
.catch(err => console.error(err));import requests
url = "https://api.airscale.io/v1/tables/{table_id}/rows"
response = requests.post(url)
print(response.text)Send
See limits, retries and error codes for shared behavior.
rows, each with values keyed by column ID. See column types and values for what each type accepts. An unknown column, a read-only column or a value of the wrong type rejects the whole request, and nothing is inserted.
If the table has a deduplication column, rows whose value already exists are skipped and counted in skipped. The status is 201 when at least one row was inserted and 200 when every row was skipped.
Inserting rows never starts an enrichment. Use an Idempotency-Key for retries to avoid inserting the same batch twice.
Paid plans only. No credits are charged. Limits: 10 write requests per minute per workspace, one write at a time per workspace, plus 60 requests per minute per API key. Rows count toward 5,000 rows per minute and 100,000 rows per UTC day per workspace. See the Tables API overview for every limit.
Authentication
SendAuthorization: Bearer $AIRSCALE_API_KEY. The key determines the workspace. See Authentication.
Parameters
| Name | Location | Required | Description |
|---|---|---|---|
table_id | path | Yes | Table ID returned by Create table or List tables. |
Idempotency-Key | header | No | Reuse the same key and identical body when retrying this operation. A changed body with the same key returns 409 idempotency_conflict. |
JSON body
| Field | Type | Required | Description |
|---|---|---|---|
rows | array | Yes | 1–1000 items. |
rows[].values | object | Yes | Cell values keyed by column ID. Strings for text, email, phone and url columns; finite numbers for number columns; any JSON value for json columns; null to leave or make a cell empty. |
Request example
Replace path variables with IDs returned by the API. Column UUIDs in the example body must belong to your table.curl --request POST "https://api.airscale.io/v1/tables/$TABLE_ID/rows" \
--header "Authorization: Bearer $AIRSCALE_API_KEY" \
--header "Idempotency-Key: insertTableRows-001" \
--header "Content-Type: application/json" \
--data '{
"rows": [
{
"values": {
"0d9f2756-17db-42e5-b9d5-1e1c564a1079": "Alex Martin",
"7711ed25-4a90-413d-96e0-67ed2341b1ca": "alex@example.com",
"c3a1f7e2-5b8d-4e6f-9a2b-1d4c7e8f0a3b": 120
}
},
{
"values": {
"0d9f2756-17db-42e5-b9d5-1e1c564a1079": "Sam Lee",
"7711ed25-4a90-413d-96e0-67ed2341b1ca": "sam@example.com"
}
}
]
}'
Response
200
Every row was a duplicate; nothing was inserted.{
"rows": [],
"skipped": 2
}
201
Rows were inserted.{
"rows": [
{
"id": "5108e497-fcb8-48c9-8704-74e73094f2d4",
"values": {
"0d9f2756-17db-42e5-b9d5-1e1c564a1079": "Alex Martin",
"7711ed25-4a90-413d-96e0-67ed2341b1ca": "alex@example.com",
"c3a1f7e2-5b8d-4e6f-9a2b-1d4c7e8f0a3b": 120
},
"createdAt": "2026-10-28T09:15:02.481Z",
"updatedAt": "2026-10-28T09:15:02.481Z"
}
],
"skipped": 0
}
Errors
| Status | Meaning |
|---|---|
| 400 | Invalid body, unknown or read-only column, or a value of the wrong type. |
| 401 | Missing or invalid API key. |
| 403 | The workspace does not have an active paid plan. |
| 404 | Table not found in this workspace, or deleted. |
| 409 | A conflicting table operation, such as a CSV import, is running. |
| 413 | Body larger than 8 MiB, or a row larger than 5 MiB. |
| 429 | A rate limit, the one-write-at-a-time rule or a daily limit was reached. Wait for Retry-After before retrying. |
| 502 | The service could not be reached. Retry with backoff. |
| 503 | The service is at capacity or temporarily unavailable. Retry after Retry-After. |
| 504 | The request timed out after 30 seconds. A write may still have been applied; check the result before retrying it. |