question Remove Watermark from email body of incoming emails in Developer forum

Remove Watermark from email body of incoming emails

Developer3 — Fri, 18 Sep 2020 12:08:36 GMT

We get emails from third party vendor servicenow instance to my client instance related to vendor incident and service requests. As soon as the email hits the client instance, a call record has to be created. I configured an inbound email action for this but the incoming vendor email has watermark because of this my inbound action is not triggered and the email is getting ignored. Could anyone please let me know the script to remove watermark from email body.

I referred this post: https://community.servicenow.com/community?id=community_question&sys_id=bb064b61db1cdbc01dcaf3231f9619a6 but I am not sure on the code of how to remove the watermark from email body.

So any scripting help on this is really appreciated.

Re: Remove Watermark from email body of incoming emails

MrMuhammad — Fri, 18 Sep 2020 12:14:09 GMT

Have you tried below?

Omit an email notification watermark | Servicenow Docs

Re: Remove Watermark from email body of incoming emails

mr18 — Fri, 18 Sep 2020 12:16:06 GMT

Set the 'Omit Watermark field to true in the notification

Re: Remove Watermark from email body of incoming emails

Developer3 — Fri, 18 Sep 2020 12:17:35 GMT

Hi Both,

"Omit watermark" is for outgoing notifications. I am asking about inbound emails

Re: Remove Watermark from email body of incoming emails

mr18 — Fri, 18 Sep 2020 12:21:25 GMT

It might help you

https://community.servicenow.com/community?id=community_question&sys_id=bb064b61db1cdbc01dcaf3231f9619a6

Re: Remove Watermark from email body of incoming emails

Megha Padale — Fri, 18 Sep 2020 12:23:29 GMT

Hi,

Check below links

https://community.servicenow.com/community?id=community_question&sys_id=869e4b92dbed23002737e15b8a96192b

https://community.servicenow.com/community?id=community_blog&sys_id=bc7c22e1dbd0dbc01dcaf3231f961996

If my answer helped you in any way, mark answer as helpful and correct.

Thanks and Regards,

Megha

Re: Remove Watermark from email body of incoming emails

Developer3 — Fri, 18 Sep 2020 12:28:31 GMT

This is the same link i mentioned in my question.

Re: Remove Watermark from email body of incoming emails

Jaspal Singh — Fri, 18 Sep 2020 12:59:47 GMT

Hi,

You can try below (untested) a business rule that runs before insert/update on sys_email table.

When to Run: Required conditions or recipient list to make it specific. Else it will run for all mail that are received.

Suppose, Subject contains ABC

Script:

(function executeRule(current, previous /*null when async*/ ) {

    var getwatermark = new GlideRecord('sys_email');
    getwatermark.query();
    if (getwatermark.next()) {
        var bodyhastext = getwatermark.body;
        bodyhastext = bodyhastext.replace(/MSG0042550/g, '');//Suppose my watermark is of form :  //Ref:MSG0042550 so it replaces it with empty
        getwatermark.body = bodyhastext;
        getwatermark.update();

    }

    //Ref:MSG0042550

})(current, previous);

You can use your own logic as per your watermark text. In case you can also use split or substring methods for removing watermark,

Note: This has high impact on the performance of system

Re: Remove Watermark from email body of incoming emails

Developer3 — Fri, 18 Sep 2020 13:05:02 GMT

But we cannot run gr.update() on "before" business rule correct?

Re: Remove Watermark from email body of incoming emails

Jaspal Singh — Fri, 18 Sep 2020 13:34:49 GMT

My Bad! It is not required. It should work without .update() as well as its before.

Only reason to avoid its usage it make it run twice & avoid unnecessary load which does not have any impact apart from performance but yes it is recommended not to use. Just try it without .update() once for a check.