how can we query the transaction event payload using workflow | Community
Skip to main content
Level 4
Nov 28, 2019 2:04 PM UTC
Solved

how can we query the transaction event payload using workflow

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
prasannakumarmarru
prasannakumarmarruAccepted solution
Level 4
Dec 3, 2019 6:13 AM UTC

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

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

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

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

2 replies

Level 4
Dec 3, 2019 9:46 PM UTC

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!

Translate
prasannakumarmarru
prasannakumarmarruAccepted solution
Level 4
Dec 3, 2019 6:13 AM UTC

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

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

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

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

Translate