This scenario starts with a webhook delivering an array of varying sizes (product line items), I then use the iterator to loop a spreadsheet look-up of URLs (COA PDFs), but it completes with 2 operations.
I am having a hard time getting the text aggregator to loop all these URLs into 1 variable separated by a coma. I have looked up all the videos, the documentation, and several other community posts on Iterators, Array Aggregators, JSON Parsing, and the like, but I am stumped.
Hi. Have tried it using the text aggregator like this? the results is the iterator separed by comma:
Note: the json parse in example is only to simulate your iterator
re
Thanks, Helio!
Wemakefuture
If you have questions reach out 
4 Likes
Hey thanks for the reply! I gave this a shot and it has the same effect as the last attempt, I still have the 2 operations, that I need to be combined into one string, so each operation has a URL output. See Screenshot results of the suggested Text Agg.
I re worked my scenario and realized my problem was handling it as an array and using your help I structured my original query to sheets so that it returned bundles not operations. I then Text aggregated those results and was finally able to get my URL the way I needed. Thank you!
2 Likes
I have the same problem. How did you rework the scenario?
What i did was i was able to get the URLs I needed by Querying my Google sheet for the data. I basically amend the query using the same method but with a different delimiter, for each “Or” statement.
It returns “Bundles”. Use a text Aggregator to make them coma delimited. i then feed this coma delimited list of URLs into pdfco to merge all my PDFs.
3 Likes
Hi @Lloyd_Johnson 
,
Congratulations on solving this puzzle! 
Thanks a lot for remembering to share your insights with us and marking them as a solution. This way our community stays tidy, neat, and easy to look for solutions. 
Keep up the great work!
2 Likes