PATCH
/
tables
/
{tableID}
/
rows
/
{rowID}
curl --request PATCH \
  --url https://api.glideapps.com/tables/{tableID}/rows/{rowID} \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '{
  "fullName": "Alex Bard",
  "invoiceDate": "2024-07-29T14:04:15.561Z",
  "totalAmount": 34.5,
  "amountPaid": 0
}'
{}

Updates an existing row in a Big Table.

If a column is not included in the passed row data, it will not be updated. If a column is passed that does not exist in the table schema, or with a value that does not match the column’s type, the default behavior is for no update to be made and the API call to return an error. However, you can control this behavior with the onSchemaError query parameter.

Authorizations

​
Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Headers

​
if-match
string

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

Path Parameters

​
tableID
string
required

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

Example:

"2a1bad8b-cf7c-44437-b8c1-e3782df6"

​
rowID
string
required

ID of the row, e.g., zcJWnyI8Tbam21V34K8MNA

Example:

"zcJWnyI8Tbam21V34K8MNA"

Query Parameters

​
onSchemaError
enum<string>

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.
Available options:
abort,
dropColumns,
updateSchema
Example:

"updateSchema"

Body

application/json · object

A row object 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
}

Response

200
application/json

A 200 HTTP response code indicates that the row was successfully updated.