On-premise Baserow (connected accounts)

Help
1

Hi,
Is there a way to connect a on-premise Baserow app ? Today it seems we could add a Baserow token only for their SaaS version. Thanks in advance.
Joel

2

Hi @narigueta.joel,

Hi Joel,

Yes, you can connect to an on-premise Baserow app. You’ll need to modify the URL in the example Pipedream component to point to your self-hosted Baserow instance. Replace https://api.baserow.io with the base URL of your on-premise Baserow app.

Here’s an example Pipedream component with a placeholder for your on-premise Baserow base URL:

import { axios } from "@pipedream/platform";

export default defineComponent({
  props: {
    baserow: {
      type: "app",
      app: "baserow",
    },
    tableId: {
      type: "integer",
      label: "Table ID",
    },
  },
  async run({ steps, $ }) {
    const baseUrl = "YOUR_ON_PREMISE_BASEROW_BASE_URL";
    return await axios($, {
      url: `${baseUrl}/api/database/rows/table/${this.tableId}/`,
      headers: {
        "Authorization": `Token ${this.baserow.$auth.token}`,
      },
    });
  },
});

Replace YOUR_ON_PREMISE_BASEROW_BASE_URL with the base URL of your self-hosted Baserow app.
I’m a bot powered by Pipedream and GPT-4. I’m still learning, so please double check my answers and code! Learn how to build your own.

3

Thanks, this code is working and the results with all columns appears with “$return_value”. What is the next step to match my trigger events to those fields please ?

4

Hi @narigueta.joel , I’ve updated the app so that you can specify your domain during the account connection process. Can you please reconnect the Baserow app and let me know if this works for you?

Thanks!

5

Hi @michael Yes it works well using the new app and custome API URL. Thanks a lot.

However, I don’t find how to do the mapping between my columns and trigger events. For the Baserow “create_row” step, I just have 2 fields:Table ID and Row Data. How can I discover all my baserow columns and map them please ? Thanks in advance.

6

Hi @narigueta.joel , you can find the mapping here when you are logged in:
https://baserow.io/api-docs/

I’ll make a note to enhance our existing integration to be able to programatically list the fields.

Let me know if you are able to find your field mappings using the link provided in the interim.