Update a cell

PATCH /projects/:projectid/databases/:dbid/tables/:tblid/rows/:rowid

Set one column on one row.

Updates a single value. To change several columns, send several requests, or use Run SQL.

Authentication

• Project API key: The credential for everything external. Created in Project Settings, bound to one project, and limited to the scopes it was granted. Format: proj.<keyId>.<secret>.
• Required permission: databases.write on :dbid.

Path parameters

Name	Type	Required	Default	Description
projectid	string	Yes	-	The project id.
dbid	string	Yes	-	The database id.
tblid	string	Yes	-	The table name.
rowid	string	Yes	-	The row's intellectible_id.

Request body

Content type: application/json

Name	Type	Required	Default	Description
colid	string	Yes	-	The column to set.
newValue	any	Yes	-	The new value. May be null, but the field itself must be present.

Example

{
  "colid": "total",
  "newValue": 51.75
}

Example request

curl -X PATCH \
  -H "Authorization: proj.KEY_ID.SECRET" \
  -H "Content-Type: application/json" \
  -d '{"colid":"total","newValue":51.75}' \
  {{BASE_URL}}/projects/{{PROJECT_ID}}/databases/DATABASE_ID/tables/orders/rows/ROW_ID

Responses

204

Updated. No body.

400

newValue was absent, or colid is not a valid identifier.