Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

Avatar

Level 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

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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
  •  

 

 

View solution in original post

2 Replies

Avatar

Correct answer by
Employee Advisor

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
  •  

 

 

Avatar

Level 1

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