Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

fetching data from email body in server side script

Deepika54
Tera Contributor

Deepika54_0-1675164477691.png

Hello experts, I have a following email body. I want to fetch the 'Critical' value and store it in some variable in inbound action script . I also have the regex expression    Alert Level: (.*).

Can any1 tell me how to retrieve the value 'critical' and store it in a variable.

2 ACCEPTED SOLUTIONS

Pavankumar_1
Mega Patron

Hi @Deepika54 ,

you can get value like this

 

 

var alert=email.body.alert_level; //you can get value of alert value like this 

 

 

or try below it gives the Critical value

 

var bodyis=email.body_text; //gives you complete body of email
var alerttext=bodyis.split('Alert Level:')[1]; //This gives you text after Alert Level
var gettext=alerttext.split('HostName:')[0];//this gives the text before HostName

 

If it helps please click Accept as Solution/hit the Thumb Icon.
ServiceNow Community MVP 2024.
Thanks,
Pavankumar

View solution in original post

Hi @Deepika54 ,

yes that will work.

If it helps please click Accept as Solution/hit the Thumb Icon.
ServiceNow Community MVP 2024.
Thanks,
Pavankumar

View solution in original post

12 REPLIES 12

it is working. Thank you so muchhh pavan.

But i am getting a space before critical. Can u plz tell me how to remove that previous space.

The output i am getting is:

 Critical.

 

Hi @Deepika54 ,

add below line to remove.

var finalText=gettext.replace('.', '');

 

If it helps please click Accept as Solution/hit the Thumb Icon.
ServiceNow Community MVP 2024.
Thanks,
Pavankumar

hi @Pavankumar_1 

similarly if i want to get the device ip, will these 2 lines work?

var a = bodyis.split('Device IP:')[1]; 
var b = a.split('Model:')[0];// i will print b

Hi @Deepika54 ,

yes that will work.

If it helps please click Accept as Solution/hit the Thumb Icon.
ServiceNow Community MVP 2024.
Thanks,
Pavankumar

i used trim function and it is working. Thank u pavan 😀