From which table SMS content sent to a particular profile to be viewed ? | Adobe Higher Education
Skip to main content
N
NeelamBakre
Level 3
June 6, 2020
Resuelto

From which table SMS content sent to a particular profile to be viewed ?

  • June 6, 2020
  • 1 respuesta
  • 2959 visualizaciones

I have a mobile number of particular profile & want to check what SMS contents has been sent to it.

From which table I can view its content ?

    Este tema ha sido cerrado para respuestas.
    Mejor respuesta de Milan_Vucetic

    Hi @neelambakre ,

    SMS content is stored in [content/sms/source] of nms:delivery schema. Bear in mind it is not reflected as physically separated column as this is part of XML field (physically MDATA).

    If you had some personalization inside of the delivery you won't be able to see personalization values in this field unless you have created mirror link.

     

    Regards,

    Milan

    1 respuesta

    Milan_Vucetic
    Milan_VuceticRespuesta
    Level 9
    June 7, 2020

    Hi @neelambakre ,

    SMS content is stored in [content/sms/source] of nms:delivery schema. Bear in mind it is not reflected as physically separated column as this is part of XML field (physically MDATA).

    If you had some personalization inside of the delivery you won't be able to see personalization values in this field unless you have created mirror link.

     

    Regards,

    Milan

      S
      shaohong
      Level 2
      November 24, 2022

      If we take one step back and do not expect AC to save the personalized SMS content in a ready made table, is there any possibility to extract the personalized SMS content right before/after it is sent?
      In our case, we are using SMPP protocol and with verbose debug log turned on, we can see those SMPP protocol messages from mtachild.log, but that's a bit too much hacking to "reverse engineer" and find out what SMS content AC has sent out.

      Regards,
      Shaohong

      C
      Adobe Employee
      costa_n11Adobe Employee
      Adobe Employee
      December 22, 2022

      Thanks @milan_vucetic we'll give approach that a try, I hope there are programtic ways to get the mirror page url for the given (deliveryID, messageID) combo and then we can fetch the mirror page content from there.

      Shaohong


      There would be a way to inject the Personalisation into the SMS content source using JavaScript function however it'd be very cumbersome because you would have to store ALL the target data to make it happen AND you don't control what fields would be in the Target Data at all, so it's although technically possible, not viable solution for the long run...

      Outside the technicality, what are the business use cases where you would need to have the exact content of the SMS message sent? 

      Not sure using the mirror page is also viable either but worth a try

       

      Términos y condicionesAccessibility statement

      Loading footer...