Expand my Community achievements bar.

SOLVED

Get all rows data of a particular table

Avatar

Level 4

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

Avatar

Correct answer by
Employee Advisor

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

Avatar

Correct answer by
Employee Advisor

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.

Avatar

Level 4

Thanks ramon for your valuable inputs