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:
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 |