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

Get all rows data of a particular table

rahulkad29786
Level 3
Level 3

Hi,

I need to pull all related rows from Table_1 and capture the data in a content Block.

Then want to create any HTML email delivery and get all of the fetched row values printed from the content block.

Can anyone provide the sample code snippet or the alternate way to do it in Adobe Campaign Standard?

Thanks!

1 Accepted Solution
ramon_bisswanger
Correct answer by
Employee
Employee

You can use an Enrichment activity to fetch the data.

There choose "collection" and the number if max rows expected.

Then the data up to the specified nunber of rows will be part of additionalData and you can zse it in the Creative Designer to print it.

There is no supported way to fetch the data dynamically within the E-Mail creation at the moment as JavaScript js not supported in the editor.

View solution in original post

2 Replies
ramon_bisswanger
Correct answer by
Employee
Employee

You can use an Enrichment activity to fetch the data.

There choose "collection" and the number if max rows expected.

Then the data up to the specified nunber of rows will be part of additionalData and you can zse it in the Creative Designer to print it.

There is no supported way to fetch the data dynamically within the E-Mail creation at the moment as JavaScript js not supported in the editor.

View solution in original post

rahulkad29786
Level 3
Level 3

Thanks ramon for your valuable inputs