# Retrieve all items nested in collections without using unique collection names

**URL:** https://community.make.com/t/retrieve-all-items-nested-in-collections-without-using-unique-collection-names/39720
**Category:** Questions
**Tags:** collections, arrays, functions
**Created:** [May 31, 2024, 2:44pm UTC](https://community.make.com/t/retrieve-all-items-nested-in-collections-without-using-unique-collection-names/39720 "2024-05-31T14:44:51Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Dmitry\_Poberezhny](https://avatars.discourse-cdn.com/v4/letter/d/3e96dc/32.png) [@Dmitry\_Poberezhny](https://community.make.com/u/Dmitry_Poberezhny)
#### Post date: [May 31, 2024, 2:44pm UTC](https://community.make.com/t/retrieve-all-items-nested-in-collections-without-using-unique-collection-names/39720/1 "2024-05-31T14:44:51Z")

</div>

Hi all, I have a problem getting values from a collection as individual rows.  
My goal: get the data from each nested collection and load it into a Big Query table.

Here is my current setup:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/d/bd5855db99cf4d2df2c4561ade9ded1ffd1e7f7c.png)

The problem is that the response I get from the HTTP module changes the ID of the individual collection. Each ID is a set of data about a phone call.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/d/adc9255bde5dd78c23a257bb48a6c084dcf93c73.png)

After processing in Iterator I get a packet with collections that cannot be passed to Big Query

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/d/bdb74757bd3184240d05954cd05b6e6cfb45ff40.png)  
[Bundle output content.txt](https://community.make.com/uploads/short-url/hd8Q0emdyIOBDKXVy6sDbIOQ4dr.txt) (6.8 KB)

Now the Big Query module does not see the value or rows

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/a/fa28c903a6d9c5a7b3d53bd06d3a1b0707e3ab49.png)

Please help me to find ideas to solve this problem.

---

<div class="post-metadata">

### Author: ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)
#### Post date: [May 31, 2024, 3:15pm UTC](https://community.make.com/t/retrieve-all-items-nested-in-collections-without-using-unique-collection-names/39720/2 "2024-05-31T15:15:43Z")

</div>

Welcome to the Make community!

You can use the built-in function `toArray` in an Iterator module.

toArray(11.data.listOfGetCalls)

[samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make)

> Join the unofficial [Make Discord server](https://samliew.com/make-discord-invite) to chat with us!

---

<div class="post-metadata">

### Author: ![Dmitry\_Poberezhny](https://avatars.discourse-cdn.com/v4/letter/d/3e96dc/32.png) [@Dmitry\_Poberezhny](https://community.make.com/u/Dmitry_Poberezhny)
#### Post date: [May 31, 2024, 6:24pm UTC](https://community.make.com/t/retrieve-all-items-nested-in-collections-without-using-unique-collection-names/39720/3 "2024-05-31T18:24:34Z")

</div>

It works. Thank you!

---

<div class="post-metadata">

### Author: ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [June 14, 2024, 6:34pm UTC](https://community.make.com/t/retrieve-all-items-nested-in-collections-without-using-unique-collection-names/39720/4 "2024-06-14T18:34:03Z")

</div>


