v13

latestOpenAPI 3.1.0Apache 2.0raw.githubusercontent.com2026-08-015232292.9 KB

Tables

Upsert Row

Insert a new row or update an existing one based on a unique column value. The table must have at least one column with a unique constraint. If a row with a matching unique value exists, it is updated; otherwise, a new row is inserted. When multiple unique columns exist, specify conflictTarget to indicate which column to match on.

post/api/v1/tables/{tableId}/rows/upsert

Path parameters

tableIdstring required

Example:tbl_92e4c6a8b0d24f1e8a3c5d7b9f0e2a14

The unique identifier of the table.

Request body

workspaceIdstring required

The workspace ID.

dataobject required

Row data. Must include a value for the conflict target column.

conflictTargetstring

Name of the unique column to match on. Required when the table has multiple unique columns. If the table has exactly one unique column, this can be omitted.

Response

Row upserted successfully.

successboolean

Indicates whether the request was successful.

Example response

{
  "data": {
    "row": {
      "id": "row_6b8d0f2a4c3e4e5da28f7c9b1d3f5a07"
    }
  }
}