kjgarza 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 viapages list) - Table IDs start with
grid-ortable-(found viatables list) - Row IDs are shown in
rows listoutput - Use
--format jsonfor 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 |