How to do Data Scraping in UiPath - Full Tutorial

This video tutorial shows how to do data scraping (table scraping) in UiPath RPA. You'll learn how to extract data from a website to Excel, including selector work, and then do advanced LINQ filtering.

This is Lesson 10 from our Udemy Course. Get all the lessons (discount): https://www.udemy.com/course/uipath-1...

👨‍👩‍👧‍👦 Discord:   / discord  
Join my network with 2500+ RPA Developers, where we solve RPA problems, network, and help each other upgrade our careers. It's free!

FOLLOW ME:
💼 LinkedIn:   / andersjensenorg  
📸 Instagram:   / andersjensenorg  
👨 Facebook:   / andersjensenorg  
🐦 Twitter:   / andersjensenorg  
💌 Email Newsletter: https://andersjensen.org/email-newsle...

0:00 Intro
Data Scraping in UiPath is very easy. This full tutorial with a use case shows how to do table scraping and apply the best practices to ensure the correct result. When the result is ready advanced LINQ filtering is applied. The case is that we want to scrape all results from several Stack Overflow pages to Excel, but the same technique goes for all web pages

1:50 Navigate and validate
We navigate to our web page, here Stack Overflow, and then we apply some settings to ensure we navigate the data we want to extract. Using anchors for UI elements helps us make robust selectors. For example, to ensure we are on the right page, we find an element that changes when we reach the correct page and then use the While loop to make a check.

13:10 Table Extraction in UiPath
Use the Table Extraction wizard to do the scraping. The intuition is that we need to help UiPath understand the pattern. So, for each data type of the table, click Add data and then Finish selection. The Next button is used to scrape multiple pages. The result is stored in a Data Table, which we can write on an Excel sheet.

18:13 Apply LINQ to the results
We use LINQ, a potent query language, to filter the scraped results.

#rpa #uipath #scraping