Add Single Row with CloudTables API on New Field from Airtable (OAuth) API

Pipedream makes it easy to connect APIs for CloudTables, Airtable (OAuth) and 2,000+ other apps remarkably fast.

Trigger workflow on

New Field from the Airtable (OAuth) 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 Airtable (OAuth) 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 New Field trigger
1. Connect your Airtable (OAuth) account
2. Configure timer
3. Select a Base
4. Select a Table
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#

New Field on Airtable (OAuth)

Description:Emit new event for each new field created in a table

Version:0.0.6

Key:airtable_oauth-new-field

View on GitHub

Airtable (OAuth) Overview#

Airtable (OAuth) API on Pipedream allows you to manipulate and leverage your Airtable data in a myriad of powerful ways. Sync data between Airtable and other apps, trigger workflows on updates, or process bulk data operations asynchronously. By using Airtable's structured databases with Pipedream's serverless platform, you can craft custom automation solutions, integrate with other services seamlessly, and streamline complex data processes.

Trigger Code#

import common from "../common/common.mjs";

export default {
  name: "New Field",
  description: "Emit new event for each new field created in a table",
  key: "airtable_oauth-new-field",
  version: "0.0.6",
  type: "source",
  props: {
    ...common.props,
    tableId: {
      propDefinition: [
        common.props.airtable,
        "tableId",
        ({ baseId }) => ({
          baseId,
        }),
      ],
      description: "The table ID to watch for changes.",
    },
  },
  methods: {
    _getFieldIds() {
      return this.db.get("fieldIds") || [];
    },
    _setFieldIds(fieldIds) {
      this.db.set("fieldIds", fieldIds);
    },
  },
  async run() {
    const fieldIds = this._getFieldIds();

    const { tables } = await this.airtable.listTables({
      baseId: this.baseId,
    });
    const { fields } = tables.find(({ id }) => id === this.tableId);

    for (const field of fields) {
      if (fieldIds.includes(field.id)) {
        continue;
      }
      fieldIds.push(field.id);
      this.$emit(field, {
        id: field.id,
        summary: field.name,
        ts: Date.now(),
      });
    }

    this._setFieldIds(fieldIds);
  },
};

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
Airtable (OAuth)	`airtable`	`app`	This component uses the Airtable (OAuth) app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`
Base	`baseId`	`string`	Select a value from the drop down menu.
Table	`tableId`	`string`	Select a value from the drop down menu.

Trigger Authentication#

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

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

data.records:readdata.records:writedata.recordComments:readdata.recordComments:writeschema.bases:readschema.bases:writewebhook:manageuser.email:read

About Airtable (OAuth)#

Airtable is a low-code platform to build next-gen apps. Move beyond rigid tools, operationalize your critical data, and reimagine workflows with AI.

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.

About CloudTables#

Database driven applications in a snap. Our no-code / low-code solution provides seamless integration, full customization, auditing, live updating and much more.

More Ways to Connect CloudTables + Airtable (OAuth)#

Other Popular Integrations#

Delete Row with CloudTables API on New Field from Airtable API

Airtable (OAuth) + CloudTables

Add Single Row with CloudTables API on New Field from Airtable (OAuth) API

Pipedream makes it easy to connect APIs for CloudTables, Airtable (OAuth) 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