How to use data in custom resources in non-transactional email sending?

[fulongt37334138]

Hi, Experts, My customer want to use a custom resource to store their products data, and list some front row products in email in a fixed format. They don't wanna make the email transactional. I want to ask how to implement. Any expert know this? 

[Manoj_Kumar_ · Accepted solution]

Hello @fulongt37334138 

You can definitely create a custom resource and store the product data. But we will need some sort of reconciliation key to identifying which customer will receive which products in the emails.

With the help of this reconciliation key, you can either create a join to use enrichment to prepare the data for email.

Also, you can store data in this custom resource by either an API call or by ingesting data via flat files.

Reference link for API call: Interacting with custom resources | Adobe Campaign

[fulongt37334138]

Hi @Manoj_Kumar_ , Thanks for your reply. I have two questions:

1, Can your solution applicable to non-transactional email?

2, If every profile can receive all products, we also need to do the reconciliation? This will like full outer join in SQL.

[Manoj_Kumar_]

Hello @fulongt37334138 

Yes, It applies to non-transactional emails and you don't need reconciliation of all products.