Integrate the Fivetran API with the Node API

Setup the Fivetran API trigger to run a workflow which integrates with the Node API. Pipedream's integration platform allows you to integrate Fivetran and Node remarkably fast. Free for developers.

Popular Fivetran and Node Actions#

Run Node Code with the Node API

Write custom Node.js code and use any of the 400k+ npm packages available. Refer to the Pipedream Node docs to learn more.

Try it

Overview of Fivetran#

The Fivetran API enables automated, effortless replication of data from various sources into a cloud warehouse. By leveraging Fivetran in Pipedream, you can programmatically manage your Fivetran connectors, set up and control data pipelines, and trigger data syncs. Pipedream's serverless platform allows for the creation of workflows that can respond to HTTP requests, process events on a schedule, and interact with numerous other services to create complex automation solutions.

Connect Fivetran#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    fivetran: {
      type: "app",
      app: "fivetran",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.fivetran.com/v1/users`,
      headers: {
        "Content-Type": `application/json`,
      },
      auth: {
        username: `${this.fivetran.$auth.api_key}`,
        password: `${this.fivetran.$auth.api_secret}`,
      },
    })
  },
})

Overview of Node#

Develop, run and deploy your Node.js code in Pipedream workflows, using it between no-code steps, with connected accounts, or integrate Data Stores and File Stores.

This includes installing NPM packages, within your code without having to manage a package.json file or running npm install.

Below is an example of installing the axios package in a Pipedream Node.js code step. Pipedream imports the axios package, performs the API request, and shares the response with subsequent workflow steps:

Connect Node#

// To use previous step data, pass the `steps` object to the run() function
export default defineComponent({
  async run({ steps, $ }) {
    // Return data to use it in future steps
    return steps.trigger.event
  },
})

Fivetran