Using Table Extraction to scrape to data from Screen

[lalatendu_das]

I am trying to capture the sale price of all homes listed from a website into a extract table.
I see some of the Sale prices are not getting capture, while others are getting captured and listed in the extract table.

Any suggestions, why certain price values are not getting captured and what could be a work around solution?

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @lalatendu_das,

When you say some values are not getting captured, does it some cell valuemissing from different rows or you are unable to see any data from certain rows completely?

Regards
Sonali

[prashant1603765 (Prashant Kumar)]

Hi @lalatendu_das
Welcome to UiPath

In UiPath, missing sale prices may be due to dynamic loading, different HTML structures, pagination, anti-scraping measures, or missing data. Use “Wait for Ready” or “Wait Attribute” for dynamic content. Use “Find Children” or “Get Attribute” for varying HTML structures. Handle pagination with a loop and “Next” button click.

If it’s helpful, pls mark as a solution

[sharazkm32 (Sharaz K M)]

Share a sample screenshot of URL if it is public to check from our side

[ashokkarale]

@lalatendu_das,

Try selecting the pricing element again. While selecting check if all the values are being highlighted or not

[lalatendu_das]

the area rounded in red are not getting captured vs areas pointed in green are.
These are cost price of house and address.

[lalatendu_das]

Its a page on Zillow.com which I open in in-cognito, I am filtering on a City, for sale and type is Home.

I want to extract a data table for the price of each house and address. Price and address of a few of the houses are getting selected ( refer screenshot) whereas others are not.( circled in red)

https://www.zillow.com/ny/houses/?searchQueryState=%7B%22pagination%22%3A%7B%7D%2C%22isMapVisible%22%3Atrue%2C%22mapBounds%22%3A%7B%22west%22%3A-82.19704245312501%2C%22east%22%3A-69.34303854687501%2C%22south%22%3A39.43710769635741%2C%22north%22%3A45.96724774491888%7D%2C%22regionSelection%22%3A%5B%7B%22regionId%22%3A43%2C%22regionType%22%3A2%7D%5D%2C%22filterState%22%3A%7B%22sort%22%3A%7B%22value%22%3A%22globalrelevanceex%22%7D%2C%22tow%22%3A%7B%22value%22%3Afalse%7D%2C%22mf%22%3A%7B%22value%22%3Afalse%7D%2C%22con%22%3A%7B%22value%22%3Afalse%7D%2C%22land%22%3A%7B%22value%22%3Afalse%7D%2C%22apa%22%3A%7B%22value%22%3Afalse%7D%2C%22manu%22%3A%7B%22value%22%3Afalse%7D%2C%22apco%22%3A%7B%22value%22%3Afalse%7D%7D%2C%22isListVisible%22%3Atrue%2C%22mapZoom%22%3A7%2C%22usersSearchTerm%22%3A%22NY%22%7D

[yedukondaluaregala]

@lalatendu_das

Able to extract all the data when i try,
use table extraction
1.1st time select price and add the column if you want in table extraction activity
2.click on select Data to extract
3.and select address
4.scroll down until the page end
5.then you can see all data highlighted whatever you selected to extract
6.enable extract data from multiple page
7.indicate next button
8.click on save and close

[Anil_G (Anil Gorthi)]

@lalatendu_das

When you select the value select the inner most square that gets highlighted…

As per screenshot looks like there is some styling or css difference for few prices…so if you indicate the similar type of item Generally the innermost div or span will be same

Cheers

[ashokkarale]

@lalatendu_das,

This is happening due to the properties are loading dynamically as we scroll down.
Use Mouse scroll to scroll to the end of the page and then use Extract Table Data.