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

Personalised Body Content

Avatar

Avatar
Boost 1
Level 1
pauls51819491
Level 1

Like

1 like

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
pauls51819491
Level 1

Like

1 like

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
pauls51819491
Level 1

13-06-2017

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)

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

225 posts

Correct Reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

102 likes

Total Posts

225 posts

Correct Reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile
MarcelSzimonisz
MVP

17-07-2017

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

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 2
yusufm786
Level 2

Likes

4 likes

Total Posts

12 posts

Correct Reply

4 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile

Avatar
Validate 1
Level 2
yusufm786
Level 2

Likes

4 likes

Total Posts

12 posts

Correct Reply

4 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile
yusufm786
Level 2

05-07-2017

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