files_set_text_validation
Adds a text data-validation to a range: cell text must satisfy the given constraints. Provide any of: min_length/max_length (inclusive character-count bounds), exactly (list — the value must equal one of these), contains (list — must contain one of these), not_contains (list — must contain none of these). Matching is case-insensitive. At least one constraint required. strict (default true): reject invalid entries; false warns. Pass 'id' (from files_validations) to replace. Requires edit permission. Signature: files_set_text_validation(file_uuid, range, sheet?, id?, strict?, min_length?, max_length?, exactly?, contains?, not_contains?).
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>",
"range": "<range>"
},
"name": "files_set_text_validation"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| id | No | Existing validation id to replace. | |
| range | Yes | A1 range, e.g. 'A2:A100'. | |
| sheet | No | ||
| strict | No | Reject invalid entries (default true); false warns. | |
| exactly | No | Value must equal one of these. | |
| contains | No | Value must contain one of these. | |
| file_uuid | Yes | ||
| max_length | No | Maximum character count (inclusive). | |
| min_length | No | Minimum character count (inclusive). | |
| not_contains | No | Value must contain none of these. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | ||
| file_uuid | Yes | ||
| sequence_number | Yes |