Skip to main content
POST
/
v1
/
table
/
{name}
/
update
Update Data
curl --request POST \
  --url https://{db}.{region}.api.lancedb.com/v1/table/{name}/update \
  --header 'Content-Type: application/json' \
  --header 'x-api-key: <api-key>' \
  --data '
{
  "updates": [
    [
      "price",
      "price + 0.10"
    ]
  ],
  "predicate": "id in (1, 2, 3)"
}
'
{}

Authorizations

​
x-api-key
string
header
required

Path Parameters

​
name
string
required

name of the table

Body

application/json
​
updates
string[][]
required

A list to column updates. Each item is a pair of strings. The first string is the column name to update, and the second string is a SQL expression to update the column.

Required array length: 2 elements
Example:
["price", "price + 0.10"]
​
predicate
string

A filter expression that specifies the rows to update.

Example:

"id in (1, 2, 3)"

Response

Update successful