Building a delivery template contents from a table/static list | Community
Skip to main content
RajeshBhat
Level 3
November 22, 2024
Question

Building a delivery template contents from a table/static list

  • November 22, 2024
  • 1 reply
  • 466 views

Looking to build a delivery template from a static list or a schema within ACC which holds a master data. The values in this list/schema will get populated into a table within the email body. Once the full content of the email template is ready then based on the flag values in targetData the rows of the email table will be shown/hidden. I don't want to link the master data with targetData upfront as there is no mapping (common) field across two data sets and also the cross join will significantly increase the record count.

Any suggestions/guidance in achieving this will be appreciated!

1 reply

Manoj_Kumar
Community Advisor
Community Advisor
March 5, 2025

Hello @rajeshbhat  My suggest would be to create a  workflow to achieve this. If you will try to add queryDef within in the delivery template, it won't work. Any script/code added in delivery template should be executed within 5 seconds otherwise it will timeout.

Manoj     Find me on LinkedIn