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

[Younes_SABIR]

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

[ramon_bisswanger · 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
•  

[treddy4]

Hi Ramon,

From the above solution provided on the 2nd step.

•  Use extract file activity as here you can process the ctx fields: Do we need to substring the ctx attributes in the ctx object or is there any alternative available?

CTX object as below:

{"ctx":{"token":"IYsaVbUqok9","Id":100146491,"pushBody":"TR _This is the content of my push notification","pushSubject":"Push Notification1"}}

Now i want to extract the each field in the file extract.

Best Regards,

TR