Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-12-22 08:10 PM
Dear Experts,
As part of a requirement I have created an Object which reads Outlook Email and write into DB Table.
My Object reading the Email body as text, but some email's body we get in the form of Table.
Can some one please help me how to handle this type of scenario? so that I can read email body (tabular) and write into table in readable format. Example email body as below.
As part of a requirement I have created an Object which reads Outlook Email and write into DB Table.
My Object reading the Email body as text, but some email's body we get in the form of Table.
Can some one please help me how to handle this type of scenario? so that I can read email body (tabular) and write into table in readable format. Example email body as below.
Answered! Go to Answer.
1 BEST ANSWER
Helpful Answers
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-12-22 03:51 AM
Hi @Mohan V
You can extract table in collection for that you need to get email body in html format and extract only table portion of html code and pass it on HTML Agility pack which i have attached in this. By using this action, you will get table in collection.
Thanks
You can extract table in collection for that you need to get email body in html format and extract only table portion of html code and pass it on HTML Agility pack which i have attached in this. By using this action, you will get table in collection.
Thanks
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-12-22 03:51 AM
Hi @Mohan V
You can extract table in collection for that you need to get email body in html format and extract only table portion of html code and pass it on HTML Agility pack which i have attached in this. By using this action, you will get table in collection.
Thanks
You can extract table in collection for that you need to get email body in html format and extract only table portion of html code and pass it on HTML Agility pack which i have attached in this. By using this action, you will get table in collection.
Thanks
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-12-22 04:15 PM
Hi @Soumya K , Thank you very much for the reply.
I have utilized object "HtmlAgilityPack" shared by you, and passed email body (HTML) to it and set Output as "Collection".
When running the process I am seeing error as "Internal : Could not execute code stage because exception thrown by code stage: Object reference not set to an instance of an object." . Being a beginner with BP, I am not getting a clue to resolve this , could you please help?
Below is snapshot of my process. You can see "Body" has data when process reached to "HtmlAgilityPack".
I have utilized object "HtmlAgilityPack" shared by you, and passed email body (HTML) to it and set Output as "Collection".
When running the process I am seeing error as "Internal : Could not execute code stage because exception thrown by code stage: Object reference not set to an instance of an object." . Being a beginner with BP, I am not getting a clue to resolve this , could you please help?
Below is snapshot of my process. You can see "Body" has data when process reached to "HtmlAgilityPack".
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-12-22 08:50 AM
Hi @MohanV
That error may be because of Table headers are in td format in html body of an email, if you change tables headers to th format it may work
Thanks
Soumya
That error may be because of Table headers are in td format in html body of an email, if you change tables headers to th format it may work
Thanks
Soumya
