PocketBase
ToolJet connects to your PocketBase database, allowing you to directly interact with your PocketBase backend from the convenience of your ToolJet application.
NOTE: Before following this guide, it is assumed that you have already completed the process of Using Marketplace plugins.
Connection
-
To connect to PocketBase, you need the Host URL, email, and password. The Host URL is the URL of your PocketBase instance. Email and password are the credentials of the user who has access to the PocketBase instance.
-
Establish a connection to PocketBase by either clicking
+Add new Data source
on the query panel or navigating to the Data Sources page from the ToolJet dashboard. -
Enter your Host URL, email and password into their designated fields.
-
Click Test Connection to validate your credentials. Click Save to store the data source.
Querying PocketBase
-
To perform queries on PocketBase in ToolJet, click the +Add button in the query manager located at the bottom panel of the editor.
-
Select the previously configured PocketBase datasource.
-
In the Operation dropdown, select the desired operation type. ToolJet currently supports five query types for PocketBase interactions.
-
Enter the collection name and other required parameters for the selected operation and click on Run button to run the query.
Query results can be transformed using transformations. Read our transformations documentation.
Supported Operations
You can create query for PocketBase data source to perform several operations such as:
List Records
Required parameters:
- Collection Name - Collection name in the database.
Optional Parameters:
- Limit - Number of records to be fetched.
- Sort - Sort the records based on a sort rule. Add
-
/+
(default) in front of the attribute for DESC / ASC order. - Where - Filter the records based on a filter conditions.
Get Record
Required parameters:
- Collection Name - Collection name in the database.
- Record ID - ID of the record to be fetched.
Add Record to Collection
Required parameters:
- Collection Name - Collection name in the database.
- Body - Data to be added to the collection. It should be in valid JSON format.
Update Record to Collection
Required parameters:
- Collection Name - Collection name in the database.
- Record ID - ID of the record to be updated.
- Body - Data to be updated in the collection. It should be in valid JSON format.
Delete Record
Required parameters:
- Collection Name - Collection name in the database.
- Record ID - ID of the record to be deleted.