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
| Field | Type | Description |
|---|---|---|
rowIds | array, required | Non-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.