Productivity

Coda

33min
the coda api is in beta as coda updates and releases newer versions of the api, they reserve the right to remove older apis and functionality with a 4 week deprecation notice getting started with coda the coda modules allow you to monitor docs and tables, create docs and rows, and search or retrieve details about doc structures, tables, docs, formulas, and controls in your coda account prerequisites a coda account in order to use coda with make, it is necessary to have a coda account if you do not have one, you can create a coda account at coda io/signin https //coda io/signin connecting coda to make to connect your coda account to make you need to generate an api token and provide it to make sign in to your coda account and open account settings navigate to the api settings section and click on the generate api token button give your api token a name and generate the token by clicking the generate api token button copy the generated api token go to make and open the create a connection dialog paste the generated api token to the api token field and click on the continue button the connection has been established docs watch new docs the module is triggered when a new doc is created connection coda docid\ asv6zmswawku58finzvtf created by me retrieves only docs created by the account owner limit the maximum number of docs make will return during one cycle create a doc creates a new coda doc an existing doc can be used as a source doc for a new doc connection coda docid\ asv6zmswawku58finzvtf title enter the title for a new doc if left empty, the doc name will be set to "untitled" source doc id if you want to create a copy of an existing doc, map the id of the source doc or select the source doc from the drop down menu list docs connection coda docid\ asv6zmswawku58finzvtf limit the maximum number of docs make will return during one cycle query enter the term you want to filter the results by created by me retrieves only docs created by the account owner (you) source document id select the doc or map the doc id to show only docs copied by the specified document get a doc returns metadata for a specified doc connection coda docid\ asv6zmswawku58finzvtf doc id select or map the id of the doc you want to retrieve information about doc structure list sections returns a list of sections in a coda doc connection coda docid\ asv6zmswawku58finzvtf doc id select or map the id of the doc you want to retrieve information about limit the maximum number of sections make will return during one cycle get a section connection coda docid\ asv6zmswawku58finzvtf doc id select or map the id of the doc you want to retrieve section details from section id or name enter the id or name of the section names are discouraged because they're easily prone to being changed by users list folders returns a list of folders in a coda doc connection coda docid\ asv6zmswawku58finzvtf doc id select or map the id of the doc you want to list folders from limit the maximum number of folders make will return during one cycle get a folder returns details about a folder connection coda docid\ asv6zmswawku58finzvtf doc id select or map the id of the doc you want to retrieve folder details from folder id or name enter the id or name of the folder names are discouraged because they're easily prone to being changed by users tables watch new rows the module is triggered when a new row is created in a selected table connection coda docid\ asv6zmswawku58finzvtf doc select the doc that contains the table you want to watch for new rows table select the table you want to watch for new rows create a row inserts a row into a selected table connection coda docid\ asv6zmswawku58finzvtf doc select the doc that contains the table you want to add a row to table select the table where you want to add a row columns enter the desired values for the table columns update a row updates a specified row in a table connection coda docid\ asv6zmswawku58finzvtf doc select the doc that contains the table you want to update table select the table where you want to add a row row id or name select or map the row you want to update columns enter values for the table columns you want to update upsert a row creates or updates a row the new row is created (inserted) if the key column doesn't contain the specified value the row is updated if the key column does contain the specified value connection coda docid\ asv6zmswawku58finzvtf doc select the doc that contains the table you want to update table select the table where you want to add a row key columns select the key column the row is created or updated depending on the key column selection example if the selected key column contains the value 123 and you specify the value 123 as the column value (see columns section below), then all rows containing the value 123 in the specified key column are updated or if the selected key column does not contain the value 123 and you specify the value 123 as the column value (see columns section below), then a new row is created columns enter the desired values for the new or updated row delete a row deletes a selected row connection coda docid\ asv6zmswawku58finzvtf doc id select the doc that contains the table with the row you want to delete table id or name select or map the table that contains the row you want to delete row id or name select or map the row you want to delete list rows returns a list of rows in a selected table connection coda docid\ asv6zmswawku58finzvtf doc id select the doc that contains the table you want to list table id or name select or map the table that contains the rows you want to list limit the maximum number of rows make will return during one cycle query example "c tuvwxyz \\"apple\\"" query used to filter returned rows, specified as \<column id or name> \<value> if you'd like to use a column name instead of an id, you must quote it (e g , " my column" 123 ) also, note that value is a json value; if you'd like to use a string, you must surround it in quotes (e g , "groceries" ) use column names select the yes option if you want to use column names instead of column ids in the returned output get a row returns details about a row in a table connection coda docid\ asv6zmswawku58finzvtf doc id map or select the doc that contains the table with the row you want to retrieve table id or name select or map the table that contains the row you want to get details about row id or name select or map the row you want to retrieve details about use column names select the yes option if you want to use column names instead of column ids in the returned output list tables returns a list of tables in a coda doc connection coda docid\ asv6zmswawku58finzvtf doc id map or select the doc you want to list tables from limit the maximum number of tables make will return during one cycle get a table returns details about a specific table connection coda docid\ asv6zmswawku58finzvtf doc id map or select the doc you want to retrieve table details from table id or name select or map the table you want to retrieve information about list columns returns a list of columns in a table connection coda docid\ asv6zmswawku58finzvtf doc id map or select the doc you want to list the table columns from limit the maximum number of columns make will return during one cycle get a column returns details about a column in a table connection coda docid\ asv6zmswawku58finzvtf doc id map or select the doc you want to retrieve the table column details from table id or name map or select the table you want to retrieve the table column details from column id or name map or select the column you want to retrieve formulas & controls list formulas returns a list of named formulas in a coda doc connection coda docid\ asv6zmswawku58finzvtf doc id map or select the doc you want to retrieve named formulas from limit the maximum number of named formulas make will return during one cycle get a formula connection coda docid\ asv6zmswawku58finzvtf doc id map or select the doc you want to retrieve formula details from formula id or name map or select the formula you want to retrieve information about list controls controls provide a user friendly way to input a value that can affect other parts of the doc make lets you list controls and get their current values the module retrieves controls from the document, not controls from the table connection coda docid\ asv6zmswawku58finzvtf doc id map or select the doc you want to retrieve the list of controls from limit the maximum number of controls make will return during one cycle get a control returns info on a control the module retrieves controls from the document, not controls from the table connection coda docid\ asv6zmswawku58finzvtf doc id map or select the doc you want to retrieve the control details from control id or name map or select the control you want to retrieve information about other make an api call allows you to perform a custom api call connection coda docid\ asv6zmswawku58finzvtf url enter a path relative to https //coda io/apis for example /v1/docs for the list of available endpoints, refer to the coda api documentation method select the http method you want to use get to retrieve information for an entry post to create a new entry put to update/replace an existing entry patch to make a partial entry update delete to delete an entry headers enter the desired request headers you don't have to add authorization headers; we already did that for you query string enter the request query string body enter the body content for your api call example of use list available docs the following api call returns all available docs in your coda account url /v1/docs method get the result can be found in the module's output under bundle > body > items in our example, 5 docs were returned