I am trying to extract a table from a site using data scraping. But UIPath only fetches first few rows. I tried using scrolling down and then data scraping. But then it only fetches last few rows.
My table is in single page but need to scroll down to seen more rows.
Try by providing maximum number of results to 0.
Also, when you done screen scrapping are you able to see the preview data with whole values in the page?
Also check the selector.
I think after capturing the first element you had given the option as yes for the popup “would you like to extract data from the whole table?”. Can you try without giving yes for that pop up and scrape necessary data
First of all once you load the webpage make sure all elements are loaded with property set to ‘COMPLETE’ and check the table element exists or not.
Send a hotkey ‘home’ and ‘end’ just to be sure.
While data scraping keep rows as ‘0’ for whole table to be scraped.
That’s all there is to it, but it is better to inspect the table element and see whether the DomXPath is increasing steadily without any abrupt gaps because pattern recognition can work only under the condition that there is no break in continuity.
The workaround would be attribute based extraction and string operation using ‘Find children’ activity and looping through the descendants (you might have to put some conditional statements which will work if the table has loaded properly)
Sometime there might be another DIV inside that table node which might be confusing the data scraper.
Hello Raghavendra,
I have a similar problem… the table exists, but only visible rows are extracted. Can you share the alternate method please ?
thanks
Preeti
Hello @preetith@Raghavendraprasad
I’m also facing the same issue… In an ERP software I have a table with approx 140 rows. I have tried to extract data using Data Scrapping activity…but it is selecting only 55rows instead of 140 (tried both MaxNumberofResults equals 0 and 100).