Parse data in Body for key/value pair in Inbound Email Actions

athavichith
Kilo Sage

Hi,

 

I am creating a inbound action that will generate a incident. I want to be able to parse the data in the email body text for key/value pairs to set:

 

  • incident caller
  • incident phone
  • incident email
  • incident category

 

Here is an example of my email template that vendor is sending:

 

Dear IT Service Desk:

The following case was closed by Test Center for your account.:

Caller Information:
Name: Jeff Test
Phone: 1 (111) 111 - 1111
Email: needemail@email.com

Test Center Information:
Ticket Number: 01362697
Case Date: 1/10/2025
Issue Category: Administration
Issue Category Detail: Data Sources

Brief Description:

Advisor Comment
Jeff Test: test case for email integration
Jeff Test test comment
Jeff Test testing testing testing
Jeff Test Sending case closed notification

Thank you

C1TM3CKNC23SBLEIBL

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@athavichith 

this should be possible using the syntax

var email= email.body.email;

Parsing Inbound Email 

Inbound email action parsing to incident table 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

@athavichith 

this should be possible using the syntax

var email= email.body.email;

Parsing Inbound Email 

Inbound email action parsing to incident table 

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Ok....I was able to parse the data for name/value pairs with your solution. Thanks for the help!