TRtrydock
Sheets formulas

Parse-check a formula expression

Returns { ok, error?, referencedFunctions, unknownFunctions }. Catches syntax errors and likely typos before you persist a stale carrier into a row. Public endpoint, no auth, no workspace context required.

post/api/sheets/validate-formula

Request

  • Base URL
    https://trydock.ai
  • Auth
    HTTP bearer

Request body

formulastring required

Example request

{
  "formula": "=SUMIF(B2:B10, \">0\")"
}

Response

Validation result.

okboolean required
errorstring

Plain-language reason the formula didn't parse, when ok=false.

referencedFunctionsstring[] required

Canonical function names referenced in the formula. Aliases are resolved to their canonical form.

unknownFunctionsstring[] required

Any identifier that looked like a function call but isn't in the Dock catalog. Likely typos or unsupported functions.

Changes

No recorded changes to this operation across all 2 revisions of this API.