Parsing email body in an inbound email action

Maheshwar1
Tera Contributor

I need to parse data from email body and push it to one of the reporting table.

Receiving an automated email everyday containing details against Server Backup. The report is being received as part of the email body and I need to parse the data and post it to the right table.

The email body is as follows:

 

ServiceID,Name,Type,Schedule,Group,Retention,"Start Time","End Time",Size,Outcome,Ticket MIBRS29531106,mel-cm-svr1,"Windows File System",10pm,T_Solutions_3y_10pm,"3 Years","2022-11-24 22:00:11","2022-11-24 22:17:08",650,Completed, MIBRS29531104,mel-fs3,"Windows File System",10pm,T_Solutions_3y_10pm,"3 Years","2022-11-24 22:00:10","2022-11-25 01:47:52",3620,Completed, MIBRS29531103,mel-exp-fs1,"Windows File System",10pm,T_Solutions_3y_10pm,"3 Years","2022-11-24 22:00:11","2022-11-24 22:13:17",140,Completed, ......

 

Please help with this...

6 REPLIES 6

I am done with step 1 and 3; but am struggling to fetch the data from email body.

It seems from the responses that it is going to be a hard step to finish off.

newhand
Mega Sage

@Maheshwar1 

I'm not sure what can you get from the email body.

May be a huge html string....

If you can modify the email , adding some start end tags  into the email body can make feching data easier....

 

 

 

Please mark my answer as correct and helpful based on Impact.