test | Community
Skip to main content
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 nnakirikanti

@amit360degreee Here is the sample query to work with.

 

SELECT DISTINCT /* template contains AE._experience.customerJourneyManagement.entities.channelDetails.template, /* template contains raw message stored as json */ AE._experience.customerJourneyManagement.entities.journey.* /* All journey specific details */ from ajo_entity_dataset AE WHERE AE._experience.customerJourneyManagement.entities.channelDetails.channel._id = 'https://ns.adobe.com/xdm/channels/sms' AND AE._experience.customerJourneyManagement.entities.journey.journeyActionID = '<< Change with Journey SMS action ID>>' /*<<Journey SMS action ID>>*/ AND AE._experience.customerJourneyManagement.entities.journey.journeyName = '<<Journey Name>>' /*<<Journey SMS action ID>>*/ AND AE._experience.customerJourneyManagement.entities.journey.journeyNodeType = 'unitaryMessageAction'

 

~cheers,

NN.

1 reply

nnakirikanti
Community Advisor
nnakirikantiCommunity Advisor
Community Advisor
January 23, 2025

Hello @amit360degreee : Raw messages are stored in AJO Entity Dataset for SMS as well and delivery related information will be injected to AJO Message Feedback Event Dataset.

 

Let me know if you need more details and please mark this thread accordingly.

 

~cheers,

NN

amit360degreee
amit360degreeeAuthor
January 23, 2025

Hi Which particular Attribute I can look to find the exact content send via SMS?

 

DavidKangni
Community Advisor
DavidKangniCommunity Advisor
Community Advisor
January 23, 2025

_experience > customerJourneyManagement > entities > channelDetails > template

David Kangni
Terms & ConditionsAccessibility statement

Loading footer...