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
BedrockMission!

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 ?

Younes_SABIR
Level 1
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
ramon_bisswanger
Correct answer by
Employee
Employee

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

1 Reply
ramon_bisswanger
Correct answer by
Employee
Employee

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