test

Question

test

nnakirikanti · Accepted Answer

@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.

nnakirikanti · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO