> ## Documentation Index
> Fetch the complete documentation index at: https://docs.airscale.io/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.

Send `rows`, each with `values` keyed by column ID. See [column types and values](https://docs.airscale.io/api-reference/tables/overview.md#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.

> [!NOTE]
>
> 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](https://docs.airscale.io/api-reference/tables/overview.md) for every limit.

## Authentication

Send `Authorization: Bearer $AIRSCALE_API_KEY`. The key determines the workspace. See [Authentication](https://docs.airscale.io/api-reference/authentication.md).

## 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.

```bash theme={"theme":{"light":"github-light","dark":"github-dark"}}
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.

```json theme={"theme":{"light":"github-light","dark":"github-dark"}}
{
  "rows": [],
  "skipped": 2
}
```

### 201

Rows were inserted.

```json theme={"theme":{"light":"github-light","dark":"github-dark"}}
{
  "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. |

See [limits, retries and error codes](https://docs.airscale.io/api-reference/tables/overview.md#limits) for shared behavior.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.