Baserow
Baserow in ZBrain Flow is an open-source, no-code database builder that empowers you to create, retrieve, and manage data in a user-friendly environment. By integrating Baserow into your ZBrain Flow, you can streamline your data operations across various tables, automate updates, and leverage custom API calls for more advanced functionality.
How to Integrate Baserow with ZBrain Flow?
Click the “+” Button in the Flow Open your ZBrain Flow and select the plus sign (+) to add a new step.
Search for “Baserow” Type “Baserow” in the search bar to view the available tasks.
Choose the Desired Task Select the specific Baserow task you want to include in your Flow.
Tasks You Can Perform on Baserow
Create Row: Add a new row to a Baserow table by specifying the fields and values.
Delete Row: Remove an existing row from a table so it no longer appears in searches or views.
Get Row: Fetch a single row from a Baserow table based on a given identifier.
List Rows: Retrieve multiple rows (in pages) from a table, allowing you to process large datasets efficiently.
Update Row: Modify an existing row by changing or adding new field values.
Custom API Call: Make a tailored API request to interact with Baserow’s endpoints, offering greater control and flexibility for advanced use cases.
Create Row
Add a new row to a Baserow table by specifying the fields and values.
How to Configure the “Create Row” Action with Baserow in ZBrain Flow?
Step 1: Create a Baserow Connection
Log in to your Baserow Account.
Click on your profile-pic(top-left) and navigate to Settings->Database tokens.
Create a new token with any name and appropriate workspace.
After token creation, click on the right beside the token name and copy the database token.
Step 2: Add the “Create Row” Step
Insert a New Step
In your ZBrain Flow, click the + button to add a new step.
Search for “Baserow”
Type “Baserow” in the search bar and select Create Row from the available actions.
Step 3: Enter Connection Details
In ZBrain Flow, select the existing Connection or click Create New Connection.
Connection Name: Give your connection a descriptive name (e.g., “Baserow”).
API URL: Provide the base URL for your Baserow instance (e.g.,
https://api.baserow.io).Database Token: Paste the token you copied from your Baserow settings.
Save the Connection
Click Save to finalize your connection. Your new Baserow connection is now ready to use.
Step 4: Configure the “Create Row” Action
Table ID
Enter the ID of the table where you want to add a new row.
You can find the table ID in your Baserow workspace (often displayed in the URL or settings for the specific table).
Step 5. Save and Test
Save the Step
After entering all required details, click Save or Done.
Run the Flow
Trigger the flow to ensure that the new row is successfully created in your Baserow table.
Verify in Baserow
Open your Baserow workspace and check the specified table to confirm the row has been added with the correct data.
Delete Row
Remove an existing row from a table so it no longer appears in searches or views.
How to Configure the “Delete Row” Action with Baserow in ZBrain Flow?
Step 1: Create a Baserow Connection
Log in to your Baserow Account.
Click on your profile-pic(top-left) and navigate to Settings->Database tokens.
Create a new token with any name and appropriate workspace.
After token creation, click on the right beside the token name and copy the database token.
Step 2: Add the “Delete Row” Step
Insert a New Step
In your ZBrain Flow, click the + button to add a new step.
Search for “Baserow”
Type “Baserow” in the search bar and select Delete Row from the available actions.
Step 3: Enter Connection Details
In ZBrain Flow, select the existing Connection or click Create New Connection.
Connection Name: Give your connection a descriptive name (e.g., “Baserow”).
API URL: Provide the base URL for your Baserow instance (e.g.,
https://api.baserow.io).Database Token: Paste the token you copied from your Baserow settings.
Save the Connection
Click Save to finalize your connection. Your new Baserow connection is now ready to use.
Step 4: Configure the “Delete Row” Action
Table ID
Enter the ID of the table from where you want to delete a row.
You can find the table ID in your Baserow workspace (often displayed in the URL or settings for the specific table).
Row ID
Provide the unique identifier for the record you wish to remove.
In Baserow, every row is assigned an ID (a numeric value) that remains consistent for the row’s lifetime.
You can retrieve this ID from a previous step in your flow (e.g., a “List Rows” or “Get Row” step), or by checking the row details directly in your Baserow table.
Step 4. Save and Test
Save the Step
Once you’ve entered the Table ID and Row ID, click Save or Done.
Run the Flow
Trigger the flow to ensure that the specified row is successfully removed from your Baserow table.
Verify in Baserow
Open your Baserow workspace and check the table to confirm the row has been deleted.
Get Row
Fetch a single row from a Baserow table based on a given identifier.
How to Configure the “Get Row” Action with Baserow in ZBrain Flow?
Step 1: Create a Baserow Connection
Log in to your Baserow Account.
Click on your profile-pic(top-left) and navigate to Settings->Database tokens.
Create a new token with any name and appropriate workspace.
After token creation, click on the right beside the token name and copy the database token.
Step 2: Add the “Get Row” Step
Insert a New Step
In your ZBrain Flow, click the + button to add a new step.
Search for “Baserow”
Type “Baserow” in the search bar and select Get Row from the available actions.
Step 3: Enter Connection Details
In ZBrain Flow, select the existing Connection or click Create New Connection.
Connection Name: Give your connection a descriptive name (e.g., “Baserow”).
API URL: Provide the base URL for your Baserow instance (e.g.,
https://api.baserow.io).Database Token: Paste the token you copied from your Baserow settings.
Save the Connection
Click Save to finalize your connection. Your new Baserow connection is now ready to use.
Step 4: Configure the “Get Row” Action
Table ID
Enter the ID of the table where the row resides.
You can typically find this in your Baserow workspace (often shown in the URL or table settings).
Row ID
Provide the unique identifier for the row you want to retrieve.
Every record in Baserow has a numeric ID assigned automatically, which you can find by looking at the table data or retrieving rows via a “List Rows” action.
List Rows
Retrieve multiple rows (in pages) from a table, allowing you to process large datasets efficiently.
How to Configure the “List Rows” Action in Baserow Using ZBrain Flow?
Step 1: Create a Baserow Connection
Log in to your Baserow Account.
Click on your profile-pic(top-left) and navigate to Settings->Database tokens.
Create a new token with any name and appropriate workspace.
After token creation, click on the right beside the token name and copy the database token.
Step 2: Add the “List Rows” Step
Insert a New Step
In your ZBrain Flow, click the + button to add a new step.
Search for “Baserow”
Type “Baserow” in the search bar and select List Rows from the available actions.
Step 3: Enter Connection Details
In ZBrain Flow, select the existing Connection or click Create New Connection.
Connection Name: Give your connection a descriptive name (e.g., “Baserow”).
API URL: Provide the base URL for your Baserow instance (e.g.,
https://api.baserow.io).Database Token: Paste the token you copied from your Baserow settings.
Save the Connection
Click Save to finalize your connection. Your new Baserow connection is now ready to use.
Step 3: Configure the “List Rows” Action
Table ID Enter the ID of the table from which you want to retrieve rows. You can usually find the Table ID in your Baserow workspace (often in the URL or table settings).
Limit (Optional) Set the maximum count of rows you want to fetch. If left blank, Baserow will return all available rows (up to any default or plan-based limits).
Search (Optional) Provide a keyword or phrase to limit the rows to only those containing a match in any text-based field. Useful if you need to quickly filter records by a specific value.
Order By (Optional) Specify a field name to sort by.
You can also append
-before the field name (e.g.,-id) to sort in descending order.If left blank, Baserow uses the default ordering of the table.
Update Row
Modify an existing row by changing or adding new field values.
How to Configure the “Update Row” Action in Baserow Using ZBrain Flow?
Step 1: Create a Baserow Connection
Log in to your Baserow Account.
Click on your profile-pic(top-left) and navigate to Settings->Database tokens.
Create a new token with any name and appropriate workspace.
After token creation, click on the right beside the token name and copy the database token.
Step 2: Add the “Update Row” Step
Insert a New Step
In your ZBrain Flow, click the + button to add a new step.
Search for “Baserow”
Type “Baserow” in the search bar and select Update Row from the available actions.
Step 3: Enter Connection Details
In ZBrain Flow, select the existing Connection or click Create New Connection.
Connection Name: Give your connection a descriptive name (e.g., “Baserow”).
API URL: Provide the base URL for your Baserow instance (e.g.,
https://api.baserow.io).Database Token: Paste the token you copied from your Baserow settings.
Save the Connection
Click Save to finalize your connection. Your new Baserow connection is now ready to use.
Step 4: Configure the “Update Row” Action
Table ID
Enter the ID of the table where the row currently exists.
You can typically find the Table ID in your Baserow workspace (often in the URL or table settings).
Row ID
Provide the unique identifier (numeric ID) for the record you want to modify.
This ID can be retrieved from a previous step (e.g., “List Rows” or “Get Row”) or by checking the row details in Baserow.
Custom API Call
Make a tailored API request to interact with Baserow’s endpoints, offering greater control and flexibility for advanced use cases.
How to Configure the “Custom API Call” Action in Baserow Using ZBrain Flow?
Step 1: Create a Baserow Connection
Log in to your Baserow Account.
Click on your profile-pic(top-left) and navigate to Settings->Database tokens.
Create a new token with any name and appropriate workspace.
After token creation, click on the right beside the token name and copy the database token.
Step 2: Add the “Update Row” Step
Insert a New Step
In your ZBrain Flow, click the + button to add a new step.
Search for “Baserow”
Type “Baserow” in the search bar and select Custom API Call from the available actions.
Step 3: Enter Connection Details
In ZBrain Flow, select the existing Connection or click Create New Connection.
Connection Name: Give your connection a descriptive name (e.g., “Baserow”).
API URL: Provide the base URL for your Baserow instance (e.g.,
https://api.baserow.io).Database Token: Paste the token you copied from your Baserow settings.
Save the Connection
Click Save to finalize your connection. Your new Baserow connection is now ready to use.
Step 4: Configure the Request Details
Method
Select the HTTP method (e.g., GET, POST, PUT, DELETE) based on what you want to achieve with the Baserow API.
Headers
Typically, your authorization header is automatically handled by the connection.
Add any additional headers if required by your specific Baserow endpoint (e.g.,
Content-Type: application/json).
Query Parameters (Optional)
If the endpoint you’re calling requires query parameters (e.g.,
?page=2), add them here.Click Add Item to include each key-value pair.
Body (Optional)
For POST or PUT requests, provide the JSON body here.
This might include fields like
name,order, or other data as specified by Baserow’s API documentation.
No Error on Failure (Toggle)
Enable this if you want the flow to continue, even if the API call returns an error.
Timeout (in seconds) (Optional)
Set a custom timeout to specify how long the step should wait before timing out.
Step 5: Save and Test
Save Your Configuration
Click Save or Done after entering the required details.
Run the Flow
Test the flow to ensure the “Custom API Call” communicates properly with Baserow.
Check the Output
Inspect the response to verify that the call returned the expected data or performed the desired action.
Last updated
