MarketplaceStudioActivityExtract Tables from Mail

Create your first automation in just a few minutes.Try Studio Web

Extract Tables from Mail

Extract Tables from Mail

by YouTube

Star

7

Activity

Downloads

228

Posted 5 years ago

There is only 1 tabe in Email body, when i use this activity the count it returns is 4 and not sure why

Can you please help me on this? as i am facing this issue in production

Posted 5 years ago

Hi Sourav,

I am getting this error:

Extract tables from email: Value cannot be null.

Parameter name: html

Please kindly help me in resolving this

Posted 5 years ago

Hi Sourav, 

I have trouble extracting tables when using "Get exchange mail" activity.  I am getting the following exception: "Extract tables from email: Value cannot be null.

Parameter name: html".

Works fine with "get outlook mail" activity though. Any idea why?

Posted 5 years ago

Hi Sourav,

I am facing some issue while installing the package, kindly help me on this.

Please find the below info. 

2019.4.3 - 05/22/2019

Enterprise Edition

Windows Installer

Microsoft Windows 10 Enterprise 64-bit

.NET Framework Version 4.7.2 or later

Iam getting below error:

19.4.3+Branch.support/v2019.4.Sha.a8f4efb75012dc834aa4be501a7086e9372ef1b3

The project 'C:\Users\O17379\Documents\UiPath\BlankProcess2\project.json' could not be opened: 'C:\Program Files (x86)\UiPath\Studio\Packages\UiPath.ExtractTablesFromMail.nupkg' is not a valid nupkg file. Error: 'A local file header is corrupt.'..

Posted 5 years ago

How to insert Mail Message as input ?

Posted 5 years ago

Hi Sourav,

How to print dataset in uipath?

Himanshu Lilha
Posted 5 years ago ago

I have uploaded a sample workflow on below forum post:

You can use output datatable activity on tables in your dataset or write the tables to an excel.

https://forum.uipath.com/t/read-all-the-tables-into-a-dataset-which-are-in-the-current-mail-in-outlook/181574/2

Posted 5 years ago

Thanks Sourav. I've asked and please find the link for the same.

https://forum.uipath.com/t/read-all-the-tables-into-a-dataset-which-are-in-the-current-mail/181574

Posted 5 years ago

I totally agree but can we get all the tables which are in the current mail than chain mail. How to achieve that task?

Himanshu Lilha
Posted 5 years ago ago

We can modify the mail message variable to have contents of current email only, before passing to this activity. This activity is designed to extract all tabular data from email. Please ask this query on Forum.uipath.com and our community and I would be happy to share the solution :)

Posted 5 years ago

That's soo great Sourav. But I see it is reading all the tables included in the chain mail too. Do we've any configuration to allow or stop it?

Himanshu Lilha
Posted 5 years ago ago

It would return all the tables in the email. If you want to use only the table from current mail and not the chain mail , you can just use first table of the returned dataset.

Posted 5 years ago

Hi,

Can I get a source code for it as it is not working for me..?

Himanshu Lilha
Posted 5 years ago ago

Hi Venkatesh,

The Activity will only extract tables if your email has tables in its body( tag present). Please check if you are reading the correct email and passing to this activity. Dataset.tables.count will return the number of tables in the email. Also as it returns a dataset you can iterate through a for each loop in datasetvariable.tables with type argument as datatable.

Publisher

YouTube

Visit publisher's page

Trusted Source

License & Privacy

License Agreement

Privacy Terms

Technical

Version

1.0.0

Updated

February 18, 2020

Works with

v2016.2 onwards

Certification

Silver Certified

Tags

Support

UiPath Community Support