How Can I take the Event Context (ctx) data from an Event in Query to Update Profile Table ? | Community
Skip to main content
Younes_SABIR
Younes_SABIR
October 22, 2020
Solved

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

  • October 22, 2020
  • 1 reply
  • 1861 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by bisswang

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
  •  

 

 

1 reply

B
Adobe Employee
bisswangAdobe EmployeeAccepted solution
Adobe Employee
October 25, 2020

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
  •  

 

 

    T
    treddy4
    June 23, 2022

    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

    Terms & ConditionsAccessibility statement

    Loading footer...