Table Records

Deletes table records that match a condition.

This operation is irreversible. where is required and supports Microsoft SQL Server syntax. A broad WHERE clause will delete all matching records. To delete a single record, filter by PK_ID or another unique field. Returns the count of deleted records.

delete/v4/tables/{tableId}/records/bulk

Request

  • Base URL: https://demo.caspio.com/integrations/rest
  • URL: https://demo.caspio.com/integrations/rest/v4/tables/{tableId}/records/bulk
  • Auth: API key in header Authorization

Path parameters

tableIdstring required

The table identifier (6-character alphanumeric code).

Request body

wherestring required

WHERE clause (required, Microsoft SQL Server syntax). Determines which records are deleted. This is irreversible. A broad clause deletes all matching records. To delete a single record, filter by PK_ID or another unique field. Examples: 'PK_ID=42', 'Status=N'Archived' AND CreatedDate<'2025-01-01''.

Response

OK

recordsAffectedinteger

Changes

No recorded changes to this operation across all 1 revision of this API.