update_view_records
Updates one or more records through a Caspio view that match the WHERE clause. The payload is a flat JSON object containing only the fields to update (e.g., {'SaleStatus': 'Closed', 'SaleAmount': 1000}). Fields not included in the payload remain unchanged. In multi-table views, only fields from the primary table can be updated (check Editable=true in the view's field definitions). WHERE is required and supports Microsoft SQL Server syntax. A broad WHERE clause will update all matching records. To update a single record, filter by PK_ID or another unique field. Returns all updated records. IMPORTANT: field names 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 updated. Supports Microsoft SQL Server syntax. Examples: 'PK_ID=42'; 'SaleStatus=N'Open' AND ContactID=15' | |
| 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. | |
| payload | Yes | A JSON object of field name/value pairs to update. Only include fields that should change. Example: {'SaleStatus': 'Closed', 'Comments': 'Deal finalized'} |