Integrate the Fivetran API with the Filter API

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

Popular Fivetran and Filter Actions#

Continue execution if a condition Is met with the Filter API

Continue workflow execution only if a condition is met

Try it

End execution if a condition is met with the Filter API

End workflow execution if a condition is met

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 Filter#

The Filter API in Pipedream allows for real-time data processing within workflows. It's designed to evaluate data against predefined conditions, enabling workflows to branch or perform specific actions based on those conditions. This API is instrumental in creating efficient, targeted automations that respond dynamically to diverse datasets. Using the Filter API, you can refine streams of data, ensuring that subsequent steps in your Pipedream workflow only execute when the data meets your specified criteria. This cuts down on unnecessary processing and facilitates the creation of more intelligent, context-aware systems.

Connect Filter#

export default defineComponent({
  async run({ steps, $ }) {
    let condition = false
    if (condition == false) {
      $.flow.exit("Ending workflow early because the condition is false")
    } else {
        $.export("$summary", "Continuing workflow, since condition for ending was not met.")
    }
  },
})