---
title: "POST /tables/{tableID}/rows"
method: POST
path: "/tables/{tableID}/rows"
---

# POST /tables/{tableID}/rows

`POST /tables/{tableID}/rows`

Adds rows to a Big Table

## Path parameters

- `tableID` string, required — ID of the table, e.g., `2a1bad8b-cf7c-44437-b8c1-e3782df6`

## Query parameters

- `onSchemaError` 'abort' | 'dropColumns' | 'updateSchema' — The action to take when the passed data does not match the table schema: - `abort`: Abort the entire operation and return an error. - `dropColumns`: Ignore the data that caused the error, and do not import those columns in the affected rows. - `updateSchema`: Update the schema as needed to add any missing columns or widen the data types of existing columns, and then import the data from them.

## Request body

- union
  - object[] — A collection of row objects conforming to the schema of the table where keys are the column IDs and values are the column values: ```json [ { "fullName": "Alex Bard", "invoiceDate": "2024-07-29T14:04:15.561Z", "totalAmount": 34.50, "amountPaid": 0 }, { "fullName": "Alicia Hines", "invoiceDate": "2023-06-15T10:30:00.000Z", "totalAmount": 50.75, "amountPaid": 20 } ] ```
  - object — A single reference to a [stash](/api-reference/v2/stashing) whose data should be used.
    - `$stashID` string, required — ID of the stash, e.g., `20240215-job32`

## Response `201`

- object
  - `data` object, required
    - `rowIDs` string[], required — Row IDs of added rows, returned in the same order as the input rows, e.g., ```json [ "zcJWnyI8Tbam21V34K8MNA", "93a19-cf7c-44437-b8c1-e9acbbb" ] ```

## Other responses

- `400`
- `402`
- `404`
- `422`

## Changes

- **2025-04-17** `22782d914dc3` — 1 info
  - added the non-success response with the status `402`
- **2025-04-01** `afa4b5b8dc78` — 1 info
  - removed the non-success response with the status `402`
- **2025-03-24** `85facd138eb5` — 1 info
  - added the non-success response with the status `402`
- **2024-09-16** `f30d34e8929d` — 2 info
  - added the media type `text/csv` to the request body
  - added the media type `text/tab-separated-values` to the request body
- **2024-08-27** `72ef09c96e18` — 1 breaking
  - added the pattern `^[a-zA-Z0-9][a-zA-Z0-9_-]{0,255}$` to the request property `anyOf[subschema #2]/$stashID`

[Full history](https://skmtc.dev/glideapps/apis/untitled-api/changes/tables/:tableID/rows/post.md)

---

[API](https://skmtc.dev/glideapps/apis/untitled-api.md) · [All operations](https://skmtc.dev/glideapps/apis/untitled-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/glideapps/untitled-api/revisions/ecab03a9d56a/schema)