View Records

Deletes view records that match a condition.

This operation is irreversible. In multi-table views, only records from the primary table are deleted. 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/views/{viewId}/records/bulk

Request

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

Path parameters

viewIdstring required

The view 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.