Integrate the CloudTables API with the Data Stores API

Setup the CloudTables API trigger to run a workflow which integrates with the Data Stores API. Pipedream's integration platform allows you to integrate CloudTables and Data Stores remarkably fast. Free for developers.

Popular CloudTables and Data Stores Actions#

Add Single Row with the CloudTables API

Add a single row of data into CloudTable data set

Try it

Add or update a single record with the Data Stores API

Add or update a single record in your Pipedream Data Store.

Try it

Delete Row with the CloudTables API

Delete a row in a CloudTable data set

Try it

Add or update multiple records with the Data Stores API

Add or update multiple records to your Pipedream Data Store.

Try it

Update Row with the CloudTables API

Update a row in a CloudTable data set

Try it

Overview of CloudTables#

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.

Connect CloudTables#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    cloudtables: {
      type: "app",
      app: "cloudtables",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://${this.cloudtables.$auth.subdomain}.cloudtables.io/api/1/datasets`,
      params: {
        key: `${this.cloudtables.$auth.api_key}`,
      },
    })
  },
})

Overview of Data Stores#

Data Stores are a key-value store that allow you to persist state and share data across workflows. You can perform CRUD operations, enabling dynamic data management within your serverless architecture. Use it to save results from API calls, user inputs, or interim data; then read, update, or enrich this data in subsequent steps or workflows. Data Stores simplify stateful logic and cross-workflow communication, making them ideal for tracking process statuses, aggregating metrics, or serving as a simple configuration store.

Connect Data Stores#

export default defineComponent({
  props: {
    myDataStore: {
      type: "data_store",
    },
  },
  async run({ steps, $ }) {
    await this.myDataStore.set("key_here","Any serializable JSON as the value")
    return await this.myDataStore.get("key_here")
  },
})