← Coda

Find Row with Coda API

Pipedream makes it easy to connect APIs for Coda and 900+ other apps remarkably fast.

Trigger workflow on
HTTP requests, schedules and app events
Next, do this
Find Row with the Coda API
No credit card required
Into to Pipedream
Watch us build a workflow
Watch us build a workflow
7 min
Watch now ➜
Trusted by 250,000+ developers from startups to Fortune 500 companies:
Trusted by 250,000+ developers from startups to Fortune 500 companies

Developers Pipedream

Getting Started

Create a workflow to Find Row with the Coda API. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

  1. Configure the Find Row action
    1. Connect your Coda account
    2. Select a Doc ID
    3. Select a Table ID
    4. Optional- Select a Column ID
    5. Optional- Configure Search Query
    6. Optional- Select a Sort By
    7. Optional- Configure Visible Only
    8. Optional- Configure Use Column Names
    9. Optional- Select a Value Format
    10. Optional- Configure Max Items
  2. Select a trigger to run your workflow on HTTP requests, schedules or app events
  3. Deploy the workflow
  4. Send a test event to validate your setup
  5. Turn on the trigger

Integrations

Find Row with Coda API on New Requests (Payload Only) from HTTP / Webhook API
HTTP / Webhook + Coda
 
Try it
Find Row with Coda API on New Item in Feed from RSS API
RSS + Coda
 
Try it
Find Row with Coda API on New Message from Discord API
Discord + Coda
 
Try it
Find Row with Coda API on New Message In Channels from Slack API
Slack + Coda
 
Try it
Find Row with Coda API on New Message in Channel from Discord Bot API
Discord Bot + Coda
 
Try it

Details

This is a pre-built, open source component from Pipedream's GitHub repo. The component is developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Find Row on Coda
Description:Searches for a row in the selected table using a column match search. [See docs](https://coda.io/developers/apis/v1#operation/listRows)
Version:0.0.1
Key:coda-find-row

Code

import coda from "../../coda.app.mjs";

export default {
  key: "coda-find-row",
  name: "Find Row",
  description: "Searches for a row in the selected table using a column match search. [See docs](https://coda.io/developers/apis/v1#operation/listRows)",
  version: "0.0.1",
  type: "action",
  props: {
    coda,
    docId: {
      propDefinition: [
        coda,
        "docId",
      ],
    },
    tableId: {
      propDefinition: [
        coda,
        "tableId",
        (c) => ({
          docId: c.docId,
        }),
      ],
    },
    columnId: {
      propDefinition: [
        coda,
        "columnId",
        (c) => ({
          docId: c.docId,
          tableId: c.tableId,
        }),
      ],
      description: "ID of the column. This field is required if querying",
      optional: true,
    },
    query: {
      propDefinition: [
        coda,
        "query",
      ],
      description: "Query used to filter returned rows",
      optional: true,
    },
    sortBy: {
      propDefinition: [
        coda,
        "sortBy",
      ],
      description: "Specifies the sort order of the rows returned. If left unspecified, rows are returned by creation time ascending",
      options: [
        "createdAt",
        "natural",
        "updatedAt",
      ],
    },
    visibleOnly: {
      propDefinition: [
        coda,
        "visibleOnly",
      ],
    },
    useColumnNames: {
      type: "boolean",
      label: "Use Column Names",
      description: "Use column names instead of column IDs in the returned output",
      optional: true,
    },
    valueFormat: {
      type: "string",
      label: "Value Format",
      description: "The format that individual cell values are returned as",
      optional: true,
      options: [
        "simple",
        "simpleWithArrays",
        "rich",
      ],
    },
    max: {
      propDefinition: [
        coda,
        "max",
      ],
    },
  },
  async run({ $ }) {
    let params = {
      sortBy: this.sortBy,
      visibleOnly: this.visibleOnly,
      useColumnNames: this.useColumnNames,
      valueFormat: this.valueFormat,
    };

    if (this.columnId && this.query) {
      params.query = `${this.columnId}:"${this.query}"`;
    }

    let items = [];
    let response;
    do {
      response = await this.coda.findRow(
        $,
        this.docId,
        this.tableId,
        params,
      );
      items.push(...response.items);
      params.pageToken = response.nextPageToken;
    } while (params.pageToken && items.length < this.max);

    if (items.length > this.max) items.length = this.max;

    if (items.length > 0) {
      $.export("$summary", `Found ${items.length} rows`);
    } else {
      $.export("$summary", `No rows found with the search query: ${this.query}`);
    }
    return {
      items,
    };
  },
};

Configuration

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.
LabelPropTypeDescription
CodacodaappThis component uses the Coda app.
Doc IDdocIdstringSelect a value from the drop down menu.
Table IDtableIdstringSelect a value from the drop down menu.
Column IDcolumnIdstringSelect a value from the drop down menu.
Search Queryquerystring

Query used to filter returned rows

Sort BysortBystringSelect a value from the drop down menu:createdAtnaturalupdatedAt
Visible OnlyvisibleOnlyboolean

If true, returns only visible rows and columns for the table

Use Column NamesuseColumnNamesboolean

Use column names instead of column IDs in the returned output

Value FormatvalueFormatstringSelect a value from the drop down menu:simplesimpleWithArraysrich
Max Itemsmaxinteger

Maximum number of results to return in this query

Authentication

Coda uses API keys for authentication. When you connect your Coda account, Pipedream securely stores the keys so you can easily authenticate to Coda APIs in both code and no-code steps.

Get your Coda API token in My account on Coda.

About Coda

A doc as powerful as an app.

More Ways to Use Coda

Actions

Copy Doc with the Coda API

Creates a copy of the specified doc. See docs

 
Try it
Create Doc with the Coda API

Creates a new doc. See docs

 
Try it
Create Rows with the Coda API

Insert a row in a selected table. See docs

 
Try it
List Columns with the Coda API

Lists columns in a table. See docs

 
Try it
List Docs with the Coda API

Returns a list of docs accessible by the user. These are returned in the same order as on the docs page: reverse chronological by the latest event relevant to the user (last viewed, edited, or shared). See docs

 
Try it