Export client number, message sent and routing used? | Community
Skip to main content
G
god_prophet
Level 6
February 12, 2024
Solved

Export client number, message sent and routing used?

  • February 12, 2024
  • 2 replies
  • 1382 views

Hi,

Was wondering if it is possible to export the numbers of the clients to which the a delivery was sent?  

I cannot find the field for the SMS content on the Delivery table. 

I need: phone number, content of the actuall SMS sent, and routing used.

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 AnanthanJa

Hi @god_prophet ,

 

The SMS content of the delivery will be saved in the xml field in the delivery. However, the SMS content will not be personalized.

 

Personalized SMS content is not saved in Adobe Campaign. 

 

2 replies

A
Adobe Employee
AnanthanJaAdobe EmployeeAccepted solution
Adobe Employee
February 13, 2024

Hi @god_prophet ,

 

The SMS content of the delivery will be saved in the xml field in the delivery. However, the SMS content will not be personalized.

 

Personalized SMS content is not saved in Adobe Campaign. 

 

    G
    god_prophetAuthor
    Level 6
    February 13, 2024

    Hi @ananthanja , how to access the XML field?

    In the delivery's schema, I only see this field: XML memo, that is empty for all deliveries.

     

    A
    Adobe Employee
    AnanthanJaAdobe Employee
    Adobe Employee
    February 13, 2024

    Hi @god_prophet ,

     

    You can use the ToString method on the XML field to select the data.

     

    By default the first 1036 characters are returned. You can use Substring functions to get the XML data based on the length of the XML.

     

    This will give the entire delivery XML from which the SMS content can be derived.

     

     

      G
      god_prophetAuthor
      Level 6
      February 13, 2024

      Hi @parthasarathy, hope you're doing great. Any input on how to achieve this?

      A
      Adobe Employee
      AnanthanJaAdobe Employee
      Adobe Employee
      February 13, 2024

      Hi @god_prophet ,

       

      Please refer to the following link on parsing XML.

       

      https://experienceleague.adobe.com/developer/campaign-api/api/p-6.html

        Terms & ConditionsAccessibility statement

        Loading footer...