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

# Insert Rows

> Insert one or more rows into a table

## Path Parameters

<ParamField path="id" type="string" required>
  Table ID
</ParamField>

## Request

Provide either:

* A single row object, or
* An array of row objects (max 100 rows)

Keys should match table column names.

## Response

For single-row inserts, the API returns one row object.

For multi-row inserts, the API returns:

<ResponseField name="rows" type="array">
  Inserted row objects
</ResponseField>

Each row includes:

<ResponseField name="id" type="string">
  Row ID (e.g., `row_abc123xyz789`)
</ResponseField>

<ResponseField name="_meta" type="object">
  Row metadata (`created_at`, `created_by`, `updated_at`, `updated_by`)
</ResponseField>

<RequestExample>
  ```bash cURL theme={null}
  curl -X POST https://api.crewship.dev/v1/tables/tbl_abc123xyz789/rows \
    -H "Authorization: Bearer YOUR_API_KEY" \
    -H "Content-Type: application/json" \
    -d '[
      {"company": "Acme", "score": 92, "status": "qualified"},
      {"company": "Beta", "score": 70, "status": "new"}
    ]'
  ```
</RequestExample>

<ResponseExample>
  ```json Success theme={null}
  {
    "rows": [
      {
        "id": "row_abc123xyz789",
        "company": "Acme",
        "score": 92,
        "status": "qualified",
        "_meta": {
          "created_at": "2024-01-15T10:35:00Z",
          "created_by": "api:Production Key",
          "updated_at": "2024-01-15T10:35:00Z",
          "updated_by": "api:Production Key"
        }
      },
      {
        "id": "row_def456uvw000",
        "company": "Beta",
        "score": 70,
        "status": "new",
        "_meta": {
          "created_at": "2024-01-15T10:35:01Z",
          "created_by": "api:Production Key",
          "updated_at": "2024-01-15T10:35:01Z",
          "updated_by": "api:Production Key"
        }
      }
    ]
  }
  ```

  ```json Error theme={null}
  {
    "error": {
      "message": "Maximum 100 rows per insert"
    }
  }
  ```
</ResponseExample>