Sheets formulas

List the formula function catalog

Returns the 39-function Dock Sheets catalog (12 V1 + 14 V2 + 7 V3 + 6 V4), the alias map (e.g. CONCAT → CONCATENATE), and the category list. Public endpoint, no auth required. Use this before writing a formula carrier so you only reference functions that actually exist.

get/api/sheets/functions

Request

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

Query parameters

category'Math' | 'Logic' | 'Text' | 'Date' | 'Lookup' | 'Predicates' | 'Other'

Filter to one category.

slice'v1' | 'v2' | 'v3' | 'v4'

Filter to one rollout slice.

namestring

Case-insensitive substring match against name, description, and signature.

Response

Filtered catalog.

countinteger required
aliasesobject required
categoriesstring[] required

Example response

{
  "functions": [
    {
      "name": "SUM",
      "signature": "(range)",
      "description": "Add up the numbers in a range.",
      "category": "Math",
      "slice": "v1",
      "examples": [
        {
          "formula": "=SUM(B2:B10)",
          "result": "318.42"
        }
      ]
    }
  ]
}

Changes

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