files_write_batch
Applies MULTIPLE value-writes AND/OR format-changes to a Tabulya file in ONE call: the file is loaded once and everything ships as a SINGLE atomic collaboration transaction — either all of it applies, or (on any error) none does. Far cheaper than N separate calls, and lets you write data and style it atomically (writes apply first, then formats). Provide 'writes' and/or 'formats' (at least one). Each write: { cell (A1 anchor), values[][] (2D literals), sheet? } (same rules as files_write: literals only; no writes over/adjacent to data tables, except writes within the data rows of a server table: those go to the tables service, each write within one table; copies of a table sorted or filtered differently go in separate calls). Each format: { range (A1), sheet?, and any of bold/italic/underline/strikethrough/text_color/fill_color/align/wrap/number_format/custom_format/decimals/currency_symbol } (same as files_format). A top-level 'sheet' is the default for entries that omit one. Requires edit permission. Signature: files_write_batch(file_uuid, writes?[], formats?[], sheet?).
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": {
"file_uuid": "<file_uuid>"
},
"name": "files_write_batch"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | No | Default sheet for entries that omit one (defaults to the first sheet). | |
| writes | No | Value-writes applied first, in order, as part of the atomic transaction (max 200). | |
| formats | No | Format-changes applied after the writes, in order, in the same transaction (max 200). | |
| file_uuid | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_uuid | Yes | ||
| writes_applied | Yes | ||
| formats_applied | Yes | ||
| sequence_number | Yes |