update_table_records
Updates one or more records in a Caspio table that match the WHERE clause. The payload is a flat JSON object containing only the fields to update (e.g., {'Status': 'Closed', 'ClosedDate': '2026-01-15'}). Fields not included in the payload remain unchanged. WHERE is required and supports Microsoft SQL Server syntax. Be cautious: 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_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 updated. Examples: 'PK_ID=42'; 'Status=N'Open' AND AssignedTo=N'John'' | |
| payload | Yes | A JSON object of field name/value pairs to update. Only include fields that should change. Example: {'Status': 'Closed', 'Notes': 'Resolved by admin'} | |
| 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. |