PATCH
/
tables
/
{tableID}
/
rows
/
{rowID}

Updates an existing row in a Big Table.

Authorizations

Authorization
string
headerrequired

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 the table has been updated since this version.

Path Parameters

tableID
string
required

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

rowID
string
required

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

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

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
}
{key}
any

Response

200 - application/json

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