Baserow Component

Interact with Baserow databases to create, read, update, or delete records.

How it Works

The Baserow Component talks directly to your Baserow database through the Baserow API.
When you set up the component, you first choose a Baserow API credential that contains your email, password, and server URL. The component then uses that credential to authenticate and send HTTP requests to the Baserow API.
Depending on the operation you pick (Create, Delete, Get, or Update), the component builds the appropriate API call, sends it, and returns the result back to the dashboard.

Operations

This component offers several operations that you can select based on what you need to do. You can only use one operation at a time:

Create: Add new records to a Baserow table.
Delete: Remove existing records from a Baserow table.
Get: Retrieve records from a Baserow table, optionally filtered and sorted.
Update: Modify existing records in a Baserow table.

To use the component, first select the operation you need in the “Operation” field.

Inputs

Mapping Mode

This component has a special mode called “Mapping Mode”. When you enable this mode using the toggle switch, an additional input called “Mapping Data” is activated, and each input field offers you three different ways to provide data:

Fixed: You type the value directly into the field.
Mapped: You connect the output of another component to use its result as the value.
Javascript: You write Javascript code to dynamically calculate the value.

This flexibility allows you to create more dynamic and connected workflows.

Input Fields

The following fields are available to configure this component. Each field may be visible in different operations:

Records: A list of records to create, update, or delete, structured like Baserow records.
- Visible in: Create, Delete, Update
Operation: Choose which action to perform.
- Visible in: Create, Delete, Get, Update
Base Name: The name of the Baserow base (database) you want to work with.
- Visible in: Create, Delete, Get, Update
Formula: Define conditions to filter the records returned by the API.
Basic Syntax: column_name,operator,value
Common Operators: equal, not_equal, contains, higher_than, higher_than_or_equal, lower_than, lower_than_or_equal, empty, not_empty, and others.
Examples: name,equal,John Doe, age,higher_than,25, category,contains,electronics.
- Visible in: Get
Last Url: The last URL used for your Baserow database. This helps the component remember the endpoint.
- Visible in: Create, Delete, Get, Update
Limit: The number of records to return. If left empty, the default is 20 records.
- Visible in: Get
Mapping Mode: Enable mapping mode to process multiple data records in batch.
- Visible in: Create, Delete, Get, Update
Order By: Define conditions to order the records returned by the API.
Basic Syntax: use column names for ascending order or prefix with - for descending order.
Examples: name (ascending), -name (descending).
- Visible in: Get
Table Name: The name of the table within the selected base where the operation will occur.
- Visible in: Create, Delete, Get, Update
Tool Name: The name of the tool that will be used when this component is connected as a tool. This name will be displayed to the agent when it selects tools to use.
- Visible in: Create, Delete, Get, Update
Tool Description: A detailed description of what this tool does. This description will help the agent understand when and how to use this tool effectively.
- Visible in: Create, Delete, Get, Update
Tools arguments metadata: Defines the arguments metadata for the tools.
- Visible in: Create, Delete, Get, Update

Credential:
Before using the component, make sure you have created a Baserow API credential in Nappai’s credentials section. Then select that credential in the component’s “Credential” field. The credential must contain:

Baserow user email
Baserow user password
Baserow Server Connection URL

Outputs

Result: The raw data returned from the Baserow API (e.g., the created, updated, or retrieved records).
Tool: A tool representation that can be used by Nappai’s AI agents to perform the same operation programmatically.

Usage Example

Example 1 – Create Records

Set Operation to Create.
Choose the Base Name and Table Name.

In Records, paste a JSON array of the records you want to add, e.g.:

[
  {"name": "Alice", "age": 30},
  {"name": "Bob", "age": 25}
]

Leave Last Url empty (the component will fill it automatically).
Click Run.
The component will send a POST request to Baserow and return the newly created records in the Result output.

Example 2 – Get Records with a Filter

Set Operation to Get.
Choose the Base Name and Table Name.
In Formula, enter age,higher_than,20 to fetch all records where age > 20.
Set Limit to 10 to retrieve only the first ten matching records.
Optionally, set Order By to -created_at to sort by newest first.
Click Run.
The component will return the filtered and sorted records in the Result output.

Baserow Custom – A lower‑level component that exposes all Baserow API endpoints.
Data Input – Use this to format or transform data before sending it to Baserow.
Data Output – Capture and display the results returned by Baserow.

Tips and Best Practices

Use Mapping Mode when you need to process many records at once; it reduces the number of API calls.
Set a Limit on Get operations to avoid pulling too much data and hitting API rate limits.
Keep your credentials secure: store them in Nappai’s credential store and never hard‑code them in your workflows.
Test with a small dataset first to confirm that your Formula and Order By syntax works as expected.

Security Considerations

The component uses the Baserow API key stored in Nappai’s credential store; ensure that only trusted users have access to that credential.
Avoid exposing the Last Url or any sensitive data in logs or public outputs.
Use HTTPS endpoints (the default Baserow URL is secure) to protect data in transit.