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?

1. Click the “+” Button in the Flow Open your ZBrain Flow and select the plus sign (+) to add a new step.

2. Search for “Baserow” Type “Baserow” in the search bar to view the available tasks.

3. 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

1. Log in to your Baserow Account.

2. Click on your profile-pic(top-left) and navigate to Settings->Database tokens.

3. Create a new token with any name and appropriate workspace.

4. After token creation, click on the right beside the token name and copy the database token.

5. Enter your Baserow API URL.If you are using Baserow - Open source no-code database , you can leave the default one.

Step 2: Add the “Create Row” Step

1. Insert a New Step

   • In your ZBrain Flow, click the + button to add a new step.

2. Search for “Baserow”

   • Type “Baserow” in the search bar and select Create Row from the available actions.

Step 3: Enter Connection Details

1. In ZBrain Flow, select the existing Connection or click Create New Connection.

2. Connection Name: Give your connection a descriptive name (e.g., “Baserow”).

3. API URL: Provide the base URL for your Baserow instance (e.g., https://api.baserow.io).

4. Database Token: Paste the token you copied from your Baserow settings.

5. 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

1. 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

1. Save the Step

   • After entering all required details, click Save or Done.

2. Run the Flow

   • Trigger the flow to ensure that the new row is successfully created in your Baserow table.

3. 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

1. Log in to your Baserow Account.

2. Click on your profile-pic(top-left) and navigate to Settings->Database tokens.

3. Create a new token with any name and appropriate workspace.

4. After token creation, click on the right beside the token name and copy the database token.

5. Enter your Baserow API URL.If you are using Baserow - Open source no-code database , you can leave the default one.

Step 2: Add the “Delete Row” Step

1. Insert a New Step

   • In your ZBrain Flow, click the + button to add a new step.

2. Search for “Baserow”

   • Type “Baserow” in the search bar and select Delete Row from the available actions.

Step 3: Enter Connection Details

1. In ZBrain Flow, select the existing Connection or click Create New Connection.

2. Connection Name: Give your connection a descriptive name (e.g., “Baserow”).

3. API URL: Provide the base URL for your Baserow instance (e.g., https://api.baserow.io).

4. Database Token: Paste the token you copied from your Baserow settings.

5. 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

1. 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).

2. 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

1. Save the Step

   • Once you’ve entered the Table ID and Row ID, click Save or Done.

2. Run the Flow

   • Trigger the flow to ensure that the specified row is successfully removed from your Baserow table.

3. 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

1. Log in to your Baserow Account.

2. Click on your profile-pic(top-left) and navigate to Settings->Database tokens.

3. Create a new token with any name and appropriate workspace.

4. After token creation, click on the right beside the token name and copy the database token.

5. Enter your Baserow API URL.If you are using Baserow - Open source no-code database , you can leave the default one.

Step 2: Add the “Get Row” Step

1. Insert a New Step

   • In your ZBrain Flow, click the + button to add a new step.

2. Search for “Baserow”

   • Type “Baserow” in the search bar and select Get Row from the available actions.

Step 3: Enter Connection Details

1. In ZBrain Flow, select the existing Connection or click Create New Connection.

2. Connection Name: Give your connection a descriptive name (e.g., “Baserow”).

3. API URL: Provide the base URL for your Baserow instance (e.g., https://api.baserow.io).

4. Database Token: Paste the token you copied from your Baserow settings.

5. 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

1. Log in to your Baserow Account.

2. Click on your profile-pic(top-left) and navigate to Settings->Database tokens.

3. Create a new token with any name and appropriate workspace.

4. After token creation, click on the right beside the token name and copy the database token.

5. Enter your Baserow API URL.If you are using Baserow - Open source no-code database , you can leave the default one.

Step 2: Add the “List Rows” Step

1. Insert a New Step

   • In your ZBrain Flow, click the + button to add a new step.

2. Search for “Baserow”

   • Type “Baserow” in the search bar and select List Rows from the available actions.

Step 3: Enter Connection Details

1. In ZBrain Flow, select the existing Connection or click Create New Connection.

2. Connection Name: Give your connection a descriptive name (e.g., “Baserow”).

3. API URL: Provide the base URL for your Baserow instance (e.g., https://api.baserow.io).

4. Database Token: Paste the token you copied from your Baserow settings.

5. 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

1. Log in to your Baserow Account.

2. Click on your profile-pic(top-left) and navigate to Settings->Database tokens.

3. Create a new token with any name and appropriate workspace.

4. After token creation, click on the right beside the token name and copy the database token.

5. Enter your Baserow API URL.If you are using Baserow - Open source no-code database , you can leave the default one.

Step 2: Add the “Update Row” Step

1. Insert a New Step

   • In your ZBrain Flow, click the + button to add a new step.

2. Search for “Baserow”

   • Type “Baserow” in the search bar and select Update Row from the available actions.

Step 3: Enter Connection Details

1. In ZBrain Flow, select the existing Connection or click Create New Connection.

2. Connection Name: Give your connection a descriptive name (e.g., “Baserow”).

3. API URL: Provide the base URL for your Baserow instance (e.g., https://api.baserow.io).

4. Database Token: Paste the token you copied from your Baserow settings.

5. 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

1. 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).

1. 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

1. Log in to your Baserow Account.

2. Click on your profile-pic(top-left) and navigate to Settings->Database tokens.

3. Create a new token with any name and appropriate workspace.

4. After token creation, click on the right beside the token name and copy the database token.

5. Enter your Baserow API URL.If you are using Baserow - Open source no-code database , you can leave the default one.

Step 2: Add the “Update Row” Step

1. Insert a New Step

   • In your ZBrain Flow, click the + button to add a new step.

2. Search for “Baserow”

   • Type “Baserow” in the search bar and select Custom API Call from the available actions.

Step 3: Enter Connection Details

1. 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.

2. Save the Connection

   • Click Save to finalize your connection. Your new Baserow connection is now ready to use.

Step 4: Configure the Request Details

1. Method

   • Select the HTTP method (e.g., GET, POST, PUT, DELETE) based on what you want to achieve with the Baserow API.

2. 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).

3. 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.

4. 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.

5. No Error on Failure (Toggle)

   • Enable this if you want the flow to continue, even if the API call returns an error.

6. Timeout (in seconds) (Optional)

   • Set a custom timeout to specify how long the step should wait before timing out.

Step 5: Save and Test

1. Save Your Configuration

   • Click Save or Done after entering the required details.

2. Run the Flow

   • Test the flow to ensure the “Custom API Call” communicates properly with Baserow.

3. Check the Output

   • Inspect the response to verify that the call returned the expected data or performed the desired action.