nocodb

Free & open source Airtable alternative

Integrate the nocodb API with the Data Stores API

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

Add or update a single record with Data Stores API on New Record in Table from nocodb API
nocodb + Data Stores
 
Try it
Add or update a single record with Data Stores API on New Update in Table from nocodb API
nocodb + Data Stores
 
Try it
Add or update multiple records with Data Stores API on New Record in Table from nocodb API
nocodb + Data Stores
 
Try it
Add or update multiple records with Data Stores API on New Update in Table from nocodb API
nocodb + Data Stores
 
Try it
Append to record with Data Stores API on New Record in Table from nocodb API
nocodb + Data Stores
 
Try it
New Record in Table from the nocodb API

Emit new event for each new record in table. See the documentation

 
Try it
New Update in Table from the nocodb API

Emit new event for each update in table. See the documentation

 
Try it
Add Record with the nocodb API

This action adds a record in a table. See the documentation

 
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 Record with the nocodb API

This action deletes a row in a table. See the documentation

 
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 Record (from row number) with the nocodb API

This action gets a row by row Id. See the documentation

 
Try it

Overview of nocodb

The NoCodeB (NocoDB) API transforms your databases into a smart Excel sheet, providing a platform for managing your data with the ease of a spreadsheet interface. When combined with Pipedream's capabilities, this API allows you to automate data operations, sync with other databases or apps, and streamline workflows without writing complex code. Using Pipedream, you can trigger events based on changes in your NocoDB, process and manipulate the data, and connect to countless apps to extend functionality, such as sending notifications, updating CRMs, or generating reports.

Connect nocodb

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    nocodb: {
      type: "app",
      app: "nocodb",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://${this.nocodb.$auth.domain}/api/v1/db/meta/nocodb/info`,
      headers: {
        "accept": `application/json`,
        "xc-token": `${this.nocodb.$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

1
2
3
4
5
6
7
8
9
10
11
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")
  },
})