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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
SOLVED

how can we query the transaction event payload using workflow

Avatar

Level 5

Hi Team

which table should we query to get the transactional event payload. i am trying to get all the payload we received for transactional messages.

Thank you.

Regards,

Suraj

1 Accepted Solution

Avatar

Correct answer by
Level 4

You should select the actual event in the query activity> poperties (event whioch you created)

1860414_pastedImage_0.png

Do some filtering bvased opn the criteria you need- I did it for non empty email addresses-

1860415_pastedImage_1.png

When preview it on query activity itselfand configure the preview list- You will see somethign like this-

1860881_pastedImage_2.png

You cannot add this directly into your additional data section but I think you can export it into a file. Thanks!

2 Replies

Avatar

Correct answer by
Level 4

You should select the actual event in the query activity> poperties (event whioch you created)

1860414_pastedImage_0.png

Do some filtering bvased opn the criteria you need- I did it for non empty email addresses-

1860415_pastedImage_1.png

When preview it on query activity itselfand configure the preview list- You will see somethign like this-

1860881_pastedImage_2.png

You cannot add this directly into your additional data section but I think you can export it into a file. Thanks!

Avatar

Level 5

That was tricky. It would have been good if we could access these in additional data. but, it works for with file for now. is there a plan for any enhancement here if you know ?

Thank you for your reply!