Coda
Create rows, list tables, and manage data in Coda docs.
On this page
Connect
Auth type: API key (secret_text). Paste the API key (or token) from the provider's settings into the connect dialog. It is encrypted at rest and only decrypted on the server when an action runs.
- In the editor: Backend panel, Integrations tab, then Connect. This connects it for the project.
- For every project in a workspace: Workspace settings, Integrations.
- Owners and admins choose which integrations members may connect in the admin panel (Integrations tab), and can attach their own OAuth app there.
Call it from a workflow
Pass the action name and its input. The call resolves with { success, output, error? }; a missing connection resolves with success false and the reason. See ctx.integrations.invoke and ctx.integrations.call.
// .workflow.js (native ctx)
export async function run(ctx) {
const res = await ctx.integrations.invoke("coda", "create-row", {
"docId": "<docId>",
"tableId": "<tableId>",
"rowData": {}
});
if (!res.success) throw new Error(res.error);
ctx.log.info("Coda answered", { output: res.output });
}// defineWorkflow module (@app/sdk ctx)
import { defineWorkflow } from "@app/sdk";
export default defineWorkflow({
id: "coda-create-row",
name: "Coda: Create Row",
description: "Calls Coda when a row is created.",
trigger: { type: "entity_event", entity: "tickets", event: "created" },
async run(ctx, event) {
const res = await ctx.integrations.call("coda", {
"action": "create-row",
"docId": "<docId>",
"tableId": "<tableId>",
"rowData": {}
}) as { success: boolean; error?: string };
if (!res.success) throw new Error(res.error);
},
});curl -X POST "$APP_ORIGIN/__appbricx/connector-proxy/coda/create-row" \
-H "Authorization: Bearer $APP_KEY" \
-H "content-type: application/json" \
-d '{"props":{"docId":"<docId>","tableId":"<tableId>","rowData":{}}}'Actions
create-rowin catalog
Create Row. Creates a new row in the selected table.
Also accepted as create_row.
| Input | Type | Description |
|---|---|---|
docIdrequired | id (picked from your account) | Document |
tableIdrequired | id (picked from your account) | Table |
rowDatarequired | object (depends on other props) | Define the data for the new row based on table columns. |
find-rowin catalog
Find Row(s). Find specific rows in the selected table using a column match search.
| Input | Type | Description |
|---|---|---|
docIdrequired | id (picked from your account) | Document |
tableIdrequired | id (picked from your account) | Table |
searchColumnrequired | id (picked from your account) | Search Column |
searchValuerequired | text | Search Value |
list-tablesin catalog
List Table(s). List tables in a selected document.
| Input | Type | Description |
|---|---|---|
docIdrequired | id (picked from your account) | Document |
maxrequired | number | Maximum number of results to return. |
update-rowin catalog
Update Row. Updates an existing row in the selected table.
Also accepted as update_row.
| Input | Type | Description |
|---|---|---|
docIdrequired | id (picked from your account) | Document |
tableIdrequired | id (picked from your account) | Table |
rowIdOrNamerequired | text | Row ID or Name |
rowDatarequired | object (depends on other props) | Define the data for the new row based on table columns. |
custom_api_call
Custom API Call. Make a custom API call to a specific endpoint
| Input | Type | Description |
|---|---|---|
urlrequired | object (depends on other props) | url |
methodrequired | one of "GET" | "POST" | "PATCH" | "PUT" | "DELETE" | "HEAD" | Method |
headersrequired | object | Authorization headers are injected automatically from your connection. |
queryParamsrequired | object | Query Parameters |
body_typeoptional | one of "none" | "json" | "form_data" | "raw" | Body Type |
bodyoptional | object (depends on other props) | Body |
response_is_binaryoptional | boolean | Enable for files like PDFs, images, etc. |
failsafeoptional | boolean | No Error on Failure |
timeoutoptional | number | Timeout (in seconds) |
followRedirectsoptional | boolean | Follow redirects |
get-row
Get Row. Retrieves a single row by specified ID.
| Input | Type | Description |
|---|---|---|
docIdrequired | id (picked from your account) | Document |
tableIdrequired | id (picked from your account) | Table |
rowIdOrNamerequired | text | Row ID or Name |
get-table
Get Table. Get structure and details of a specific table (e.g., columns, schema).
| Input | Type | Description |
|---|---|---|
docIdrequired | id (picked from your account) | Document |
tableIdrequired | id (picked from your account) | Table |
upsert-row
Upsert Row. Creates a new row or updates an existing one if it matches key columns.
| Input | Type | Description |
|---|---|---|
docIdrequired | id (picked from your account) | Document |
tableIdrequired | id (picked from your account) | Table |
keyColumnsrequired | ids (picked from your account) | Matching Columns |
rowDatarequired | object (depends on other props) | Define the data for the new row based on table columns. |
Details
- Id
coda- Category
- Productivity
- Tags
- docs, tables, database, collaborative
- Package
@activepieces/piece-coda@0.1.4- Tier
- Community