insert_view_record
Inserts a single record through a Caspio view. The payload is a flat JSON object of field name/value pairs (e.g., {'SaleStatus': 'Open', 'SaleAmount': 500}). Only include editable fields -- in multi-table views, only fields from the primary table are editable (check Editable=true in the view's field definitions). Do not include auto-generated fields (Autonumber, Timestamp, Random ID, GUID, Prefixed Autonumber, Formula, or PK_ID). Returns the full created record including PK_ID. 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 and confirm which fields exist and which are editable.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| 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 for the new record. Keys are field names, values are the data to insert. Example: {'SaleStatus': 'Open', 'SaleAmount': 500, 'ContactID': 12} |