Parsing email body in an inbound email action
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-24-2022 08:09 PM - edited ‎11-24-2022 08:11 PM
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-27-2022 03:20 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-27-2022 05:59 PM
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....