NocoDB Component

NocoDB Component works with the rows of a NocoDB table from a flow: it reads them, creates new rows and updates or deletes existing ones.

When to use it

• Saving in NocoDB the data that arrives through a form or an email.
• Giving an agent access to look up a NocoDB table.
• Updating a row’s status when a process finishes.

Configuration

The Operation field decides what the component does: Create (default), Update, Delete or Get. Once you pick the credential, Workspace Name fills with your workspaces; once you pick one, Base Name fills with its bases; once you pick the base, Table Name fills with its tables. Once you pick the table, one field per column appears to type its values, and for Update and Delete the row’s ID.

You need a NocoDB credential with your NocoDB address and access token. See Credentials.

Field	What it does
Credential (required)	The NocoDB credential.
Operation	What the component does.
Workspace Name	The workspace.
Base Name	The database.
Table Name	The table.

Advanced options

Field	What it does
Limit	With Get, how many rows are returned. Default: 20.
Formula	With Get, conditions to return only some rows, in the format the field’s help explains.
Order By	With Get, the column the rows are sorted by; with a minus sign in front, in descending order, for example -name.

Output

The Result output holds the rows read or the row created, updated or deleted.

In tool mode, an agent can use the component by itself. See Tool Mode.

Example

An estate agency keeps its properties in NocoDB.

1. Add NocoDB Component with the NocoDB credential.
2. Choose Update, the workspace, the base and the Properties table.
3. Fill in the row ID and type reserved in the status column.

Related components

• Baserow Component and Airtable: the same for other spreadsheet-style databases.