Skip to main content

Update a cell

Update one column value in an existing row.

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

Authentication​

Send the project API key in the Authorization header, without a Bearer prefix. Requires databases.write for the database in the URL.

Request​

Set INTELLECTIBLE_ROW_ID to a row ID from Insert rows or an existing row returned by Read rows.

FieldTypeDescription
colidstring, requiredExisting column name.
newValuevalue, requiredNew value, compatible with the column type. Use null to clear a nullable value.

This request changes one cell, not the whole row. Omitting newValue is an error, even when you intend to clear it.

Example​

Use the environment variables from the database overview. Replace example IDs with your own.

curl --include --request PATCH \
--header "Authorization: ${INTELLECTIBLE_PROJECT_API_KEY}" \
--header "Content-Type: application/json" \
--data '{
"colid": "status",
"newValue": "inactive"
}' \
"${INTELLECTIBLE_PUBLIC_API_URL}/projects/${INTELLECTIBLE_PROJECT_ID}/databases/${INTELLECTIBLE_DATABASE_ID}/tables/${INTELLECTIBLE_TABLE_ID}/rows/${INTELLECTIBLE_ROW_ID}"

Response​

204 No Content, with no response body.

The response does not include the updated row or an affected-row count. An unknown row ID can produce a successful no-op. Read the row back if you need confirmation of the stored value.

See Errors and safe retries for shared failure handling.