Patch CSVBox Sheet
patch_sheetPartially update a CSVBox importer sheet by sending only the changes to merge, adding or patching columns, functions, and transforms; mark an item with _delete: true to remove it.
Instructions
Partially update a CSVBox sheet via PATCH /1.1/sheet/{sheet_license_key}. Sends only the changes object. Input: { sheet_license_key, changes }. Returns the API response. PATCH MERGES: only the items you list are touched and nothing is deleted implicitly, so an empty array is a no-op. Items in virtual_columns, validation_functions and data_transforms are matched by column_name / function_name / transform_name respectively — an unmatched name creates a new item. To remove one, send it with _delete: true; every other field on a _delete item is ignored, including js_code. This is the safe verb for applying generated functions. Run validate_schema with mode 'patch' first.
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>",
"changes": "<changes>"
},
"name": "patch_sheet"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| changes | Yes | Only the partial changes to apply to the sheet. | |
| sheet_license_key | Yes | The license key of the sheet to patch. |