delete_view_records
Deletes one or more records through a Caspio view that match the WHERE clause. This 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. IMPORTANT: field names in WHERE are case-insensitive and must come from discover_views' field list -- never guess. Call discover_views first for any view not already discovered earlier in this conversation to get its viewId.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| where | Yes | WHERE clause (required). Determines which records are deleted. Supports Microsoft SQL Server syntax. Examples: 'PK_ID=42'; 'SaleStatus=N'Archived' AND DateLogged<'2025-01-01'' | |
| viewId | Yes | View Id (obtained from discover_views, e.g. 'v12345') -- the view's name has no meaning for API calls; only the Id can be used here. |