Expand my Community achievements bar.

SOLVED

Export client number, message sent and routing used?

Avatar

Level 5

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.

1 Accepted Solution

Avatar

Correct answer by
Employee

Hi @ogonzalesdiaz ,

 

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. 

 

View solution in original post

9 Replies

Avatar

Correct answer by
Employee

Hi @ogonzalesdiaz ,

 

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. 

 

Avatar

Level 5

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.

ogonzalesdiaz_0-1707834427167.png

 

Avatar

Employee

Hi @ogonzalesdiaz ,

 

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.

 

AnanthanJa_0-1707837452890.png

 

Avatar

Level 5

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

Avatar

Community Advisor

Hi @ogonzalesdiaz ,

 

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

LakshmiPravallika_0-1707888842561.png

 

Regards,

Pravallika.

 

Avatar

Level 5

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

Do you know why?

ogonzalesdiaz_0-1707921760175.png

 

Avatar

Community Advisor

Hi @ogonzalesdiaz ,

 

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.

LakshmiPravallika_0-1707923194233.png

 

Regards,

Pravallika.

 

 

Avatar

Level 5

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