Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Storing SMPP Message id details within ACM Delivery Logs

Avatar

Level 5

Hi team,

Can we store the Message ID generated from the SMS Vendor within ACM Delivery receipt/Delivery Logs. Currently we are using SMPP Protocol to send the SMS.from ACM.  We are getting the DLR from the SMS Vendor in following format:-

2019-03-25|14:06:31|SRC:9180012386035|DST:VK-XYZUVW|SMS:id:29892980123001E3  sub:001 dlvrd:001 submit date:1903251405 done date:1903251406 stat:DELIVRD err:000

But within Delivery Logs we only get the delivery status message as follows:-

SR Generic DELIVRD 000|#MESSAGE#

Can the Delivery Status Message store the message id

with regards,

Richa Chaubey

1 Accepted Solution

Avatar

Correct answer by
Employee

Hello Richa,

This message ID from the provider is stored in the table nms:providerMsgId.

1740058_pastedImage_0.png

The part before the _1530925964 is the provider message ID.

Regards,

Adhiyan

View solution in original post

2 Replies

Avatar

Correct answer by
Employee

Hello Richa,

This message ID from the provider is stored in the table nms:providerMsgId.

1740058_pastedImage_0.png

The part before the _1530925964 is the provider message ID.

Regards,

Adhiyan

Avatar

Level 5

Hi Adhiyan,

Thanks for the update, In case of Hybrid Implementation nms:providerMsgId schema is not populated in marketing instance, can this data be synced to on-premise Marketing instance from mid-sourcing.

with regards,

Richa Chaubey