How Can I take the Event Context (ctx) data from an Event in Query to Update Profile Table ?

[#1]

Hi community,

I need to take some ctx data from an event to update the profile table ? When I choose my event as a Ressource in the Query I can preview the data, I can make show data from the event like first name etc. But it is not data I can see in the transition or use to update.

Thank you in advance.

Best regards,

YS

[#2 · Accepted solution]

You can't use it in enrichments, etc.

Following trick might do it:

•  Query for the data
•  Use extract file activity as here you can process the ctx fields
• add a load file immediately after which is reading the data
• then you have the data in the workflow and can use it in update data activity
•