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.
Solved! Go to Solution.
Views
Replies
Total Likes
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.
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.
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.
Views
Replies
Total Likes
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 got it. But how to parse XML in Campaign to get only the message of the delivery?
Views
Replies
Total Likes
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.
Regards,
Pravallika.
Views
Replies
Total Likes
Views
Replies
Total Likes
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.
Regards,
Pravallika.
Views
Replies
Total Likes
Hi @ParthaSarathy, hope you're doing great. Any input on how to achieve this?
Views
Replies
Total Likes
Hi @ogonzalesdiaz ,
Please refer to the following link on parsing XML.
https://experienceleague.adobe.com/developer/campaign-api/api/p-6.html
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies