Integrate the Baserow API with the Data Stores API

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

Popular Baserow and Data Stores Actions#

Create Row with the Baserow API

Create a row See docs here

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 Baserow API

Delete a row See docs here

Try it

Add or update multiple records with the Data Stores API

Add or update multiple records to your Pipedream Data Store.

Try it

Get Row with the Baserow API

Get a single row See docs here

Try it

Overview of Baserow#

The Baserow API allows you to interact programmatically with Baserow, an open-source no-code database tool. With its API, you can automate database operations such as creating, reading, updating, and deleting records. Moreover, it's possible to manage databases, tables, fields, and rows, or integrate with external services to enrich or move data in real-time. Leveraging Pipedream’s capabilities, you can trigger workflows from a variety of events and connect Baserow to numerous apps for seamless data processes.

Connect Baserow#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    baserow: {
      type: "app",
      app: "baserow",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `${this.baserow.$auth.base_api_url}/database/rows/table/[TABLE_ID]/`,
      headers: {
        "Authorization": `Token ${this.baserow.$auth.token}`,
      },
    })
  },
})

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")
  },
})