How to Dynamically extract data from amazon website by getting the product name from user

Help Studio
, ,
1

Hello,
Recently I am doing my web data scraping project in UiPath. Actually my project is getting input (i.e) product name from the user using input dialog box and using use browser activity I will open my target website (i.e) Amazon. using Type into activity it will type the product name automatically in the search bar of amazon website and it will automatically click enter. once the product is searched then it will extract the name and price of the product.
My Problem is I want to extract the product data which the user is entered at the first. since
the extract table data is predefined to a single product it is not extracting the undefined product values.
For Example
If I have predefined the apple i phone product in the extract table data , if again i entered samsung s20 means it is not extracting.
I want my bot to extract the Product data which the user is entering.

1 Like
2

Hi @THASARATHA_PRANAV_K
Welcome to the community!

Probably what can be done here is:

  1. Login to the Website.
  2. Search for the product name you want from the user input box
  3. Do a Data scraping after searching the product name
  4. Filter the records in the Datatable with product name you wanted using Contains Function.
  5. use the filtered excel as per your convince.

Note: Its important to research the product name again in the website and execute the data scraping again when page loaded probably use it in a loop to do so, as the data scraping works on the pattern of the elements and will not give you an issue if the product name is changed.

Thanks :blush:
Bishwajeet

1 Like
3

But I need a solution to extract any data which I get from the user. is there any modification has to done in the extract table data or I have to write any code in the selector tool.

1 Like
4

only table extraction will work for you, just you have to build the logic inside a loop to search the data again and do the scraping again and it will work, you don’t have to change the selectors of the table extraction

Just modify the attach browser selector using wild cards to make it dynamic irrespective to the product name.

that should work

1 Like
5

Can I get any work flow or simple project which is related to my query.

1 Like
6

Sure I will help you with that, most probably today at night I will be creating it for you and send it to you. Will that work ?

1 Like
7

Thanks a lot for that, you can send that any time.

1 Like
8

Hi @THASARATHA_PRANAV_K

Attaching the Workflow Zip for your reference
DataScraping.zip (14.0 KB)

I have done this for flipkart mobiles you can change it as per your needs, Let me know if this solves your problem. :blush:

Run the workflow and see the output excel on the project folder Mobile.xlsx.

Thanks
Biswajeet

1 Like
9

Hi @THASARATHA_PRANAV_K

Did you check the workflow and was that helpful to you?
If yes can you please mark it as as solution :blush:

Thanks
Bishwajeet Kumar

10

Here I am attaching my project . please make necessary changes to extract a dynamic product data. I am going through on your project once I got clear I will let you know.
BlankProcess.zip (20.0 KB)
phone amazon.xlsx (8.2 KB)
phone flipkart.xlsx (8.1 KB)