Expand my Community achievements bar.

SOLVED

Personalised Body Content

Avatar

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

Avatar

Correct answer by
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

Avatar

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

Avatar

Correct answer by
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