---
title: "List the formula function catalog"
method: GET
path: "/api/sheets/functions"
tags: ["Sheets formulas"]
---

# List the formula function catalog

`GET /api/sheets/functions`

## Request

- Base URL: `https://trydock.ai`
- URL: `https://trydock.ai/api/sheets/functions`
- Auth: HTTP bearer

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.

## Query parameters

- `category` 'Math' | 'Logic' | 'Text' | 'Date' | 'Lookup' | 'Predicates' | 'Other': Filter to one category.
- `slice` 'v1' | 'v2' | 'v3' | 'v4': Filter to one rollout slice.
- `name` string: Case-insensitive substring match against name, description, and signature.

## Response `200`

Filtered catalog.

- object
  - `count` integer, required
  - `functions` object[], required
    - `name` string, required
    - `signature` string, required
    - `description` string, required
    - `category` 'Math' | 'Logic' | 'Text' | 'Date' | 'Lookup' | 'Predicates' | 'Other', required
    - `slice` 'v1' | 'v2' | 'v3' | 'v4', required
    - `examples` object[], required
      - `formula` string, required
      - `result` string, required
  - `aliases` object, required
  - `categories` string[], required

---

[API](https://skmtc.dev/trydock/apis/dock-rest-api.md) - [All operations](https://skmtc.dev/trydock/apis/dock-rest-api/llms.txt) - [OpenAPI document](https://skmtc.dev/trydock/apis/dock-rest-api/revisions/dd96ae96a412?raw)