Export client number, message sent and routing used?

[god_prophet]

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.

[AnanthanJa · Accepted solution]

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. 

[god_prophet]

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.

[AnanthanJa]

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.

[god_prophet]

@AnanthanJa got it. But how to parse XML in Campaign to get only the message of the delivery?

[LakshmiPravallika]

Hi @god_prophet ,

Please check from nms:broadlogRcp , the field [delivery/content/sms/source], where the SMS message will be stored without personalization in this field.

Regards,

Pravallika.

[god_prophet]

Hi @LakshmiPravallika  for some reason I don't have that field: SMS (content).

Do you know why?

[LakshmiPravallika]

Hi @god_prophet ,

Yes, it won't be directly available in broadLogRcp, you have to go to the Delivery Link expand it and then you can find the "SMS content (sms) " there.

Regards,

Pravallika.

[god_prophet]

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

[AnanthanJa]

Hi @god_prophet ,

Please refer to the following link on parsing XML.

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