Coda API Skill

Interact with the Coda REST API v1 to manage docs, tables, rows, pages, and automations.

When to Use

Use this skill when the user wants to:

• - List, search, create, or delete Coda docs
• Read from or write to tables (insert, upsert, update, delete rows)
• Explore doc structure (pages, tables, columns, formulas, controls)
• Trigger automations (push buttons)
• Export doc content or analytics

When NOT to Use

• - Do NOT use for general document editing advice unrelated to the API
• Do NOT use for Pack development (this skill covers Doc management, not Pack creation)
• Do NOT use for operations requiring Doc Maker permissions unless confirmed the user has them

Prerequisites

1. 1. API Token: Set environment variable CODA_API_TOKEN with your Coda API token

- Get token at: https://coda.io/account -> API Settings

1. 2. Python 3.7+ with requests library installed
2. Permissions: Some operations (create doc, update doc title, create page) require Doc Maker role in the workspace

CLI Tool Usage

The skill includes a Python CLI tool at scripts/coda_cli.py:

CODEBLOCK0

Workflow Guidelines

1. Doc ID Extraction

Coda doc IDs can be extracted from browser URLs:

• - URL: INLINECODE3
• Doc ID: AbCDeFGH (remove _d prefix)

The CLI tool accepts both full URLs and raw IDs.

2. Rate Limit Handling

The API has strict rate limits:

• - Read: 100 requests per 6 seconds
• Write (POST/PUT/PATCH): 10 requests per 6 seconds
• Write doc content: 5 requests per 10 seconds
• List docs: 4 requests per 6 seconds

The CLI tool automatically implements exponential backoff for 429 responses.

3. Asynchronous Operations

Write operations return HTTP 202 with a requestId. The CLI tool optionally polls for completion using --wait flag.

4. Safety Guardrails

Delete Operations (rows, docs, pages, folders):

• - Always requires explicit user confirmation in interactive mode
• Use --force flag only in automation/scripts
• Shows preview of what will be deleted

Publishing (docs publish):

• - Requires explicit --confirm-publish flag
• Cannot be combined with INLINECODE11

Permissions (acl commands):

• - Requires explicit --confirm-permissions flag for any changes
• Read operations (list permissions) are always allowed

Automation Triggers:

• - Allowed without special flags but logged
• User should be aware that automations may trigger notifications or external actions

5. Pagination

List commands support:

• - --limit: Maximum results (default 25, max varies by endpoint)
• INLINECODE15: For fetching subsequent pages
• CLI auto-follows pages with --all flag

Common Patterns

Batch Row Operations

CODEBLOCK1

Sync Between Docs

CODEBLOCK2

Explore Structure

CODEBLOCK3

Error Handling

Common HTTP status codes:

• - 400: Bad request (invalid parameters)
• INLINECODE18: Invalid/expired API token
• INLINECODE19: Insufficient permissions (need Doc Maker role)
• INLINECODE20: Resource not found
• INLINECODE21: Rate limited (implement backoff)
• INLINECODE22: Accepted but not yet processed (async operation)

Security Considerations

1. 1. Token Storage: Never commit CODA_API_TOKEN to version control
2. Token Scope: The token has full access to all docs the user can access
3. Workspace Restrictions: Creating docs requires Doc Maker role in target workspace
4. Data Exposure: Row data may contain sensitive information; handle exports carefully

Examples

List and Filter Docs

CODEBLOCK4

Create Doc from Template

CODEBLOCK5

Update Row Status

CODEBLOCK6

Delete Multiple Rows (with confirmation)

CODEBLOCK7

Export Table to CSV

CODEBLOCK8

Reference

• - API Documentation: https://coda.io/developers/apis/v1
• OpenAPI Spec: https://coda.io/apis/v1/openapi.yaml
• Rate Limits: https://coda.io/developers/apis/v1#section/Rate-Limiting