How to extract data table from web application?

Help StudioX
,
1

Hi All

I have data in web application as below.
AccountNumber, Server
45678 xyc
78592 cbc
45825 taxx
96351 mxx
how to extract could you please help me on this.
Thank you,

1 Like
2

HI @Raghu_km

Have you tried data scrapping?

Regards
Sudharsan

2 Likes
3

Hi @Raghu_km
https://docs.uipath.com/studio/docs/about-data-scraping

Hope this is useful.

Regards,
Suraj

4

Hi @Raghu_km

To extract data from a web application in UiPath, you can use the Data Scraping feature. Here are the steps:

  1. Open UiPath Studio and create a new project.
  2. Use the “Open Browser” activity to navigate to the web page where your data is located.
  3. Once the web page has loaded, use the “Data Scraping” wizard to extract the data. To do this, click “Data Scraping” in the “Design” tab of the UiPath Studio ribbon.
  4. In the “Data Scraping” wizard, select “Extract structured data” and follow the prompts to select the data on the web page you want to extract. You can use the “Next” button to go through the pages of data and select the columns you want to extract.
  5. Once you have selected the data you want to extract, the wizard will generate a table with the extracted data. You can then use the “Output Data Table” activity to save the table to a file or variable.

In your specific case, it looks like you have two columns of data, “AccountNumber” and “Server”. You can use the Data Scraping wizard to extract both columns by selecting them during the column selection step. The resulting table can then be saved as a CSV file or manipulated using other UiPath activities.

Regards
Tuan

5

Hi Sudharsan, Yes I tried e-commerce applications it was working but when i try to extract data from my company applications this method is not working for me .

6

@Raghu_km

Can you use ui explorer and show the selector you see for the table or a cell in the table in the website you are trying to automate

Cheers

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.