Hello,We have a need to use a variable inside of a delivery which is being generated by using the .js API to query a data table containing advisors and their assigned wholesalers, then create an array of the advisors and include that in a delivery to each wholesaler. How can we include this array in...
Thanks Manoj. That is helpful and it does essentially answer my question but I think I oversimplified our use case. Is it possible to pass the variable from an API call in aseparate Javascript activity & use that variable later in the workflow inside the delivery activity?
Hello,Is it possible to include a variable defined in the Javascript code inside of a delivery activity? We wrote some custom Javascript which allows us to loop through a schema of advisors & group them together by wholesaler territory so that we can send an email report to each wholesaler with thei...
Thanks David. I was able to add a function groupConcat() but struggling to put this into practice by leveraging the function inside of the .js. Is there an easier way to iterate through & group the records together using one of the built-in jsapi functions? In the end, I just need to send a single e...
Hello, We have a need for a workflow which is capable of replicating the Group_CONCAT() function in SQL. All of the "Group By" options I've seen in Adobe Campaign are just capable of aggregating #s together but I can't find anything which can concatenate strings into a comma-separated string like th...