Pipedream

Build and run workflows using the Baserow API. Pipedream Steps are the building blocks you use to create workflows from your database. You can easily combine multiple steps into a workflow to integrate your Baserow app, data and API.

Supported Operations

  • Use any Baserow API in Node.js
  • Use any Baserow API in Python

Create a new workflow

Every Pipedream workflow begins with a single trigger step. Triggers define the type of event that runs your workflow. Log in to Pipedream then click on the New+ button to create a new workflow:

enter image description here

Add a trigger

Select a trigger in the workflow builder. For example, select the HTTP / Webhook Requests trigger to listen to incoming events on this workflow:

enter image description here

Select HTTP Requests to get a unique URL where you can send requests to trigger your workflow. Customize the Event Data, HTTP response and filters:

enter image description here

Pipedream will generate a unique URL where you can send HTTP requests to trigger this workflow:

enter image description here

Send data to the workflow

Visit Baserow to create an account. To get started, read our documentation on how to create a database.

enter image description here

Create a table to collect information, like name, description, email, etc. These fields will help us configure the Baserow step of the workflow.

enter image description here

Next, send data to the trigger URL to help you build the workflow. Enter the webhook URL on Baserow to send the request to in the required field. Webhooks can be used in order to inform 3rd party systems when rows in Baserow have been created, updated or deleted.

To learn more about setting webhooks, read our documentation on creating and editing webhooks.

enter image description here

When Pipedream receives the request, it will be available to select from the event selector. Click on the drop-down menu and select the event generated:

enter image description here

Pipedream will automatically display the contents of the selected event. The trigger has an event that contains a body with customer data. Expand the body to validate that the message was received:

enter image description here

As you construct your workflow, autocomplete suggestions will be based on the selected event. The information will also be used to test further steps.

Save data to Baserow database

Next, let’s add a step to the Pipedream workflow to send the data to another Baserow database.

Click Continue or the + button to add a new step to this workflow. That will open the Add a step menu. Select Baserow app:

enter image description here

Select the Use any Baserow API in Node.js action to connect your account and customize a Baserow API request:

enter image description here

You can also Use any Baserow API in Python to customize a Baserow API request.

Connect your Baserow account to Pipedream (or select it from the dropdown if you previously connected an account):

enter image description here

Baserow uses a simple token based authentication. You need to generate at least one API token in your settings. When you connect your Baserow account, Pipedream securely stores the keys so you can easily authenticate to Baserow APIs in both code and no-code steps.

Visit your account settings, copy your API token, and enter your Baserow token on Pipedream.

To generate a personal API token, read our documentation on API tokens.

enter image description here

Return to Pipedream and your connected account should automatically be selected.

Add a custom code step to the workflow

Pipedream Code steps drive the logic of your workflow and let you write any custom Node.js code. The workflow builder will accept text input to populate the steps.

To use webhook data from prior trigger step in the code step, pass props to code steps as arguments or parameters entered in the workflow builder.

Define individual props in a Node.js code step to make code steps reusable. The keys of the objects are the names of the props. For example:

props: {
    msg: {
      type: "string",
      label: "Message",
      description: "Enter a message to `console.log()`",
    },
  },

To generate the fields from the pre-built trigger step, click on Refresh fields button to read the props and generate the fields from prior steps:

enter image description here

Use the object explorer to pass the data for the workflow event as the values. This data can be found in the context object on the trigger.

When you click into a field, Pipedream will display an object explorer to make it easy to find data. Scroll or search to find the key under steps.trigger.event.body.items and click select path to connect them to the Baserow step. That will insert the reference:

enter image description here

Next, replace the [Table_ID] :

enter image description here

Return the configured value of the prop with this.myPropName:

enter image description here

After the configuration is complete, click Test to validate the configuration for this step. When the test is complete, you will see a success message and a summary of the action performed:

enter image description here

Customize the name of your workflow. Then click Deploy to run your workflow on every trigger event.

enter image description here

Anytime the workflow runs, Pipedream will execute each step of your workflow in order.

You can view the webhook response and request on Baserow. This can be useful if a call fails and you need to access why.

enter image description here

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!