smartsheet_bulk_update
Apply conditional bulk updates to Smartsheet rows by defining rules for specific conditions and corresponding updates, optimizing large-scale data management tasks.
Instructions
Perform conditional bulk updates on a Smartsheet
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| options | No | Update options | |
| rules | Yes | List of update rules | |
| sheet_id | Yes | Smartsheet sheet ID |
Input Schema (JSON Schema)
{
"properties": {
"options": {
"description": "Update options",
"properties": {
"batchSize": {
"default": 500,
"description": "Number of rows per batch",
"type": "number"
},
"lenientMode": {
"default": false,
"description": "Allow partial success",
"type": "boolean"
}
},
"type": "object"
},
"rules": {
"description": "List of update rules",
"items": {
"properties": {
"conditions": {
"description": "Conditions to evaluate (AND logic)",
"items": {
"properties": {
"columnId": {
"description": "Column ID to check",
"type": "string"
},
"operator": {
"description": "Comparison operator",
"enum": [
"equals",
"contains",
"greaterThan",
"lessThan",
"isEmpty",
"isNotEmpty"
],
"type": "string"
},
"value": {
"description": "Value to compare against (not needed for isEmpty/isNotEmpty)",
"type": [
"string",
"number",
"boolean",
"null"
]
}
},
"required": [
"columnId",
"operator"
],
"type": "object"
},
"type": "array"
},
"updates": {
"description": "Updates to apply when conditions are met",
"items": {
"properties": {
"columnId": {
"description": "Column ID to update",
"type": "string"
},
"value": {
"description": "New value to set",
"type": [
"string",
"number",
"boolean",
"null"
]
}
},
"required": [
"columnId",
"value"
],
"type": "object"
},
"type": "array"
}
},
"required": [
"conditions",
"updates"
],
"type": "object"
},
"type": "array"
},
"sheet_id": {
"description": "Smartsheet sheet ID",
"type": "string"
}
},
"required": [
"sheet_id",
"rules"
],
"type": "object"
}