This full video tutorial shows how to extract tables from web pages with infinite scrolling in UiPath Studio. First, you learn how to use the Table Extraction wizard in UiPath while we work on an actual use case. Later in the use case, we do data filtering with the Filter Data Table activity and LINQ.
VIDEOS FOR YOU:
- Join my network with 3100+ RPA Developers, where we solve RPA problems, network, and help each other upgrade our careers. It's free!
FOLLOW ME:
MY MONITOR (Amazon affiliate):
0:00 Intro
Today we're building a real-time UiPath use case from scratch. We want to extract structured data, and our problem is that it's a web page with scrolling.
9:44 Handle Mouse Scrolling In Data Extraction
Before we can extract data, we need to ensure we're scrolled down the web page. Then, using the Mouse Scroll and Do While activities in UiPath, we compare the results and keep scrolling until we're at the bottom of the page. The best practice is always to ensure we validate the data before we extract the data.
27:06 The Table Extraction Wizard In UiPath
The table extraction wizard is easy to use. First, find the structured data you want to scrape. Then, you can even extract the URL. Finally, you can rename the headers to make the automation and output easier to interpret.
34:42 Save The Scraped Results To Excel
We use a variable for storing the folder path. This is handy if the path change or we're using the path several times in the UiPath workflow. To ensure we don't overwrite the Excel results, we create a dynamic file name using the .NET time format.
46:56 Filter Data In UiPath
The Filter Data Table activity in UiPath helps us define the data table rows we want to keep. Finally, we use LINQ to filter and sort data. LINQ is a powerful query language we use a lot in UiPath.
#uipath #rpa #roboticprocessautomation