DYNAMICALLY ITERATE MULTIPLE API ENDPOINTS FOR DATA EXTRACTION AND LOAD THE DATA INTO SNOWFLAKE WITH SCHEMA(TABLES AND COLUMNS INFORMATION )

Matillion ETL
1

Hello experts, I am new to Matillion and API data extraction process. I have task assigned using OAuth2.0. (I can get cliend id, secret , and token after creating new app in developers account).

I would like to know the steps which loop components I can use to iterate over the API endpoints.

2

Hi @sunny_etl​

You can store details required for API query component in snowflake table, each row one API endpoint dat. And then by using table iterator connected with API query - you will be able to achieve mentioned task.