Extracting additional data from Zillow API

Hello
You have to put the code and explain more details.

do you mean this from post 6?

I think most of us don't have a Zillow id and don't want to sign up so...
you might have to be pretty specific as to what you want.

Please Login or Register  to view this content.

I would like to extract different fields than in the original code and I'm having trouble doing so.

I want to extract the f-estimate. the z estimate is the zAmount already being extracted.

In addition, I would like the extract the year-built, sqr. footage, acreage, style, type, date last sold, what amount last sold for, and status of the house.

Thanks in advance!

Just for the record, scottiex has asked for additional help on this.

So Zillow API returns XML response.

In order to read and retrieve value, you'd need to understand it's structure.

Insert following into the code. Right after "If xmldoc.Load(Url) Then" line.
Changing "C:\Test\ZillowAPI.txt" as needed.

Please Login or Register  to view this content.

Run the code for valid address (just the one) that you know returns result (i.e. the address from your initial post).
Then either comment out the code or remove it.

This will have generated xml file with all nodes populated.
Now go to Developer tab of your Excel file. And find "XML" section and click on Import.
Import the ZillowAPI.xml file generated. Click on Source in XML section.

This will give you structure of the xml response from Zillow.
0.JPG

You can then use folder (node path) structure to scrape data.

However, looking at the xml file content and what you mention, I can't find the other price (803,006) that you mention.

As well, the code you posted does scrape all price/value available in the xml.

The value you are after, isn't included in this API. You'll need to find other ways to scrape the data (or contact Zillow to find if there is API specifically to get that data).