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

# POST /tables/{tableID}/rows

`POST /tables/{tableID}/rows`

## Request

- Base URL: `https://api.glideapps.com`
- URL: `https://api.glideapps.com/tables/{tableID}/rows`
- Auth: HTTP bearer

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`

---

[API](https://skmtc.dev/glideapps/apis/glide-api.md) · [All operations](https://skmtc.dev/glideapps/apis/glide-api/llms.txt) · [OpenAPI document](https://skmtc.dev/glideapps/apis/glide-api/revisions/e3ec449be198?raw)