Hi,
Please let me know the text content which sent to customer through SMS/Email delivery are stored in which table or schema?
Regards,
Tejashri Waje
somasundaramhal
somasundaramhal
24-10-2019
Hi there,
Hope the below answers your question.
Thanks.
Sourav_Sadhu
Sourav_Sadhu
22-10-2019
Hi,
You can find the content in the nms:delivery table, the attribute name is XML memo (data) -- Sql field is mdata.
Thanks,
Sourav
somasundaramhal
somasundaramhal
30-10-2019
Hi,
Try similar to this.
Thanks.
tejashriw155148
tejashriw155148
24-10-2019
Yes, this is answer to my question.
Thanks.
tejashriw155148
tejashriw155148
04-11-2019
how to extract delivery/content/sms/source field from nms:broadLogRcp table?
I tried below code but the content not coming.
Thanks,
Tejashri
tejashriw155148
tejashriw155148
30-10-2019
tejashriw155148
tejashriw155148
25-10-2019
Tried above code but its not giving value of source.
Hence changed code to <node expr="[content/sms/@source"] alias="@content"/> and its throwing below error:
How can retrieve source data.
Regards,
Tejashri
somasundaramhal
somasundaramhal
24-10-2019
You may try the below:
Thanks.
tejashriw155148
tejashriw155148
24-10-2019
HI,
How to parse expression delivery/content/sms/@source in javascript?
When added highlighted expression in javacript code
getting below error:
Regards,
Tejashri
tejashriw155148
tejashriw155148
23-10-2019
Thanks Jyoti for the info.
I'm not familiar with java script code, so could you please let me now how to use above xml format in javascript?
Regards,
Tejashri
Jyoti_Y
MVP
Jyoti_Y
MVP
23-10-2019
Hi,
You can check delivery text content using below xml format in Javascript:
var emailText= delivery.content.text.source.toString();
var emailHTML= delivery.content.html.source.toString();
It will give you XML structure of your email. You can fetch whatever data you want to fetch, like you want to get URL of your HTML you can use:
var url= delivery.content.text.urlConfig.url ;
Thanks.
tejashriw155148
tejashriw155148
22-10-2019
HI Sourav,
I checked XML memo(data) field but it is blank. No content inside the field.
Regards,
Tejashri
asktam1410
asktam1410
22-10-2019
Anything related to the delivery will be stored in nms:delivery schema. If you used AEM content then you need to write QueryDef to read actual content Id that was synchronized with the delivery and then find it in AEM.