where sms messsage is stored in AEP dataset

[amit360degreee]

test

[nnakirikanti]

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]

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

[DavidKangni]

_experience > customerJourneyManagement > entities > channelDetails > template

[nnakirikanti · Accepted solution]

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