# Load todo individual item to snowflake table

**URL:** <https://matillioncommunity.discourse.group/t/load-todo-individual-item-to-snowflake-table/1113>\
**Category:** Maia\
**Created:** [May 12, 2024, 2:48pm UTC](https://matillioncommunity.discourse.group/t/load-todo-individual-item-to-snowflake-table/1113 "2024-05-12T14:48:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![snowflakejb1](https://avatars.discourse-cdn.com/v4/letter/s/bbce88/32.png) [@snowflakejb1](https://matillioncommunity.discourse.group/u/snowflakejb1)\
**Post date:** [May 12, 2024, 2:48pm UTC](https://matillioncommunity.discourse.group/t/load-todo-individual-item-to-snowflake-table/1113/1 "2024-05-12T14:48:02Z")

</div>

I am using matillion data productivity cloud and using custom connector to invoke the API endpoints. I want to store the todo items retrieved from the todos endpoint in a Snowflake table and then use a grid iterator to iterate over the IDs stored in that Snowflake table to fetch individual todo items from the todo endpoint.

Here is the approach that I took Staging Table: This table will store the todo items fetched from the todos endpoint initially. Final Table: This table will store the individual todo items fetched from the todo endpoint using the IDs stored in the staging table.&nbsp;

1. Retrieve Todo List: Use your custom connector to make a GET request to the todos endpoint ([https://jsonplaceholder.typicode.com/todos](https://jsonplaceholder.typicode.com/todos)). This will give you a list of todo items.
2. Store Todo Items in Snowflake: After retrieving the todo items, store them in a Snowflake table.
3. Use Grid Iterator: Use a grid iterator in Matillion Data Productivity Cloud to iterate over the IDs stored in the Snowflake table.
4. Retrieve Individual Todo Items: For each ID retrieved from the grid iterator, construct the URL for the todo endpoint ([https://jsonplaceholder.typicode.com/todos/{todo\_id}](https://jsonplaceholder.typicode.com/todos/%7Btodo_id%7D)) and make a GET request to fetch the individual todo item.
5. Store Individual Todo Items in Snowflake: After retrieving each individual todo item, store the data in a Snowflake table.

However, the load strategy to the snowflake table has only following options.&nbsp;

&nbsp;

**How can I invoke the todo item endpoint for all the ids and store it in snowflake table.**

---

<div class="post-metadata">

**Author:** ![ClaireSeniorCommunityManager](https://avatars.discourse-cdn.com/v4/letter/c/7ba0ec/32.png) [@ClaireSeniorCommunityManager](https://matillioncommunity.discourse.group/u/ClaireSeniorCommunityManager)\
**Post date:** [September 13, 2024, 2:29pm UTC](https://matillioncommunity.discourse.group/t/load-todo-individual-item-to-snowflake-table/1113/2 "2024-09-13T14:29:15Z")

</div>

Hi [@snowflakejb1](https://matillioncommunity.discourse.group/u/snowflakejb1)​ and I'm sorry this wasn't spotted sooner. Have you found a solution to you initial question or did you still want input?

Many thanks,

Claire