In this tutorial, you will learn how to use Data Scraping in UiPath to scrape data from a website, place it in a Data Table and present it in Microsoft Excel afterward. You will see two practical examples where the last one will have problems with the ‘Next Link Selector’. Here we will solve the problem by creating a dynamic selector and a simple While Loop.

You could also watch:
🔵 Data Scraping Beginners Guide - [ Ссылка ]
🔵 UiPath Beginners Tutorial - [ Ссылка ]
🔵 Try Open Source Data Scraping with OpenRPA - [ Ссылка ]
🔵 UiPath Data Scrape from Amazon to Excel - [ Ссылка ]

00:00 Intro

00:30 Data Scraping case #1 - Strava
The first use case scrapes data from Strava, a social network for running and cycling tracking.

02:35 UiPath Data Scraping
We are using the build-in Data Scraping guide in UiPath. By selecting two elements in the structured data, UiPath recognizes the entire data set, including that the data spans multiple pages (the Data Scraping will automatically click the next page).

03:30 Renaming Data Table
To operate within the best practices for UiPath, we are renaming the Data Table to camel format.

03:55 Export data to Excel
With a Write Range, we are exporting the scraped data to an Excel sheet.

06:30 Data Scraping case #2 - 'Smiley-ordning'
Scraping the data from the Food Control (applied by the Danish Government) web page. Again, we indicate that our data is spanning multiple pages and renaming the data table to fit the UiPath best practice standard.

08:32 Write out the scraped data to Excel

10:15 Fixing the Problem - creating a dynamic selector
To do Data Scraping that can target multiple pages, when the build-in wizard fails, we create a dynamic selector.

13:36 Element Exist
We are asking if the "Next Page" button exists.

14:18 Creating a While Loop to scrape the Data
If yes, then click it and scrape the data.

18:34 Bingo 😄

FOLLOW ME:
💼 LinkedIn: [ Ссылка ]
🐦 Twitter: [ Ссылка ]
📸 Instagram: [ Ссылка ]
👨 Facebook: [ Ссылка ]
👨‍👩‍👧‍👦 Discord: [ Ссылка ]
💌 Email Newsletter: [ Ссылка ]

📂Get the files from the video
[ Ссылка ]

#uipath #webscraping #datascraping

свернуть