Fivetran

Fivetran is the leader in modern data movement. Fast-moving startups & the world’s largest companies use Fivetran to improve operations & accelerate analytics.

Integrate the Fivetran API with the Formatting API

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

[Data] Convert JSON to String with the Formatting API

Convert an object to a JSON format string

 
Try it
[Data] Parse JSON with the Formatting API

Parse a JSON string

 
Try it
[Date/Time] Add/Subtract Time with the Formatting API

Add or subtract time from a given input

 
Try it
[Date/Time] Compare Dates with the Formatting API

Get the duration between two dates in days, hours, minutes, and seconds along with checking if they are the same.

 
Try it
[Date/Time] Format with the Formatting API

Format a date string to another date string

 
Try it

Connect Fivetran

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
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}`,
      },
    })
  },
})

Connect Formatting

1
2
3
4
5
6
export default defineComponent({
  async run({ steps, $ }) {
    const text = ' Hello world! ';
    return text.trim()
  },
})