Update Row
Updates a row in a Big Table
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
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Headers
ETag of the current table version. If provided, the request will fail if the table has been updated since this version.
Path Parameters
ID of the table, e.g., 2a1bad8b-cf7c-44437-b8c1-e3782df6
ID of the row, e.g., zcJWnyI8Tbam21V34K8MNA
Query Parameters
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.
abort, dropColumns, updateSchema Body
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
A 200 HTTP response code indicates that the row was successfully updated.
Was this page helpful?