Update (Replace) CSVBox Sheet
update_sheetReplace the entire CSVBox sheet with a new full object, deleting any items not included. Use validate_schema first to prevent destructive changes.
Instructions
Replace an existing CSVBox sheet via PUT /1.1/sheet/{sheet_license_key}. Input: { sheet_license_key, sheet }. Returns the API response. DESTRUCTIVE: PUT is authoritative for every collection it sends — items listed are created or updated in place, and any existing item the array does not name is DELETED. This applies to virtual_columns, validation_functions and data_transforms: sending an empty array DELETES ALL of that collection's items, while OMITTING the key leaves them untouched. _delete is not valid here; use patch_sheet to remove a single item. Run validate_schema with mode 'put' first to catch a destructive body.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"sheet_license_key": "<sheet_license_key>",
"sheet": "<sheet>"
},
"name": "update_sheet"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | Yes | The full replacement CSVBox sheet object. | |
| sheet_license_key | Yes | The license key of the sheet to replace. |