Table/Schema for delivery content | Community
Skip to main content
tejashriw155148
Level 4
Oct 22, 2019 1:45 PM UTC
Solved

Table/Schema for delivery content

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.
somasundaram_h
somasundaram_hAccepted solution
New Participant
Oct 24, 2019 7:51 AM UTC

Hi there,

Hope the below answers your question.

Thanks.

13 replies

tejashriw155148
Level 4
Nov 4, 2019 10:51 AM UTC

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

I tried below code but the content not coming.

Thanks,

Tejashri

Translate
somasundaram_h
New Participant
Oct 31, 2019 5:40 AM UTC

Hi,

Try similar to this.

Thanks.

Translate
tejashriw155148
Level 4
Oct 30, 2019 11:03 AM UTC

!

Hi,

somasundaramhaldurai​

How to define alias in below format?

Thanks,

Tejashri

Translate
tejashriw155148
Level 4
Oct 25, 2019 2:27 PM UTC

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

Translate
somasundaram_h
New Participant
Oct 25, 2019 6:25 AM UTC

You may try the below:

Thanks.

Translate
tejashriw155148
Level 4
Oct 24, 2019 1:44 PM UTC

HI,

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

When added highlighted expression in javacript code

getting below error:

Regards,

Tejashri

Translate
tejashriw155148
Level 4
Oct 24, 2019 12:03 PM UTC

Yes, this is answer to my question.

Thanks.

Translate
somasundaram_h
somasundaram_hAccepted solution
New Participant
Oct 24, 2019 7:51 AM UTC

Hi there,

Hope the below answers your question.

Thanks.

Translate
tejashriw155148
Level 4
Oct 23, 2019 12:09 PM UTC

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

Translate
Jyoti_Yadav
Level 8
Oct 23, 2019 7:08 AM UTC

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.

Translate