Get all rows data of a particular table

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by bisswang

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.

Accepted solution

Adobe 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.

Level 4

Thanks ramon for your valuable inputs

Sign up