Sign in

v50

latestOpenAPI 3.0.0raw.githubusercontent.com2026-01-13151115.1 KB

Adds rows to a Big Table

post/tables/{tableID}/rows

Path parameters

tableIDstring required

ID of the table, e.g., 2a1bad8b-cf7c-44437-b8c1-e3782df6

Example: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.
Example:updateSchema

Request body

object[] required

A collection of row objects conforming to the schema of the table where keys are the column IDs and values are the column values:

[
	{
		"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
	}
]
OR

Example request

[
  {
    "fullName": "Alex Bard",
    "invoiceDate": "2024-07-29T14:04:15.561Z",
    "totalAmount": 34.5,
    "amountPaid": 0
  },
  {
    "fullName": "Alicia Hines",
    "invoiceDate": "2023-06-15T10:30:00.000Z",
    "totalAmount": 50.75,
    "amountPaid": 20
  }
]

Response

Example response

{
  "data": {
    "rowIDs": [
      "zcJWnyI8Tbam21V34K8MNA",
      "93a19-cf7c-44437-b8c1-e9acbbb"
    ]
  }
}