Creates a new Big Table
post/tables
Query parameters
namestring
Name of the table. Required when the name is not passed in the request body. It is an error to pass a name in both this query parameter and the request body.
Example:Invoices
appsToLinkstring[]
An array of app IDs to link the new table to.
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
Headers
x-glide-asynchronous'true' | 'false'
Allow asynchronous processing, which will return a job ID. Note that this does not force asynchronouys processing. The caller must handle both synchronous and asynchronous responses.
Request body
Example request
{
"name": "Invoices",
"schema": {
"columns": [
{
"id": "fullName",
"displayName": "Full Name",
"type": "string"
},
{
"id": "invoiceDate",
"displayName": "Invoice Date",
"type": "dateTime"
},
{
"id": "totalAmount",
"displayName": "Total",
"type": "number"
},
{
"id": "amountPaid",
"displayName": "Paid",
"type": "number"
}
]
},
"rows": [
{
"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": {
"tableID": "2a1bad8b-cf7c-44437-b8c1-e3782df6",
"rowIDs": [
"zcJWnyI8Tbam21V34K8MNA",
"93a19-cf7c-44437-b8c1-e9acbbb"
]
}
}