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.
Transactions Tid Subscriber Email first name 1 firstname.lastname@example.org Alpha 2 email@example.com Beta Favourtes Favourtesid Transaction id Item Name 1 1 Apple 2 1 Orange 3 1 Grape 4 2 Apple 5 2 Grape