Baserow Representative API Octri Preview
PATCH/api/database/rows/table/{table_id}/batch/

Update rows in a database table in a batch

Updates multiple existing rows in a database table in one request. Include each row's ID and the field values to change in items; field IDs or user-defined field names can identify the fields. Row-updated webhooks are not supported by this operation.

  • IdempotentThe SDK sends Idempotency-Key, so a retried request is only applied once.

7 parameters · 1 body field
table_idintegerrequired
The unique identifier of the table containing the rows to update.
include_metadatabooleanoptional
When enabled, includes operation metadata describing changed field IDs and cascade updates.
send_webhook_eventsbooleanoptional
Whether to trigger webhooks after the operation. Accepts `y`, `yes`, `true`, `t`, `on`, `1`, or an empty value to enable; defaults to `true` when omitted.
user_field_namesbooleanoptional
When enabled with a truthy value such as `y`, `yes`, `true`, `t`, `on`, `1`, or an empty value, uses user-defined field names instead of internal names such as `field_123`.
viewintegeroptional
The ID of the view in which to update the rows; providing it can affect permission checks and default values.
ClientSessionIdstringoptional
An optional UUID identifying the client session, which can be used with undo or redo operations to reverse or repeat this action.
ClientUndoRedoActionGroupIdstringoptional
An optional UUID grouping this action with other actions for undo or redo.

Batch update payload containing 1 to 200 row updates. Each item must include a row id; fields omitted from an item are left unchanged.

itemsarray<object>optional
Array of row updates, with 1 to 200 items. Each item must include an `id` and can include field values to update.

4 status codes
200Returns an `items` array containing the updated row objects, with operation metadata when requested.
itemsarray<object>required
metadataobjectoptional
An optional object containing metadata information about the operation
400Returned when the request body fails validation, row IDs are not unique, or a referenced file cannot be found.
detailstringoptional
Human readable details about what went wrong.
errorstringoptional
Machine readable error indicating what went wrong.
Allowed:ERROR_USER_NOT_IN_GROUPERROR_REQUEST_BODY_VALIDATIONERROR_ROW_IDS_NOT_UNIQUEERROR_REQUEST_BODY_VALIDATIONERROR_RICH_TEXT_IMAGE_LIMIT_EXCEEDEDERROR_USER_FILE_DOES_NOT_EXIST
401Returned when the authenticated user does not have permission to access the table.
detailstringoptional
Human readable details about what went wrong.
errorstringoptional
Machine readable error indicating what went wrong.
Allowed:ERROR_NO_PERMISSION_TO_TABLE
404Returned when the table, row, or specified view does not exist.
detailstringoptional
Human readable details about what went wrong.
errorstringoptional
Machine readable error indicating what went wrong.
Allowed:ERROR_TABLE_DOES_NOT_EXISTERROR_ROW_DOES_NOT_EXISTERROR_VIEW_DOES_NOT_EXIST

Error handling

A 400 is returned when the request body fails validation, row IDs are not unique, or a referenced file cannot be found. A 401 is returned when the authenticated user does not have permission to access the table. A 404 is returned when the table, row, or specified view does not exist. The table_id path parameter must identify the table to update.