Hello
I’m building a scenario to extract data from data returned from a http call to the World Bank API. I’ve used an array iterator to extract the data into bundles:
I now want to extract particular fields from the bundles: name, region and capitalCity. I’m extracting the data into an Excel file. However when I try to map these fields into the Microsoft Excel. It won’t display the data as shown above, only the “value” item:
I’m relevant new to Make and I feel like I’m not understanding something important about how the iterator module works and the data structure it’s displaying. Would anybody be able to help with how to extract the individual data items?
Many thanks
Hello Ian,
I think the issue might be that you should use the iterator with ID 4 instead of ID 5. From the screenshots, iterator 4 seems to contain the country objects with fields like name, region, and capitalCity, while iterator 5 only exposes the value field.
Maybe try mapping the fields from iterator 4 and see if that solves the issue.
If it still doesn’t work, feel free to share more information about the scenario flow and the iterator configuration.
Have a nice day.
Marc
Hi @Marc_Ruiz_7
Many thanks for the reply and the assistance, much appreciated.
I resolved it then end. I think it was a problem to do with the way data was actually coming from the source http module. I’ve tried again this morning and I’ve managed to map it and it works now!
Kind regards,
Ian
Welcome to the Make community!
For modules with dynamic outputs, you’ll have to run such modules and then save your scenario.
This way the module is “primed” with a sample interface of the last output, and downstream modules know what is available for mapping.
If I remember correctly, this is covered in the Make Academy somewhere.
— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!
