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

**URL:** https://matillioncommunity.discourse.group/t/dynamically-iterate-multiple-api-endpoints-for-data-extraction-and-load-the-data-into-snowflake-with-schema-tables-and-columns-information/2280
**Category:** Matillion ETL
**Created:** [September 7, 2023, 6:08am UTC](https://matillioncommunity.discourse.group/t/dynamically-iterate-multiple-api-endpoints-for-data-extraction-and-load-the-data-into-snowflake-with-schema-tables-and-columns-information/2280 "2023-09-07T06:08:51Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![sunny\_etl](https://avatars.discourse-cdn.com/v4/letter/s/54ee81/32.png) [@sunny\_etl](https://matillioncommunity.discourse.group/u/sunny_etl)
#### Post date: [September 7, 2023, 6:08am UTC](https://matillioncommunity.discourse.group/t/dynamically-iterate-multiple-api-endpoints-for-data-extraction-and-load-the-data-into-snowflake-with-schema-tables-and-columns-information/2280/1 "2023-09-07T06:08:51Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![ASD](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/asd/32/1323_2.png) [@ASD](https://matillioncommunity.discourse.group/u/ASD)
#### Post date: [September 7, 2023, 11:54am UTC](https://matillioncommunity.discourse.group/t/dynamically-iterate-multiple-api-endpoints-for-data-extraction-and-load-the-data-into-snowflake-with-schema-tables-and-columns-information/2280/2 "2023-09-07T11:54:22Z")

</div>

Hi [@sunny\_etl](https://matillioncommunity.discourse.group/u/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.