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.

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.

Was this page helpful?

Overwrite TableDelete Row