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 Data Stores API
Setup the Fivetran API trigger to run a workflow which integrates with the Data Stores API. Pipedream's integration platform allows you to integrate Fivetran and Data Stores remarkably fast. Free for developers.
Popular Fivetran and Data Stores Actions#
Add or update a single record with the Data Stores API
Add or update a single record in your Pipedream Data Store.
Add or update multiple records with the Data Stores API
Add or update multiple records to your Pipedream Data Store.
Append to record with the Data Stores API
Append to a record in your data store Pipedream Data Store. If the record does not exist, a new record will be created in an array format.
Check for existence of key with the Data Stores API
Check if a key exists in your Pipedream Data Store or create one if it doesn't exist.
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}`,
},
})
},
})
Overview of Data Stores#
With the Data Stores API, you can build applications that:
- Store data for later retrieval
- Retrieve data from a store
- Update data in a store
- Delete data from a store
Connect Data Stores#
1
2
3
4
5
6
7
8
9
10
11
export default defineComponent({
props: {
myDataStore: {
type: "data_store",
},
},
async run({ steps, $ }) {
await this.myDataStore.set("key_here","Any serializable JSON as the value")
return await this.myDataStore.get("key_here")
},
})