update_rows
Updates existing records in a master dataset—either by explicit row IDs or by applying a filter to select rows in bulk. Use dry-run first to preview and validate changes before committing them.
Instructions
Update rows by explicit ids, or in bulk for every row matching a filter.
Only the provided columns change; everything else stays as-is. New values are validated together with the rest of each row, so an invalid change leaves that row untouched and is reported with plain-language errors.
Bulk mode (conditions): defaults to a dry-run preview. Review the preview with the user, then re-invoke with dry_run=false to apply. Never set dry_run=false on the first call when a filter may match many rows.
Args: dataset: Exact dataset name, e.g. "Candidates". values: Column values to set, e.g. {"stage": "Rejected"}. row_ids: Explicit row ids to update, e.g. ["3", "7"]. Mutually exclusive with conditions. conditions: Filter selecting rows to update, e.g. [{"column": "stage", "op": "eq", "value": "Screened"}]. dry_run: Bulk mode only - true (default) previews; false applies the update.
Returns: Id mode: {"ok": true, "dataset", "updated", "rejected", "not_found", "results": [...]}. Bulk mode dry-run: {"ok": true, "requires_confirmation": true, "preview": {...}}. Bulk mode applied: {"ok": true, "dataset", "matched", "updated", "rejected", "results": [...]}.
Example: update_rows(dataset="Candidates", values={"stage": "Rejected"}, conditions=[{"column": "score", "op": "lt", "value": 3}], dry_run=true)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| values | Yes | ||
| dataset | Yes | ||
| dry_run | No | ||
| row_ids | No | ||
| conditions | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||