Skip to main content

Delete rows

Delete selected rows by their IDs.

DELETE /projects/:projectid/databases/:dbid/tables/:tblid/rows

Authentication​

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

Request​

FieldTypeDescription
rowIdsarray, requiredNon-empty array of row IDs to delete.

Use IDs from Insert rows or an existing row response. This endpoint does not take a SQL filter.

Destructive operation

Check the table and row IDs before running this request. Deleted rows cannot be restored through this API.

Example​

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

curl --include --request DELETE \
--header "Authorization: ${INTELLECTIBLE_PROJECT_API_KEY}" \
--header "Content-Type: application/json" \
--data '{
"rowIds": [
"row_id_1",
"row_id_2"
]
}' \
"${INTELLECTIBLE_PUBLIC_API_URL}/projects/${INTELLECTIBLE_PROJECT_ID}/databases/${INTELLECTIBLE_DATABASE_ID}/tables/${INTELLECTIBLE_TABLE_ID}/rows"

Response​

204 No Content, with no response body.

The response does not include deleted rows or a count. IDs that do not match a row are ignored.

See Errors and safe retries for shared failure handling.