Data Scraping In Webpage Automation Using UiPath Studio

Introduction 

 
Robotic Process Automation is a technology that allows anyone to configure computer software, or a “robot”, to emulate and integrate the actions of a human interacting within digital systems to execute a business process.
 
RPA robots utilize the user interface to capture data and manipulate applications just like humans do. They interpret, trigger responses, and communicate with other systems in order to perform on a vast variety of repetitive tasks. However, they are substantially better, since an RPA software robot never sleeps and makes zero mistakes.
 
UiPath is a leading Robotic Process Automation vendor that provides a complete software platform to help organizations efficiently automate business processes.
 
UiPath Studio is a tool that can model an organization's business processes visually.
 
Data scraping enables you to extract structured data from your browser, application, or document to a database, .csv file, or even Excel spreadsheet.
 
By reading this article, you can learn How to scrap the data from the Webpage automation bot using OpenBrowser and Write CSV activities in UiPath Studio Pro Community.
 
The following tools are required for developing UiPath Bot:
  1. Windows 7/8.1/10 (Recommended)
  2. UiPath Studio Pro - Community Cloud (Free software available online – https://www.uipath.com/start-trial)
Now we can discuss bot development step-by-step.
 
Step 1
 
Open UiPath Studio -> Start -> New Project-> Click Process
 
Data Scraping In A Webpage Automation Using UiPath Studio
 
Step 2
 
Now, create a New Blank Process, name it UiDatascraping and give it a description
 
Data Scraping In A Webpage Automation Using UiPath Studio
 
Step 3
 
After that, UiPath studio creates the project UiDatascraping with supporting files.
 
Data Scraping In A Webpage Automation Using UiPath Studio
 
Step 4
 
Next, for extracting the Structured data from the browser, create a New Sequence workflow named RetrieveData.
 
Data Scraping In A Webpage Automation Using UiPath Studio
 
Click Activities -> search Open Browser activity->Drag and drop into the sequence and set the URL as "https://www.c-sharpcorner.com/members/vijayaragavan-s3”
 
Data Scraping In A Webpage Automation Using UiPath Studio
 
Set the BrowserType property as Chrome.
 
Data Scraping In A Webpage Automation Using UiPath Studio
 
Click Data Scraping.
 
Data Scraping In A Webpage Automation Using UiPath Studio
 
For Select Element, Click Next in Extract Wizard.
 
 
Select the Article Title.
 
Data Scraping In A Webpage Automation Using UiPath Studio
 
Select Second Element, and click Next in the Extract Wizard.
 
Data Scraping In A Webpage Automation Using UiPath Studio
 
Select the Article Title for the second element.
 
Data Scraping In A Webpage Automation Using UiPath Studio
 
Next, Configure columns, Text column Name and URL Column Name in the Extract Wizard.
 
Data Scraping In A Webpage Automation Using UiPath Studio
 
Next Preview data and click Finish.
 
Data Scraping In A Webpage Automation Using UiPath Studio
 
Automatically, a data table named ExtractDataTable is created.
 
Data Scraping In A Webpage Automation Using UiPath Studio
 
For displaying the DataTable value , click Activities -> search WriteCSV activity -> drag and drop in to sequence, then set the Filepath property as "ArticleDetail.csv" andDataTable property as ExtractDataTable.
 
Data Scraping In A Webpage Automation Using UiPath Studio
 
Step 5
 
To run your project, select debug file -> Run, The output of the UiDatascraping project is as shown below. I created the file name as Article Details.csv.
 
Data Scraping In A Webpage Automation Using UiPath Studio
 
The Article Details.csv details are as follows:
 
Data Scraping In A Webpage Automation Using UiPath Studio
 

Summary

 
Congrats! You have successfully tested the DataScraping text from a webpage automation bot using UiPath Studio.