Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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

PavanK960672992
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 @PavanK960672992 

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 😀