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

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

  • June 6, 2020
  • 1 reply
  • 2964 views

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 ?

    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 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 reply

    Milan_Vucetic
    Milan_VuceticAccepted solution
    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

      Milan_Vucetic
      Milan_Vucetic
      Level 9
      December 28, 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


      Hi @shaohong 

      enable Force creation of mirror page on delivery level and fetch the link via JS:
      mirrorPage = nms.delivery.GetMirrorURL(deliveryId,broadlogId.toXMLString());

       

      Cheers,
      Milan

        Terms & ConditionsAccessibility statement

        Loading footer...