nocodb

Free & open source Airtable alternative

Integrate the nocodb API with the Python API

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

Run Python Code with Python API on New Record in Table from nocodb API
nocodb + Python
 
Try it
Run Python Code with Python API on New Update in Table from nocodb API
nocodb + Python
 
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
Run Python Code with the Python API

Write Python and use any of the 350k+ PyPi packages available. Refer to the Pipedream Python docs to learn more.

 
Try it
Delete Record with the nocodb API

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

 
Try it
Get Record (from row number) with the nocodb API

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

 
Try it
List Records in Table Matching Criteria with the nocodb API

This action lists all rows in a table. 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 Python

Develop, run and deploy your Python code in Pipedream workflows. Integrate seamlessly between no-code steps, with connected accounts, or integrate Data Stores and manipulate files within a workflow.

This includes installing PyPI packages, within your code without having to manage a requirements.txt file or running pip.

Below is an example of using Python to access data from the trigger of the workflow, and sharing it with subsequent workflow steps:

Connect Python

1
2
3
4
5
def handler(pd: "pipedream"):
  # Reference data from previous steps
  print(pd.steps["trigger"]["context"]["id"])
  # Return data for use in future steps
  return {"foo": {"test":True}}