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:

Windows 7/8.1/10 (Recommended)
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

Step 3

After that, UiPath studio creates the project UiDatascraping with supporting files.

Step 4

Next, for extracting the Structured data from the browser, create a New Sequence workflow named RetrieveData.

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”

Set the BrowserType property as Chrome.

Click Data Scraping.

For Select Element, Click Next in Extract Wizard.

Select the Article Title.

Select Second Element, and click Next in the Extract Wizard.

Select the Article Title for the second element.

Next, Configure columns, Text column Name and URL Column Name in the Extract Wizard.

Next Preview data and click Finish.

Automatically, a data table named ExtractDataTable is created.

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.

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.

The Article Details.csv details are as follows:

Summary

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