I am trying to send email and populate data extension using Triggered send REST API of exact target in salesforce to populate values in Data Extension using REST API.
I was able to send an batch sent email in salesforce using REST API. I was able to populate attributes in data extension and printed in mail too.
But the challenge is Each subscriber will receive a mail with his favourites data.
For example "X" likes Apple,Grape,Banana. "y" likes Grape,Mango.
I have 2 data extensions Transaction Extension and Favourites Extension. currently with no relation
In My mails X should receive a mail with he likes 1.Apple 2. Grape 3. Banana
What i want to know is How should I send these values as a JSON Payload in MessageSend. How can we relate these two extensions. what should be the ampscript in the mail.
Please Help someone.
Tid Subscriber Email first name
1 [email protected] Alpha
2 [email protected] Beta
Favourtesid Transaction id Item Name
1 1 Apple
2 1 Orange
3 1 Grape
4 2 Apple
5 2 Grape