Add Single Row with CloudTables API on Meeting Started from Zoom Admin API

Pipedream makes it easy to connect APIs for CloudTables, Zoom Admin and 2,000+ other apps remarkably fast.

Trigger workflow on

Meeting Started from the Zoom Admin API

Next, do this

Add Single Row with the CloudTables API

No credit card required

▶

Watch us build a workflow

8 min

Watch now ➜

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

Developers ♥ Pipedream

Getting Started#

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

Select this integration
Configure the Meeting Started trigger
1. Connect your Zoom Admin account
2. Configure zoomApphook
Configure the Add Single Row action
1. Connect your CloudTables account
2. Select a Data set
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#

Meeting Started on Zoom Admin

Description:Emits an event each time a meeting starts in your Zoom account

Version:0.1.4

Key:zoom_admin-meeting-started

View on GitHub

Zoom Admin Overview#

The Zoom Admin API lets you harness the extensive capabilities of Zoom for automation and integration, right within Pipedream. Automate user management, track Zoom rooms, monitor webinars and meetings, and customize your workflow to respond dynamically to events like new participants or ended meetings. With these APIs and the power of Pipedream, you can streamline administrative tasks, extract valuable insights, and sync Zoom activities with other services.

Trigger Code#

import { v4 as uuidv4 } from "uuid";
import zoomAdmin from "../../zoom_admin.app.mjs";

export default {
  key: "zoom_admin-meeting-started",
  type: "source",
  name: "Meeting Started",
  description: "Emits an event each time a meeting starts in your Zoom account",
  version: "0.1.4",
  dedupe: "unique", // Dedupe based on meeting ID
  props: {
    zoomAdmin,
    zoomApphook: {
      type: "$.interface.apphook",
      appProp: "zoomAdmin",
      eventNames: [
        "meeting.started",
      ],
    },
  },
  async run(event) {
    const { payload } = event;
    this.$emit(event, {
      summary: payload?.object?.topic
        ? `Meeting ${payload?.object?.topic} started`
        : "Meeting started",
      id: payload?.object?.uuid ?? uuidv4(),
      ts: payload?.object?.start_time
        ? +new Date(payload.object.start_time)
        : new Date(),
    });
  },
};

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
Zoom Admin	`zoomAdmin`	`app`	This component uses the Zoom Admin app.
	`zoomApphook`	`$.interface.apphook`

Trigger Authentication#

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

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

About Zoom Admin#

Video conferencing (includes account-level scopes) for Zoom Admins.

Action#

Add Single Row on CloudTables

Description:Add a single row of data into CloudTable data set

Version:0.0.1

Key:cloudtables-add-single-row

View on GitHub

CloudTables Overview#

CloudTables API allows the creation and manipulation of sophisticated and dynamic data tables in the cloud. With this API, you can manage table schemas, insert, update, and fetch data in real time, and control access with fine-grained permissions. Leveraging CloudTables on Pipedream, you can automate data flows, sync with other services, and respond to events—think of it as supercharging your data tables with the power of integration and automation.

Action Code#

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

export default {
  key: "cloudtables-add-single-row",
  name: "Add Single Row",
  description: "Add a single row of data into CloudTable data set",
  version: "0.0.1",
  type: "action",
  props: {
    cloudtables,
    datasetID: {
      propDefinition: [
        cloudtables,
        "datasetID",
      ],
      withLabel: true,
      reloadProps: true,
    },
  },
  async additionalProps() {
    const datasetID = this.datasetID?.value ?? this.datasetID;
    const dataSetSchema = await this.cloudtables.getDataSetSchema(datasetID);
    const { datapoints } = dataSetSchema;

    const props = {};
    for (const datapoint of datapoints) {
      // the column type is not available in cloudtables API
      props[`col_${datapoint.id}`] = {
        type: "string",
        label: datapoint.name,
        optional: true,
      };
    }

    return props;
  },
  async run({ $ }) {
    const datasetID = this.datasetID?.value ?? this.datasetID;
    const dataSetSchema = await this.cloudtables.getDataSetSchema(datasetID);
    const { datapoints } = dataSetSchema;

    if (datapoints.length === 0) {
      throw new Error(`No data points available at [${datasetID}].`);
    }

    const rowData = datapoints
      .reduce((prevValue, currValue) => {
        return {
          ...prevValue,
          [currValue.id]: this[`col_${currValue.id}`],
        };
      }, {});

    const postRowResponse = await this.cloudtables.postRowIntoDataSet(datasetID, rowData);

    $.export("$summary", `Added 1 row to [${datasetID}].`);

    return postRowResponse;
  },
};

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
CloudTables	`cloudtables`	`app`	This component uses the CloudTables app.
Data set	`datasetID`	`string`	Select a value from the drop down menu.

Action Authentication#

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

To connect your CloudTables account with Pipedream,

Copy your custom subdomain from the Setting page of your CloudTables. You can also copy it from the URL directly (if the URL is https://123abc.cloudtables.com, your subdomain is 123abc.
Copy your api_key from the Security page of your CloudTables account.

Add Single Row with CloudTables API on Meeting Started from Zoom Admin API

Pipedream makes it easy to connect APIs for CloudTables, Zoom Admin and 2,000+ other apps remarkably fast.

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

Developers ♥ Pipedream

1-24of2,000+apps by most popular

1
-
24
of
2,000+
apps by most popular