Export client number, message sent and routing used?

Forum|Forum|2 years ago
February 12, 2024
2 replies
1379 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.

G

god_prophetAuthor

New Participant

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

A

AnanthanJa

Employee

Hi @god_prophet ,

Please refer to the following link on parsing XML.

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

A

AnanthanJaAccepted solution

Employee

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

New Participant

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

AnanthanJa

Employee

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.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded