Hello there I’m having an issues with an API request to my google sheet.
The problem itself is I want the Top 100 songs of the billboard but when I do it only get 1 song at the time in my google sheet.
The iterate module is not working like it is supposed… could someone here help me ?
Hi Kevin, you need to map the bundles from iterator to the fields of google sheets. In the picture you have mapped the data from http module into Google sheets
So does that means I have to select total bundles in each colums?
I don’t see no output in the iterator, as I do usually
Usually you would see another variable called value along with total number of bundles and bunder order as the iterator output, you need to map the data from the value variable. My guess why you are not seeing it is because you haven’t ran the scenario till the iterator module yet. You can try running it once if you haven’t already then you should be able to see the results and map them
can you share the json output bundle from the http module it will be easier to diagnose. In the picture you have shred it shows multiple collections under one bundle it needs to be multiple bundles in order to map with the fields of google sheets
the difference is that usually from the http request you get an array that you can pass to the iterator, but with this request you only get collection, no array.
you can use aggregator on the content collection and use iterator to extract the bundles
I’ve try everything but it still not working. I see I can download it but I want to automated, the process… But thanks for the help
Let me know if you want to hop on a quick zoom call where you can share your screen and get this solved
Feel free to reply or book a call.
I understand you’re having trouble retrieving all 100 songs from the Billboard chart into your Google Sheet, with only one song appearing at a time. This could be due to an issue with either the API request or how the iterate module is processing the data.
Feel free to share more details or screenshots, and I’ll be happy to help you resolve this. For more information about my experience, feel free to check my profile here:
[https://www.upwork.com/freelancers/farhana401]. If you’d like to discuss the project further, you can book a 30-minute call with me here: [Calendly - Farhan Ahmed].
