ToolJet

Use 1000s of open source triggers and actions across 900+ apps or write custom code to integrate any app or API in seconds.

ToolJet is an open-source low-code platform that allows you to quickly build applications and perform operations in your Baserow database. You can connect ToolJet with more than 30 different data sources, including Baserow.

What you’ll need

• A Baserow account in either the self-hosted or hosted baserow.io SaaS versions
• A free account on ToolJet Cloud or run on your local machine

You need to authenticate with your Baserow database API token before you can connect the CRM data to ToolJet.

For detailed information on how to create a database token, visit our documentation.

Supported operations

• List fields
• List rows
• Get row
• Create row
• Update row
• Move row
• Delete row

Parameters

• Table ID
• Row ID
• Before ID - The row will be moved before the entered ID. If not provided, then the row will be moved to the end
• Records

You can get your database parameters from the Baserow API documentation.

Connect Baserow to ToolJet

Select the ‘Sources’ tab in the app builder’s left sidebar to access the Datasource manager in ToolJet.

Click the ‘+ add data source’ button to add a datasource:

Select Baserow from the modal that pops up as the data source that you want to add:

Input your Baserow API token in ToolJet and select whether it’s Baserow Cloud (hosted version of Baserow) or Self-Host. For self-hosted option, a base URL is required to connect.

Then, click the Save button to save the datasource:

The fields that are marked as encrypted will be encrypted before saving them to ToolJet’s database.

Build Queries

To create a new query, click on the + icon of the query editor.

A query is a request for data or information from a database table or combination of tables.

Select the Baserow datasource:

Create a new Baserow query and select an operation from the operations dropdown and input the required parameters.

List fields

This query lists all the fields in a table.

List rows

This query will get the list of all the rows from the tables in the Baserow.

Get row

This query retrieves all the rows in a table.

Create row

This query will create row(s) in the table with input from fields.

Update row

This query will update row(s) in the table with input from fields.

Move row

This query will move row(s) in the table.

Delete row

This query will delete row(s) in the table.

For a more detailed tutorial, refer to this article on How to Build a Custom CRM System with Baserow and ToolJet.

---

Still need help? If you’re looking for something else, please feel free to make recommendations or ask us questions—we’re ready to assist you.

   Ask the Baserow community

   Contact support for questions about Baserow or help with your account.