how can we query the transaction event payload using workflow

Avatar

Avatar
Validate 10
Level 3
surajp86368405
Level 3

Likes

21 likes

Total Posts

77 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Shape 1
Ignite 1
View profile

Avatar
Validate 10
Level 3
surajp86368405
Level 3

Likes

21 likes

Total Posts

77 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Shape 1
Ignite 1
View profile
surajp86368405
Level 3

28-11-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 5
Level 4
prasannakumarmarru
Level 4

Likes

51 likes

Total Posts

59 posts

Correct reply

17 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 10
Give Back
Boost 50
View profile

Avatar
Give Back 5
Level 4
prasannakumarmarru
Level 4

Likes

51 likes

Total Posts

59 posts

Correct reply

17 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 10
Give Back
Boost 50
View profile
prasannakumarmarru
Level 4

02-12-2019

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!

Answers (1)

Answers (1)

Avatar

Avatar
Validate 10
Level 3
surajp86368405
Level 3

Likes

21 likes

Total Posts

77 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Shape 1
Ignite 1
View profile

Avatar
Validate 10
Level 3
surajp86368405
Level 3

Likes

21 likes

Total Posts

77 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Shape 1
Ignite 1
View profile
surajp86368405
Level 3

03-12-2019

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!