nocodb

Free & open source Airtable alternative

Integrate the nocodb API with the Formatting API

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

[Data] Convert JSON to String with Formatting API on New Record in Table from nocodb API
nocodb + Formatting
 
Try it
[Data] Convert JSON to String with Formatting API on New Update in Table from nocodb API
nocodb + Formatting
 
Try it
[Data] Parse JSON with Formatting API on New Record in Table from nocodb API
nocodb + Formatting
 
Try it
[Data] Parse JSON with Formatting API on New Update in Table from nocodb API
nocodb + Formatting
 
Try it
[Date/Time] Add/Subtract Time with Formatting API on New Record in Table from nocodb API
nocodb + Formatting
 
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
[Data] Convert JSON to String with the Formatting API

Convert an object to a JSON format string

 
Try it
Delete Record with the nocodb API

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

 
Try it
[Data] Parse JSON with the Formatting API

Parse a JSON string

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

Connect Formatting

1
2
3
4
5
6
export default defineComponent({
  async run({ steps, $ }) {
    const text = ' Hello world! ';
    return text.trim()
  },
})