Table/Schema for delivery content

[#1]

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

[#2 · Accepted solution]

Hi there,

Hope the below answers your question.

Thanks.

[#3]

Hi,

You can find the content in the nms:delivery table, the attribute name is XML memo (data) -- Sql field is mdata.

Thanks,

Sourav

[#4]

Hi,

Try similar to this.

Thanks.

[#5]

Yes, this is answer to my question.

Thanks.

[#6]

how to extract delivery/content/sms/source field from nms:broadLogRcp table?

I tried below code but the content not coming.

Thanks,

Tejashri

[#7]

!

Hi,

somasundaramhaldurai​

How to define alias in below format?

Thanks,

Tejashri

[#8]

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

[#9]

You may try the below:

Thanks.

[#10]

HI,

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

When added highlighted expression in javacript code

getting below error:

Regards,

Tejashri

[#11]

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

[#12]

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.

[#13]

HI Sourav,

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

Regards,

Tejashri

[#14]

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.