Formula Validate
formula_validateValidate a calculated-field expression against an attached datasource without saving it, returning Google column metadata or diagnostics for syntax, schema, or connector issues.
Instructions
Validate an expression for an attached datasource without saving any field.
Use internal field references, e.g. ABS(t0.revenue), from datasource_get. Returns Google column metadata (dataType, aggregation/type and semantics) or diagnostics. A validation failure may be syntax, schema or connector failure: inspect diagnostics. Uses native uncached revision-0 validation; isolated unpublished-draft and blend contexts are not yet characterized. Success does not prove business correctness or evaluate resulting values.
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": {
"datasource_id": "<datasource_id>",
"expression": "<expression>"
},
"name": "formula_validate"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| report_id | No | ||
| expression | Yes | ||
| datasource_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||