how can we query the transaction event payload using workflow

[#1]

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

[#2 · 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!

[#3]

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!