Delete rows

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

Remove rows by id.

Deletes the listed rows. Needs the delete-rows permission, which is separate from write so a key that only adds data cannot remove it.

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.delete 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.

Request body

Content type: application/json

Name	Type	Required	Default	Description
rowIds	string[]	Yes	-	A non-empty array of intellectible_id values.

Example

{
  "rowIds": [
    "r_91ba"
  ]
}

Example request

curl -X DELETE \
  -H "Authorization: proj.KEY_ID.SECRET" \
  -H "Content-Type: application/json" \
  -d '{"rowIds":["r_91ba"]}' \
  {{BASE_URL}}/projects/{{PROJECT_ID}}/databases/DATABASE_ID/tables/orders/rows

Responses

204

Deleted. No body.

403

The key lacks the delete-rows permission.