Retrieve all items nested in collections without using unique collection names

[Dmitry_Poberezhny]

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:

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.

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

Bundle output content.txt (6.8 KB)

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

Please help me to find ideas to solve this problem.

[samliew]

Welcome to the Make community!

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

toArray(11.data.listOfGetCalls)

samliew – request private consultation

Join the unofficial Make Discord server to chat with us!

[Dmitry_Poberezhny]

It works. Thank you!