Extract similar items of an product

Hi, I’m using Ui Path Studio for extracting a website build.com. So i was able to extract all the products like bath faucets info from the main page, but each product has again 4-5 variations and for that i need to open an individual product and select on each variation. How can i achieve this functionality using Ui Path and how can i extract those products information also? Thanks in advance

1 Like

Hey @srinath.merugu

Some screenshots will help us understand better.

Kindly please.

Thanks
#nK

Hello @srinath.merugu ,

Can you try Table extraction feature in modern design. You can select which all values to extract. It will automatically identify the pattern and extract all similar data. But to get the other data after opening , maybe you will have to loop through each item and fetch the required data and write it to the DataTable which you already extracted using Table extraction.

Hi @Nithinkrishna, I’m attaching the screenshot below

1 Like

It is allowing me to post only one screenshot at a time, so I’m attaching other one here. In this screenshot you can find the similar items, i want to extract them along with the products on main page. I’m already using table extraction feature

1 Like

Hi @Rahul_Unnikrishnan, I’m already using table extraction feature. As u said I’ll try to loop through each item

Sure @srinath.merugu . I hope it should work fine as Table extraction will allow pattern-based data extraction.

Hey @srinath.merugu

So you want to extract products information and each of the product information right ?

If that is the case,

  1. You can use Find Children which gives you all the elements on the summary page

  2. For-each element click on them and do the screen scraping again

Thanks
#nK

Hi @Nithinkrishna, I’m trying to do a forEachRow on my DataTable where it contains URL’s inside it. When I’m trying to loop on each product URL and open that URL in a new browser using this line CurrentRow(“url”).ToString I’m getting following error. Any help would be appreciated, Thank you.

1 Like

Hi @Rahul_Unnikrishnan, I’m trying to use forEachRow on my DataTable where it contains URL’s inside it. When I’m trying to loop on each product URL and open that URL in a new browser using this line CurrentRow(“url”).ToString I’m getting following error. Any help would be appreciated, Thank you.

Hello @srinath.merugu ,

It will accept only UiElement. If you need to provide the URL you have to provide it as below.
Inside unified application target->URL

If i give my URL there, it’s asking me to give value in input field as well

Yes it will ask, because in this activitiy you havent selected the browser to execute the automation process.(like chrome or edge)… So what you can do it, inspect on a browser window. Then go to the selector-> Retain only app=chrome.exe ->Replace other values as *.

for eg as below.

“”

Thanks @Rahul_Unnikrishnan,
My selector looks like this
html app=‘chrome.exe’ title=‘Kohler K-394-4-BN Devonshire Widespread Bathroom | Build.com

So as u said i replaced other values as
html app=‘chrome.exe’ title=‘*’

What it is doing is it’s repeating the page i indicated on browser and navigating to only that one particular page as shown in the image below:

Are you dynamically changing the URL?

Can you print it in a message box or console and check whether the url is getting updated for each loop and the same is passed to Use Application\Browser activity.

Hey @srinath.merugu

You should pass the expression in the activity URL prop !

Thanks
#nK

yeah i was not passing expression properly, I’ve corrected it and now it’s looping properly on each product.
But after opening the individual product i want to extract product name, model no etc. But if i select anything like name/modelNo i was getting cannot determine pattern as shown below. Any help would be appreciated, Thanks.

Hi @Rahul_Unnikrishnan @Nithinkrishna any solution on extracting unstructured data which i posted above? If all the elements are not in a pattern? That’s like a blocker for me, it’d be really helpful if i can get any solution or approach, Thankyou.

Hello @srinath.merugu ,

Here there is no recurring pattern for individual items, thats why you are getting that error. So what you can do is either use Get text Activity and get the individual needed values and assign to respective variable. Then you can add to the datatable which you created earlier using Table extraction.

Else use App/Web recorder to fetch the values from the individual product. Do it for one item and you can use the same activity for other items in a loop