Coda has a public API available to all users. The API allows you to get data in and out of tables in Coda as well as access computed values from formulas and user-selected values from controls.
What Can I do with Coda API?
The Coda REST API allows users to programmatically interact with Coda docs in a number of ways including:
List and search Coda docs
Creating and copying docs
Listing tables within a doc
Inserting and updating rows
Listing pages in a doc
Updating page title/image/icon
Publishing a doc
Check out our full API documentation here.
To see examples of the Coda API in action, take a look at this Coda doc.
Enterprise customers wanting to learn about our Admin Audit API, check out this article.
API size limits on requests
The limit for requests is 2 MB, but there is also a limit of 85 KB for any given row. Community Post
Script for Sheets to Coda and for Coda to Sheets
Al created an app script for moving data from Google Sheets to Coda and from Coda to Google Sheets. You can find more info here: Community Post | GitHub Repo
Are API limits per workspace, user, or token?
Limits are attached to a user/IP
Why do I get a 401 error when trying to connect Coda to Zapier?
Go to coda.io/account and check that there aren’t any restrictions on the API token for Zapier. Zapier can’t connect to Coda with anything less than a full access API token.
How do I use the Zapier upsert action? Why can’t I upsert using the row’s ID?
The Zapier Coda integration’s upsert action is a bit confusing to set up. You have to specify the column you want to look for a match on as well as specify the value of that and any other columns you want to update.
The API is returning a date and time stamp different than I’d expect. Why is that?
The API returns dates in Pacific time. The user can write code to offset from there.
How do I send an image to the API?
Right now our API doesn’t accept image files. Instead, the closest we can come is passing an Image URL to an Image URL column.
For cross-doc, does the API limit of 125Mb count the source doc or the destination doc?
Only the source doc.