Overview

Query and export content from Coda documents using the coda CLI. Supports searching documents, listing pages and tables, exporting page content as Markdown/HTML, and exporting table data as JSON/CSV.

Reference Documentation:

• coda-reference.md — Full command reference with all options
• digital-science-reference.md — Digital Science documentation links

Authentication: Requires CODA_API_KEY environment variable. Get your key at https://coda.io/account

Quick Start

# Verify authentication
coda auth status

# Search for documents
coda docs search "PRD"

# List pages in a document
coda pages list DOC_ID

# Export page as Markdown
coda pages export DOC_ID PAGE_ID --format markdown

# Export table data as JSON
coda export DOC_ID TABLE_ID --format json

Command Reference

Document Commands

| Command | Description | |---------|-------------| | coda docs list | List all accessible documents | | coda docs list --query "PRD" | Search documents by name | | coda docs list --mine | Show only your documents | | coda docs list --limit 10 | Limit results | | coda docs search "roadmap" | Search documents by query | | coda docs show DOC_ID | Show document details |

Page Commands

| Command | Description | |---------|-------------| | coda pages list DOC_ID | List all pages in document | | coda pages show DOC_ID PAGE_ID | Show page details | | coda pages export DOC_ID PAGE_ID | Export page as HTML (default) | | coda pages export DOC_ID PAGE_ID --format markdown | Export page as Markdown | | coda pages export DOC_ID PAGE_ID -o page.md | Save to file |

Table Commands

| Command | Description | |---------|-------------| | coda tables list DOC_ID | List all tables in document | | coda columns list DOC_ID TABLE_ID | Show table schema/columns | | coda rows list DOC_ID TABLE_ID | List all rows in table | | coda rows list DOC_ID TABLE_ID --limit 10 | Limit rows returned | | coda rows list DOC_ID TABLE_ID --query "filter" | Filter rows | | coda rows show DOC_ID TABLE_ID ROW_ID | Show specific row details |

Export Commands

| Command | Description | |---------|-------------| | coda export DOC_ID TABLE_ID | Export table as JSON (console) | | coda export DOC_ID TABLE_ID --format csv | Export as CSV | | coda export DOC_ID TABLE_ID -o data.json | Save to file |

Authentication Commands

| Command | Description | |---------|-------------| | coda auth status | Show current configuration | | coda auth test | Test API connection |

Common Workflows

Find and Read a Document

# 1. Search for the document
coda docs search "product roadmap"

# 2. List pages in the document
coda pages list DOC_ID

# 3. Export page content as Markdown
coda pages export DOC_ID PAGE_ID --format markdown

Extract Table Data

# 1. List tables in document
coda tables list DOC_ID

# 2. View table schema
coda columns list DOC_ID TABLE_ID

# 3. Export table data
coda export DOC_ID TABLE_ID --format json -o data.json

Browse Table Rows

# List first 20 rows
coda rows list DOC_ID TABLE_ID --limit 20

# Filter rows
coda rows list DOC_ID TABLE_ID --query "status:active"

# Show specific row details
coda rows show DOC_ID TABLE_ID ROW_ID

Common Searches

| Task | Command | |------|---------| | Find PRDs | coda docs search "PRD" | | Find roadmaps | coda docs search "roadmap" | | Find competitive analysis | coda docs search "competitive" | | Find research docs | coda docs search "research" | | Find Overleaf/Nova docs | coda docs search "overleaf" or "nova" | | Find Reflect docs | coda docs search "reflect" |

Global Options

| Option | Description | |--------|-------------| | --format conversational | Human-readable output (default) | | --format json | Machine-readable JSON output | | --format csv | CSV output | | --format table | Tabular output | | --ai-snippets | Show AI agent code snippets |

Tips

• Document IDs are in the URL: coda.io/d/Doc-Name_d<DOC_ID>
• Page IDs start with canvas- (found via pages list)
• Table IDs start with grid- or table- (found via tables list)
• Row IDs are shown in rows list output
• Use --format json for machine-readable output
• Export pages as Markdown for easy reading

Installation

If coda command is not found, install from source:

cd ~/aves/coda-cli && uv tool install .

Or run directly without global install:

cd ~/aves/coda-cli && uv run coda <command>

Error Handling

| Error | Solution | |-------|----------| | command not found: coda | Install: cd ~/aves/coda-cli && uv tool install . | | CODA_API_KEY not set | Run export CODA_API_KEY="your-key" | | Invalid API key | Get new key at https://coda.io/account | | Document not found | Verify DOC_ID from URL or search results | | Table not found | Run coda tables list DOC_ID for valid IDs | | Page not found | Run coda pages list DOC_ID for valid IDs |