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.
| Field | Type | Description |
|---|---|---|
colid | string, required | Existing column name. |
newValue | value, required | New 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.