how can we query the transaction event payload using workflow

[sspatra25]

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

[prasannakumarmarru · Accepted solution]

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!

[sspatra25]

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!