topic Re: How to read email body which in Tabular Format in Product Forum

How to read email body which in Tabular Format

MohanV — Tue, 06 Dec 2022 20:10:33 GMT

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.

Re: How to read email body which in Tabular Format

Soumya21 — Wed, 07 Dec 2022 03:51:12 GMT

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

Re: How to read email body which in Tabular Format

MohanV — Thu, 08 Dec 2022 16:15:22 GMT

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".

Re: How to read email body which in Tabular Format

Soumya21 — Fri, 09 Dec 2022 08:50:16 GMT

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