MarketplaceStudioActivityHTML to DataTable

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

HTML to DataTable

HTML to DataTable

by Internal Labs

7

Activity

Downloads

14.7k

Andrei Stefana
Posted 5 years ago

I get 

Extract data tables from HTML: Object reference not set to an instance of an object.

example:

https://drive.google.com/file/d/13GYF5uorXqsNN9lgSm_ZkWpsYoVWYwJx/view?usp=sharing

Alan Thompson
Posted 5 years ago

Hi Saahil, I am also getting the "Object reference not set to instance of object" error. I am not reading an Outlook message, just regular HTML page source.

I am attaching a link to my source HTML for reference purposes (shortened). It looks like I can't copy and paste it into this message, for some reason. Lastly, it looks like my source might have an extraneous tr tag; I wonder if that might be an issue?

https://1drv.ms/u/s!AuMwoz_9s7iQhnvKFZa1s9p3Gctw?e=TP6Awh

faisal maqsood
Posted 5 years ago

Do you have any video demonstration for this activity?

MARIO J FERNANDEZ N
Posted 5 years ago

Hi Sunil,

Since I can not reply directly to your post, here it goes:

Once you have the output from the HTML activity as an array of DataTale use a regular 'For Each' to iterate inside of it..

MARIO J FERNANDEZ N
Posted 5 years ago

Hi Saahil,

First of all, thx for the Custom Activity. 

I have an inquiry, here's some context: I am getting the HTML for the input and then I'm getting the proper output. For some reason after having some rows as output is not quite getting all the way inside the last one as you can see on the image provided. This info is inside a '' as the previous one but is not getting it.

I'm iterating with a 'For each' to get the HTML tags and then inside that a 'For each row' to get the 'row' info below.

Is there any way we can filter or force it to get to the last 'TD'?

Oh, it seems it does not allow images so here is the code:

 You have 1 new errors.

04/30 18:45            

Folder Default: #robot Dev-Bot disconnected. (#1222)  (not getting this)

Thanks in advance, Be Safe!

Sunil Sharma
Posted 5 years ago

Hello Saahil, first of all thank for your providing this acitivity.

But I am unable to retrieve data using this activity.

Scenario: Getting HTML response a webservice, passing this string to this activity and it just throws me DataTable[1] { [] }.

Prakash Chidambaram
Posted 5 years ago

Hi Saahil,

I am unable to retrieve the tables from Mail Message.  Receiving the following error.

Extract data tables from HTML: Object reference not set to an instance of an object.

Can you help me figure out the issue?  

Thanks in advance,

Prakash

Saahil Chauhan
Posted 5 years ago ago

Hi Prakash, Please share the input data to debug. Thanks :)

Venkatesh nallamekala
Posted 5 years ago

Hi Saahil,

Unable to retrieve tables. Getting ouput as below.

Output:

DataTable[2]

{

[],

[]

}

Unable to trace the error... Can I get source code for this?

Saahil Chauhan
Posted 5 years ago ago

Hi Venkatesh cna you please share with the input data. I will debug and if required update the activity accordingly.

Thanks :)

Pongkhun Pankoed
Posted 5 years ago

Hi sir,

What are the possible ways to identify whether the mail body contains the table content or not?

by use this activities

thanks you.

Best Regard

Saahil Chauhan
Posted 5 years ago ago

Hi to find whether the mail has table or not you can check with table tag use method string.contains(“”)

SNEHAL AMBULKAR
Posted 5 years ago

if i directly download this package how to add this package in uipath studio

Saahil Chauhan
Posted 5 years ago ago

Use manage packages from Studio or download it to a location and provide that folder path as source in the manage packages windows.

Tavinee Inchayanunth
Posted 5 years ago

Hi,

I got an error

Extract data tables from HTML: Could not load file or assembly 'HtmlAgilityPack, Version=1.8.7.0, Culture=neutral, PublicKeyToken=bd319b19eaf3b43a' or one of its dependencies. The system cannot find the file specified.

Saahil Chauhan
Posted 5 years ago ago

Hi Yes there is an dependency of HTMLagility lib but it is already part of the pack. My guess would be that package download was not successful. I would request to delete the present copy and try again please.

mohammed zain
Posted 5 years ago

I am unable to write html code under Html text in properties under Extract datatable from HTML

Saahil Chauhan
Posted 5 years ago ago

Please share a screenshot or error details that you get while doing so.

Publisher

Internal Labs

Visit publisher's page

License & Privacy

License Agreement

Privacy Terms

Technical

Version

2.0.2

Updated

November 17, 2023

Works with

Studio: 22.10 - 23.10

Certification

Silver Certified

Support

UiPath Community Support