Sign in
Table
Data

Update rows in a table

Update existing rows in table id.

post/v1/table/{id}/update

Path parameters

idstring required

string identifier of an object in a namespace, following the Lance Namespace spec. When the value is equal to the delimiter, it represents the root namespace. For example, v1/namespace/$/list performs a ListNamespace on the root namespace.

Query parameters

delimiterstring

An optional delimiter of the string identifier, following the Lance Namespace spec. When not specified, the $ delimiter must be used.

Request body

idstring[]
predicatestring nullable

Optional SQL predicate to filter rows for update

Example request

{
  "predicate": "predicate",
  "id": [
    "id",
    "id"
  ],
  "updates": [
    [
      "updates",
      "updates"
    ],
    [
      "updates",
      "updates"
    ]
  ]
}

Response

Update successful

transaction_idstring

Optional transaction identifier

updated_rowsinteger required

Number of rows updated

versioninteger required

The commit version associated with the operation

Example response

{
  "transaction_id": "transaction_id",
  "updated_rows": 0,
  "version": 0
}

Changes