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 inside the delivery? Since it is dynamic & a different array of advisors for each wholesaler (the delivery recipients), I don't believe the built-in delivery variables can accommodate. We attempted to use Personalization Blocks but it appears those aren't capable running queries & returning the results as variables. Working JS snippet attached... now we are just trying to figure out how to carry the advisorArray into the delivery. Any suggestions are appreciated.
Hi Austin - it sounds from what you are trying to do you just need format the output of the array (Advisors) into the content of the Email? If that is the case then I would just enrich a text field onto the schema and add some HTML text into it based on the array content for each target. So basically the variable on the schema contains your output HTML block.