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.
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.
You can get your database parameters from the Baserow API documentation.
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 the 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.
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.
This query lists all the fields in a table.
This query will get the list of all the rows from the tables in the Baserow.
This query retrieves all the rows in a table.
This query will create row(s) in the table with input from fields.
This query will update row(s) in the table with input from fields.
This query will move row(s) in the table.
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.