Hi,
I am currently making a workflow where in data are pulled from an API of a website and the returned data is a multiple pages. I used repeat and iterator to get all the pages however when it comes to adding the values to a google sheet only value is available on the iterator.
Here is my current workflow.
Here are the values on the iterator.
The goal is to add all the trip ID, trip duration and other relevant information on a row.
Welcome to the Make Community!
The variable Value is an array, so you’ll need to put Value into an Iterator module.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
I have already done that. Here is the entry for the iterator.
And here is the output. There is 10 collection and under those collection there are multiple of information that I need to add in the google sheet.
That is incorrect mapping of the array. To map an entire array, turn ON the Map toggle on the top-right.
Please do the Make Academy.
For more information, see the “Mapping with arrays” link below. You should also do the Make Academy, which also covers the use of Iterators & Aggregators.
parseDate | tokens for formatDateHope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.