Create Rows with Coda API on New Channel Message from Zoho Cliq API

Pipedream makes it easy to connect APIs for Coda, Zoho Cliq and 2,200+ other apps remarkably fast.

Trigger workflow on

New Channel Message from the Zoho Cliq API

Next, do this

Create Rows with the Coda API

No credit card required

▶

Watch us build a workflow

8 min

Watch now ➜

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Getting Started#

This integration creates a workflow with a Zoho Cliq trigger and Coda action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Channel Message trigger
1. Connect your Zoho Cliq account
2. Configure timer
3. Select a Channel ID
Configure the Create Rows action
1. Connect your Coda account
2. Select a Doc ID
3. Select a Table ID
4. Optional- Configure Disable Parsing
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Details#

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are 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.

Trigger#

New Channel Message on Zoho Cliq

Description:Emit new event when a new channel message is received. [See the documentation](https://www.zoho.com/cliq/help/restapi/v2/#Get_Messages)

Version:0.0.1

Key:zoho_cliq-new-channel-message

View on GitHub

Zoho Cliq Overview#

The Zoho Cliq API allows you to automate and integrate your team communication within Zoho Cliq. With this API, you can create bots to send messages, manage channels and users, and streamline notifications to your team about events from other applications or services. Using Pipedream, you can harness these capabilities to create powerful workflows that trigger actions within Zoho Cliq or react to events happening in Cliq to perform tasks in other apps.

Trigger Code#

import common from "../common/new-message.mjs";
import sampleEmit from "./test-event.mjs";

export default {
  ...common,
  key: "zoho_cliq-new-channel-message",
  name: "New Channel Message",
  description: "Emit new event when a new channel message is received. [See the documentation](https://www.zoho.com/cliq/help/restapi/v2/#Get_Messages)",
  version: "0.0.1",
  type: "source",
  dedupe: "unique",
  props: {
    ...common.props,
    channel: {
      propDefinition: [
        common.props.app,
        "channel",
      ],
    },
  },
  methods: {
    ...common.methods,
    getChatId() {
      return this.channel;
    },
  },
  sampleEmit,
};

Trigger 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.

Label	Prop	Type	Description
Zoho Cliq	`app`	`app`	This component uses the Zoho Cliq app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`
Channel ID	`channel`	`string`	Select a value from the drop down menu.

Trigger Authentication#

Zoho Cliq uses OAuth authentication. When you connect your Zoho Cliq account, Pipedream will open a popup window where you can sign into Zoho Cliq and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Zoho Cliq API.

Pipedream requests the following authorization scopes when you connect your account:

ZohoCliq.Buddies.READZohoCliq.Webhooks.CREATEZohoCliq.Channels.READZohoCliq.Chats.READZohoCliq.Bots.READZohoCliq.Organisation.READZohoCliq.Reminders.CREATEZohoCliq.Users.READZohoCliq.Messages.READ

About Zoho Cliq#

Chat app that's built for work. Messaging, video collaboration, task management and productivity.

Action#

Create Rows on Coda

Description:Insert a row in a selected table. [See docs](https://coda.io/developers/apis/v1#operation/upsertRows)

Version:0.0.3

Key:coda-create-rows

View on GitHub

Coda Overview#

The Coda API enables you to interact with your Coda docs for both data retrieval and manipulation. By leveraging this API on Pipedream, you can automate document updates, synchronize data across different platforms, orchestrate complex workflows, and react to changes in real-time. Coda’s tables can act as dynamic databases that interconnect with various services, allowing you to streamline operations that depend on the timely and accurate exchange of information.

Action Code#

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

export default {
  key: "coda-create-rows",
  name: "Create Rows",
  description: "Insert a row in a selected table. [See docs](https://coda.io/developers/apis/v1#operation/upsertRows)",
  version: "0.0.3",
  type: "action",
  props: {
    coda,
    docId: {
      propDefinition: [
        coda,
        "docId",
      ],
    },
    tableId: {
      propDefinition: [
        coda,
        "tableId",
        (c) => ({
          docId: c.docId,
        }),
      ],
      reloadProps: true,
    },
    disableParsing: {
      propDefinition: [
        coda,
        "disableParsing",
      ],
    },
  },
  async additionalProps() {
    const props = {};
    const { items } = await this.coda.listColumns(this, this.docId, this.tableId);
    for (const item of items) {
      props[`col_${item.id}`] = {
        type: "string",
        label: `Column: ${item.name}`,
        description: "Leave blank to ignore this column",
        optional: true,
      };
    }
    return props;
  },
  async run({ $ }) {
    const params = {
      disableParsing: this.disableParsing,
    };

    const data = {
      rows: [
        {
          cells: this.coda.createRowCells(this),
        },
      ],
    };

    const response = await this.coda.createRows(
      $,
      this.docId,
      this.tableId,
      data,
      params,
    );

    $.export("$summary", "Created row successfully");
    return response;
  },
};

Action Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

Label	Prop	Type	Description
Coda	`coda`	`app`	This component uses the Coda app.
Doc ID	`docId`	`string`	Select a value from the drop down menu.
Table ID	`tableId`	`string`	Select a value from the drop down menu.
Disable Parsing	`disableParsing`	`boolean`	If true, the API will not attempt to parse the data in any way