Table/Schema for delivery content | Community
Skip to main content
tejashriw155148
Level 4
October 22, 2019
Solved

Table/Schema for delivery content

  • October 22, 2019
  • 13 replies
  • 16322 views

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

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 somasundaram_h

Hi there,

Hope the below answers your question.

Thanks.

13 replies

Sourav_Sadhu
Level 2
October 22, 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

asktam1410
Level 3
October 22, 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.

tejashriw155148
Level 4
October 23, 2019

HI Sourav,

I checked XML memo(data) field but it is blank. No content inside the field.

Regards,

Tejashri

Jyoti_Yadav
Level 8
October 23, 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
Level 4
October 23, 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

somasundaram_h
Community Advisor
somasundaram_hCommunity AdvisorAccepted solution
Community Advisor
October 24, 2019

Hi there,

Hope the below answers your question.

Thanks.

tejashriw155148
Level 4
October 24, 2019

Yes, this is answer to my question.

Thanks.

tejashriw155148
Level 4
October 24, 2019

HI,

How to parse expression delivery/content/sms/@source in javascript?

When added highlighted expression in javacript code

getting below error:

Regards,

Tejashri

somasundaram_h
Community Advisor
Community Advisor
October 25, 2019

You may try the below:

Thanks.

tejashriw155148
Level 4
October 25, 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