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