Changed on

Replaces the schema and/or data of a Big Table

put/tables/{tableID}

Request

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

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

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.

if-matchstring

ETag of the current table version. If provided, the request will fail if the table has been updated since the given version. See Data Versioning.

Request body

OR
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
	}
]

Example request

{
  "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": {
    "rowIDs": [
      "zcJWnyI8Tbam21V34K8MNA",
      "93a19-cf7c-44437-b8c1-e9acbbb"
    ]
  }
}

Changes

  • c9686e65ffb6Revision changes
    • breaking

      removed subschema #1 subschema #2 from the //// request property anyOf list

    • info

      added subschema #1 subschema #2 to the //// request property anyOf list

  • 0d706382896fRevision changes
    • breaking

      removed the required property / from the response with the status

    • info

      added the required property / to the response with the status