Integrations Detail Views

Integrator.io
, , ,
1

Hi team,

We're looking for a way to grab the list of all integrations and underlying flows and corresponding details for each flow to better track them. I was wondering:

1- How we can export this data into gsheet or csv file? it is possible to grab the list of all integrations --> flows --> connections as a gsheet?

2- Can we access this data as a table in Snowflake? basically the list of all integrations, flows and connections as a table

3- Is there any way to automate/visualize it?

2

HI @mahsaebad,

I'm aware that someone responded to you via email, but I'm posting the response here as well for other users that might have the same question:

Our automation platform is designed to cater to such use cases. As a starting point, here are articles that can help you build this automation using our connectors:
  • Export the list of integrations, flows, or connections in your account – We have a connector for integrator.io. You can extract a list of resources like flows, connections, etc using this connector.
  • Push this data to Snowflake – You can create a Snowflake import to accomplish this task.
  • Create a GSheet import – We have a connector for Google Sheets to import the data easily.

Separately, you can also extract this data through the integrator.io REST API. You can export the raw JSON integration, flow, and connection data and add it to Snowflake as a variant data type instead of converting it into rows/columns in a CSV file first. This is a popular method with Snowflake (ELT vs. ETL).

Please feel free to reach out if you have any other questions!