I have a dataset of selling items but in google sheets it only post the 1 item, and does not continue to 2-3-4 etc…
I’ve tried all sort of things but can’t get I to work…
@Thomas_Koch_Nielsen , Can you post Iterator parameters and one of its’ outputs ?
@Thomas_Koch_Nielsen, Show iterator input parameters also please. I think you put [Data] collection as an input and not the [best_sellers] array.
The easiest way to check for the problem would be if you’d share the blueprint @Thomas_Koch_Nielsen
Thanks! But I recommend you change the API key now, as the blueprint still includes the API key.
1 Like
@Thomas_Koch_Nielsen, You basically had to choose the correct array in the iterator. Here’s the example blueprint (change api key) :
blueprint (6).json (23.0 KB)
@Thomas_Koch_Nielsen if i’m not mistaken, the whole scenario is built wrong. What you are basically doing is:
- You get the bestsellers
- You get the details for the first bestseller
- You get the image for the first bestseller
- You aggregate the bestsellers (which does nothing as they stay the same)
- You query chatgpt for the first bestseller
- You’re trying to iterate over it
What I guess you want to do is to get all bestsellers and then get the details and image for each of them, then query chatgpt for each of them. And then add a new row with all of those details for each of them. If that is the case, you only need one Iterator which repeats all the actions of getting the details, image, querying chatgpt and adding it to google sheets for each of the 50 products.
If that is the case, here is the updated scenario (removed all API keys):
blueprint (4).json (47.1 KB)
Also, right now you only add data to the chatgpt query and the google sheet that you get from the initial “Get Bestsellers” Request. So you can remove the get image module (as the image link is enough, the get image module basically “downloads” the whole image to the scenario) and you can also remove the get details module.
Hope this helps 
it works… THANX…
one final question… how do I make it, so that it only finds 10 or 20 products
Happy to hear that it works @Thomas_Koch_Nielsen!
According to the Documentation, there doesn’t seem to be a way to only request a limited number of results.
Therefore, you’d have to filter out the results you want to work with by usingIt the slice function in the Iterator like this: “{{slice(1.data.data.best_sellers; 0; 30)}}”.
What this does is it starts at index 0 and gets all results up to index (aka product) 30.
Here is the new scenario with that added:
blueprint (5).json (47.1 KB)
If all of that works, feel free to mark the message as Answer so that others also find it quickly 
1 Like