Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Personalised Body Content

pauls51819491
Level 1
Level 1

Hi,

We are trying to pull in personalised data into email body content.  We can make this work for any data field on the recipient table but are not able to pull in data held in another data table within Adobe Campaign.  We have carried out enrichment in the workflow but just get <%=undefined returned for the non Recipient table data field.

Any suggestions!

(email address removed, please do not post personal info as this is a public forum)

1 Accepted Solution
MarcelSzimonisz
Correct answer by
Community Advisor
Community Advisor

Hello pauls51819491​,

is it one to one or one to many relation to the other tables?

1250814_pastedImage_0.png

One to one you can include into an email by following the attribute's XPath e.g.:

1250815_pastedImage_1.png

For one to many relations you will have to use additional data but you need to know how much of records you want to retrieve

1250925_pastedImage_7.png

And it the delivery you can loop additional data for each reciepient by XPath e.g.

[targetData/workflowLog1/@id]

//infinite loop 🙂

var i = 1

for(;;){

     //do we have additional data?

     if ("workflowLog"+i in targetData){

          //do something

          i++;

     }else{ break;}

}

Marcel

View solution in original post

2 Replies
yusufm786
Level 2
Level 2

Hi,

This is difficult to resolve without seeing the instance and workflow, is the other table linked to the recipient table?

You can try adding the field in additional data as complementary information so that it is passing through the workflow and then you should be able to pull it in the email body content.

Thanks

MarcelSzimonisz
Correct answer by
Community Advisor
Community Advisor

Hello pauls51819491​,

is it one to one or one to many relation to the other tables?

1250814_pastedImage_0.png

One to one you can include into an email by following the attribute's XPath e.g.:

1250815_pastedImage_1.png

For one to many relations you will have to use additional data but you need to know how much of records you want to retrieve

1250925_pastedImage_7.png

And it the delivery you can loop additional data for each reciepient by XPath e.g.

[targetData/workflowLog1/@id]

//infinite loop 🙂

var i = 1

for(;;){

     //do we have additional data?

     if ("workflowLog"+i in targetData){

          //do something

          i++;

     }else{ break;}

}

Marcel

View solution in original post