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

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

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:

enter image description here

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

https://baserow-media.ams3.digitaloceanspaces.com/pagedown-uploads/5b11971d-42f5-4dbd-943e-11e45d7376cc/Screenshot_2022-10-26_at_08.40.47.png

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:

https://baserow-media.ams3.digitaloceanspaces.com/pagedown-uploads/7e80259c-ef06-44b0-896c-223af2459ae1/Screenshot_2022-10-26_at_09.09.39.png

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:

https://baserow-media.ams3.digitaloceanspaces.com/pagedown-uploads/b2a075a9-cd3e-4a99-b860-f7205b63ae31/Screenshot_2022-10-27_at_09.42.26.png

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.

enter image description here

List rows

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

enter image description here

Get row

This query retrieves all the rows in a table.

enter image description here

Create row

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

enter image description here

Update row

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

enter image description here

Move row

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

enter image description here

Delete row

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

enter image description here

For a more detailed tutorial, refer to this article on How to Build a Custom CRM System with Baserow and ToolJet. If you’re looking for something else, please feel free to make recommendations or ask us questions in our online community —we’re ready to assist you!