How to make a query in rtEvent | Community
Skip to main content
supratim1034
supratim1034
Level 2
June 5, 2020
Solved

How to make a query in rtEvent

  • June 5, 2020
  • 1 reply
  • 2998 views

I have created an event in Adobe campaign standard and I can see it is creating an extension to the vanilla nms:rtEvent. Using the follow up delivery template, I am also able to access those ctx data corresponding to that event which are stored in my database. However, any kind of query activity is not allowing me to see the data.

 

Is there any possibility to make a query on that data? I tried to look at that data using the adobe campaign standard API, however, could not find it. My goal is to - read those data and based on that data make some kind of decision.

 

Please let me know if anyone has any suggestion!!

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 SatheeskannaK

Hi @supratim1034,

 

You can use query activity within ACS to fetch the data associated with rtEvent by changing the Resource to rtEvent under properties section of the activity.

If you're trying using API, i believe you should be able to use GET call through API and read the data processed by particular transactional event endpoint. Be mindful returning data might be large.

Let me know if this helps.

 

Thanks, Sathees

1 reply

SatheeskannaK
Community Advisor
SatheeskannaKCommunity AdvisorAccepted solution
Community Advisor
June 6, 2020

Hi @supratim1034,

 

You can use query activity within ACS to fetch the data associated with rtEvent by changing the Resource to rtEvent under properties section of the activity.

If you're trying using API, i believe you should be able to use GET call through API and read the data processed by particular transactional event endpoint. Be mindful returning data might be large.

Let me know if this helps.

 

Thanks, Sathees

Thanks, Sathees
SreerajS
SreerajS
August 21, 2020
SatheeskannaK - Is it possible to fetch CTX variables used in the RTevent through Query activity?
G
Gil01
September 20, 2022

Hi...did you find solution to this query?


Definitely no with one query activity, but in this link the suggest use a data extraction file to expose all the attributes in CTX. https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/accessing-event-variables-in-acs-transactional-messaging/td-p/370226

    Terms & ConditionsAccessibility statement

    Loading footer...