CFHTTP Get XML and Output Charts listed in Nodes

Show come of you code.  Also can you attache a complete block of the XML

<CFHTTP url="http://www.zillow.com/webservice/GetDemographics.htm?zwsxxxxxx=X1-ZWz1xxxxxyux7_963mm&state=WA&city=Seattle" method="get">
<cfset xmlDoc = XMLParse(cfhttp.filecontent)>
<cfset studyNodes = xmlSearch(xmlDoc,'/demographics/response/charts/chart')>

<cfoutput><cfdump var="#studyNodes#"></cfoutput>

I  thought I could do a xmlsearch and dump it to see if I am getting those nodes.

  <?xml version="1.0" encoding="utf-8" ?> 
- <Demographics:demographics xmlns:Demographics="http://www.zillow.com/static/xsd/Demographics.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.zillow.com/static/xsd/Demographics.xsd /vstatic/81d13a774afdb0ce0935e5c0fd1f0b3d/static/xsd/Demographics.xsd">
- <request>
  <state>WA</state> 
  <city>Seattle</city> 
  </request>
- <message>
  <text>Request successfully processed</text> 
  <code>0</code> 
  </message>
- <response>
- <region>
  <id>16037</id> 
  <state>Washington</state> 
  <city>Seattle</city> 
  </region>
- <links>
  <main>http://www.zillow.com/local-info/WA-Seattle/</main> 
  <affordability>http://www.zillow.com/local-info/WA-Seattle-home-value/</affordability> 
  <homesandrealestate>http://www.zillow.com/local-info/WA-Seattle-homes/</homesandrealestate> 
  <people>http://www.zillow.com/local-info/WA-Seattle-people/</people> 
  <forSale>http://www.zillow.com/homes/for_sale/Seattle-WA/</forSale> 
  <forSaleByOwner>http://www.zillow.com/homes/fsbo/Seattle-WA/</forSaleByOwner> 
  <foreclosures>http://www.zillow.com/homes/for_sale/Seattle-WA/fore_lt/</foreclosures> 
  </links>
- <charts>
- <chart>
  <name>Average Condo Value</name> 
  <url>http://www.zillow.com/app?chartType=affordability_avgCondoValue&graphType=barChart&regionId=16037&regionType=6&service=chart</url> 
  </chart>
- <chart>
  <name>Average Home Value</name> 
  <url>http://www.zillow.com/app?chartType=affordability_avgHomeValue&graphType=barChart&regionId=16037&regionType=6&service=chart</url> 
  </chart>
- <chart>
  <name>Dollars Per Square Feet</name> 
  <url>http://www.zillow.com/app?chartType=affordability_pricePerSqft&graphType=barChart&regionId=16037&regionType=6&service=chart</url> 
  </chart>
- <chart>
  <name>Zindex Distribution</name> 
  <url>http://www.zillow.com/app?chartType=affordability_ZindexByDistribution&graphType=barChart&regionId=16037&regionType=6&service=chart</url> 
  </chart>
- <chart>
  <name>Home Type</name> 
  <url>http://www.zillow.com/app?chartType=home_homeType&graphType=barChart&regionId=16037&regionType=6&service=chart</url> 
  </chart>
- <chart>
  <name>Owners vs. Renters</name> 
  <url>http://www.zillow.com/app?chartType=home_ownVsRent&graphType=barChart&regionId=16037&regionType=6&service=chart</url> 
  </chart>
- <chart>
  <name>Home Size in Square Feet</name> 
  <url>http://www.zillow.com/app?chartType=home_homeSize&graphType=barChart&regionId=16037&regionType=6&service=chart</url> 
  </chart>
- <chart>
  <name>Year Built</name> 
  <url>http://www.zillow.com/app?chartType=home_yearBuilt&graphType=barChart&regionId=16037&regionType=6&service=chart</url> 
  </chart>
  </charts>
- <market>
  <forSaleCount>2698</forSaleCount> 
  <recentlySoldCount>7900</recentlySoldCount> 
  </market>
- <pages>
+ <page>
  <name>Affordability</name> 
- <tables>
- <table>
  <name>Affordability Data</name> 
- <data>
- <attribute>
  <name>Zillow Home Value Index</name> 
- <values>
- <city>
  <value currency="USD">403000</value> 
  </city>
- <nation>
  <value currency="USD">204769</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>1-Yr. Change</name> 
- <values>
- <city>
  <value currency="USD">-0.11816192560175055</value> 
  </city>
- <nation>
  <value currency="USD">-0.10533950253190551</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Zestimate Per Sq. Ft.</name> 
- <values>
- <city>
  <value currency="USD">369.0076</value> 
  </city>
- <nation>
  <value currency="USD">257.6997</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Flips (Sold Twice Within the Last Yr.)</name> 
- <values>
- <city>
  <value type="percent">0.010662789288743</value> 
  </city>
- <nation>
  <value type="percent">0.02302134345647</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Turnover (Sold Within Last Yr.)</name> 
- <values>
- <city>
  <value type="percent">0.04222844190199399</value> 
  </city>
- <nation>
  <value type="percent">0.02177690128703452</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Property Tax</name> 
- <values>
- <city>
  <value currency="USD">3773.5624</value> 
  </city>
- <nation>
  <value currency="USD">2861.1644</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Median Condo Value</name> 
- <values>
- <city>
  <value currency="USD">342000</value> 
  </city>
- <nation>
  <value currency="USD">216500</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Median Single Family Home Value</name> 
- <values>
- <city>
  <value currency="USD">470000</value> 
  </city>
- <nation>
  <value currency="USD">234000</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Median 2-Bedroom Home Value</name> 
- <values>
- <city>
  <value currency="USD">394500</value> 
  </city>
- <nation>
  <value currency="USD">205000</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Median 3-Bedroom Home Value</name> 
- <values>
- <city>
  <value currency="USD">464000</value> 
  </city>
- <nation>
  <value currency="USD">231500</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Median 4-Bedroom Home Value</name> 
- <values>
- <city>
  <value currency="USD">531000</value> 
  </city>
- <nation>
  <value currency="USD">337500</value> 
  </nation>
  </values>
  </attribute>
  </data>
  </table>
- <table>
  <name>Census Summary-PricePerSqFt</name> 
- <data>
- <attribute>
  <name>$100-200</name> 
  <value type="percent">0.073563301914213</value> 
  </attribute>
- <attribute>
  <name>$200-300</name> 
  <value type="percent">0.322390275297927</value> 
  </attribute>
- <attribute>
  <name>$300-400</name> 
  <value type="percent">0.324990657310135</value> 
  </attribute>
- <attribute>
  <name>$400-500</name> 
  <value type="percent">0.177718722750487</value> 
  </attribute>
- <attribute>
  <name>$500-600</name> 
  <value type="percent">0.06551301748121</value> 
  </attribute>
- <attribute>
  <name>$600-800</name> 
  <value type="percent">0.023642195739733</value> 
  </attribute>
- <attribute>
  <name><$100</name> 
  <value type="percent">0.001676493792301</value> 
  </attribute>
- <attribute>
  <name>>$800k</name> 
  <value type="percent">0.010505335713989</value> 
  </attribute>
  </data>
  </table>
- <table>
  <name>Census Summary-ZestimateBand</name> 
- <data>
- <attribute>
  <name>$100-200k</name> 
  <value type="percent">0.011517316925848</value> 
  </attribute>
- <attribute>
  <name>$200-300k</name> 
  <value type="percent">0.125252101270488</value> 
  </attribute>
- <attribute>
  <name>$300-400k</name> 
  <value type="percent">0.241587239836607</value> 
  </attribute>
- <attribute>
  <name>$400-500k</name> 
  <value type="percent">0.223584393779625</value> 
  </attribute>
- <attribute>
  <name>$500-600k</name> 
  <value type="percent">0.145369014834304</value> 
  </attribute>
- <attribute>
  <name>$600-800k</name> 
  <value type="percent">0.137675447127837</value> 
  </attribute>
- <attribute>
  <name>>$800k</name> 
  <value type="percent">0.087096509997031</value> 
  </attribute>
  </data>
  </table>
- <table>
  <name>Zindex:ZindexHomeType</name> 
- <data>
- <attribute>
  <name>Condo</name> 
  <value currency="USD">342000</value> 
  </attribute>
- <attribute>
  <name>SFR</name> 
  <value currency="USD">470000</value> 
  </attribute>
  </data>
  </table>
  </tables>
  </page>
- <page>
  <name>Homes & Real Estate</name> 
- <tables>
- <table>
  <name>Homes & Real Estate Data</name> 
- <data>
- <attribute>
  <name>Owners</name> 
- <values>
- <city>
  <value type="percent">0.48412441</value> 
  </city>
- <nation>
  <value type="percent">0.66268764</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Renters</name> 
- <values>
- <city>
  <value type="percent">0.51587559</value> 
  </city>
- <nation>
  <value type="percent">0.33731236</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Median Home Size (Sq. Ft.)</name> 
- <values>
- <city>
  <value>1460</value> 
  </city>
- <nation>
  <value>1548</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Avg. Year Built</name> 
- <values>
- <city>
  <value>1948</value> 
  </city>
- <nation>
  <value>1974</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Single-Family Homes</name> 
+ <values>
- <city>
  <value type="percent">0.744142613732302</value> 
  </city>
- <nation>
  <value type="percent">0.773489943802217</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Condos</name> 
- <values>
- <city>
  <value type="percent">0.198488515480691</value> 
  </city>
- <nation>
  <value type="percent">0.089624612631314</value> 
  </nation>
  </values>
  </attribute>
  </data>
  </table>
- <table>
  <name>BuiltYear</name> 
- <data>
- <attribute>
  <name>>2000</name> 
  <value type="percent">0.090217235225337</value> 
  </attribute>
- <attribute>
  <name>1900-1919</name> 
  <value type="percent">0.180572934829432</value> 
  </attribute>
- <attribute>
  <name>1920-1939</name> 
  <value type="percent">0.182731953475968</value> 
  </attribute>
- <attribute>
  <name>1940-1959</name> 
  <value type="percent">0.289605940634679</value> 
  </attribute>
- <attribute>
  <name>1960-1979</name> 
  <value type="percent">0.125874376910295</value> 
  </attribute>
- <attribute>
  <name>1980-1999</name> 
  <value type="percent">0.130997558924285</value> 
  </attribute>
  </data>
  </table>
- <table>
  <name>Census Summary-HomeSize</name> 
- <data>
- <attribute>
  <name><1000sqft</name> 
  <value type="percent">0.229809313789077</value> 
  </attribute>
- <attribute>
  <name>>3600sqft</name> 
  <value type="percent">0.027988065897003</value> 
  </attribute>
- <attribute>
  <name>1000-1400sqft</name> 
  <value type="percent">0.23692826566351</value> 
  </attribute>
- <attribute>
  <name>1400-1800sqft</name> 
  <value type="percent">0.199958490076533</value> 
  </attribute>
- <attribute>
  <name>1800-2400sqft</name> 
  <value type="percent">0.186649370865222</value> 
  </attribute>
- <attribute>
  <name>2400-3600sqft</name> 
  <value type="percent">0.114167855753015</value> 
  </attribute>
  </data>
  </table>
- <table>
  <name>Census Summary-HomeType</name> 
- <data>
- <attribute>
  <name>Condo</name> 
  <value type="percent">0.198488515480691</value> 
  </attribute>
- <attribute>
  <name>Other</name> 
  <value type="percent">0.057368870787005</value> 
  </attribute>
- <attribute>
  <name>SingleFamily</name> 
  <value type="percent">0.744142613732302</value> 
  </attribute>
  </data>
  </table>
- <table>
  <name>Census Summary-Occupancy</name> 
- <data>
- <attribute>
  <name>Own</name> 
  <value type="percent">0.48412441</value> 
  </attribute>
- <attribute>
  <name>Rent</name> 
  <value type="percent">0.51587559</value> 
  </attribute>
  </data>
  </table>
  </tables>
  </page>
- <page>
  <name>People</name> 
- <tables>
- <table>
  <name>People Data</name> 
- <data>
- <attribute>
  <name>Median Household Income</name> 
- <values>
- <city>
  <value currency="USD">45736</value> 
  </city>
- <nation>
  <value currency="USD">44512.0130806292</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Single Males</name> 
- <values>
- <city>
  <value type="percent">0.230033266826908</value> 
  </city>
- <nation>
  <value type="percent">0.146462187349365</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Single Females</name> 
- <values>
- <city>
  <value type="percent">0.187486853578992</value> 
  </city>
- <nation>
  <value type="percent">0.124578258618535</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Median Age</name> 
- <values>
- <city>
  <value>37</value> 
  </city>
- <nation>
  <value>36</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Homes With Kids</name> 
- <values>
- <city>
  <value type="percent">0.181808339938523</value> 
  </city>
- <nation>
  <value type="percent">0.313623902816284</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Average Household Size</name> 
- <values>
- <city>
  <value>2.08</value> 
  </city>
- <nation>
  <value>2.58883240001203</value> 
  </nation>
  </values>
  </attribute>
- <attribute>
  <name>Average Commute Time (Minutes)</name> 
- <values>
- <city>
  <value>26.6363786935206</value> 
  </city>
- <nation>
  <value>26.375545725891282</value> 
  </nation>
  </values>
  </attribute>
  </data>
  </table>
- <table>
  <name>Census Summary-AgeDecade</name> 
- <data>
- <attribute>
  <name>>=70s</name> 
  <value type="percent">0.0949154648324828</value> 
  </attribute>
- <attribute>
  <name>0s</name> 
  <value type="percent">0.0894075881961393</value> 
  </attribute>
- <attribute>
  <name>10s</name> 
  <value type="percent">0.0939587308631018</value> 
  </attribute>
- <attribute>
  <name>20s</name> 
  <value type="percent">0.199337918792989</value> 
  </attribute>
- <attribute>
  <name>30s</name> 
  <value type="percent">0.196015087641447</value> 
  </attribute>
- <attribute>
  <name>40s</name> 
  <value type="percent">0.162076769469714</value> 
  </attribute>
- <attribute>
  <name>50s</name> 
  <value type="percent">0.108700244064788</value> 
  </attribute>
- <attribute>
  <name>60s</name> 
  <value type="percent">0.0555881961393388</value> 
  </attribute>
  </data>
  </table>
- <table>
  <name>Census Summary-CommuteTime</name> 
- <data>
- <attribute>
  <name><10min</name> 
  <value type="percent">0.093782297601696</value> 
  </attribute>
- <attribute>
  <name>>=60min</name> 
  <value type="percent">0.0512620908970452</value> 
  </attribute>
- <attribute>
  <name>10-20min</name> 
  <value type="percent">0.295385583675633</value> 
  </attribute>
- <attribute>
  <name>20-30min</name> 
  <value type="percent">0.256535709553465</value> 
  </attribute>
- <attribute>
  <name>30-45min</name> 
  <value type="percent">0.198499403736584</value> 
  </attribute>
- <attribute>
  <name>45-60min</name> 
  <value type="percent">0.104534914535577</value> 
  </attribute>
  </data>
  </table>
- <table>
  <name>Census Summary-Household</name> 
- <data>
- <attribute>
  <name>NoKids</name> 
  <value type="percent">0.818191660061477</value> 
  </attribute>
- <attribute>
  <name>WithKids</name> 
  <value type="percent">0.181808339938523</value> 
  </attribute>
  </data>
  </table>
- <table>
  <name>Census Summary-RelationshipStatus</name> 
- <data>
- <attribute>
  <name>Divorced-Female</name> 
  <value type="percent">0.0641341128948266</value> 
  </attribute>
- <attribute>
  <name>Divorced-Male</name> 
  <value type="percent">0.0501983960855829</value> 
  </attribute>
- <attribute>
  <name>Married-Female</name> 
  <value type="percent">0.206254326831769</value> 
  </attribute>
- <attribute>
  <name>Married-Male</name> 
  <value type="percent">0.208028966032711</value> 
  </attribute>
- <attribute>
  <name>Single-Female</name> 
  <value type="percent">0.187486853578992</value> 
  </attribute>
- <attribute>
  <name>Single-Male</name> 
  <value type="percent">0.230033266826908</value> 
  </attribute>
- <attribute>
  <name>Widowed-Female</name> 
  <value type="percent">0.0438983248141122</value> 
  </attribute>
- <attribute>
  <name>Widowed-Male</name> 
  <value type="percent">0.00996575293509803</value> 
  </attribute>
  </data>
  </table>
  </tables>
- <segmentation>
- <liveshere>
  <title>Power Singles</title> 
  <name>High-income urban singles.</name> 
  <description>Highly educated professionals, many with advanced degrees. They draw a handsome salary and have reasonable living expenses while living a hip, upscale life in an urban center.</description> 
  </liveshere>
- <liveshere>
  <title>College Life</title> 
  <name>Students in higher education. These individuals are enrolled in college or graduate school.</name> 
  <description>People in college or graduate school.</description> 
  </liveshere>
- <liveshere>
  <title>Makin' It Singles</title> 
  <name>Upper-scale urban singles.</name> 
  <description>Pre-middle-age to middle-age singles with upper-scale incomes. May or may not own their own home. Most have college educations and are employed in mid-management professions.</description> 
  </liveshere>
- <liveshere>
  <title>Aspiring Urbanites</title> 
  <name>Urban singles with moderate income.</name> 
  <description>Low- to middle-income singles over a wide age range. Some have a college education. They work in a variety of occupations, including some management-level positions.</description> 
  </liveshere>
- <liveshere>
  <title>Bright Lights, Big City</title> 
  <name>Very mobile singles living in the city.</name> 
  <description>Singles ranging in age from early 20s to mid-40s who have moved to an urban setting. Most rent their apartment or condo. Some have a college education and work in services and the professional sector.</description> 
  </liveshere>
  </segmentation>
- <uniqueness>
- <category type="Education">
  <characteristic>Bachelor's degrees</characteristic> 
  <characteristic>Master's degrees</characteristic> 
  </category>
- <category type="Income">
  <characteristic>High rent compared to income</characteristic> 
  </category>
- <category type="People & Culture">
  <characteristic>Born in the Midwest</characteristic> 
  <characteristic>Born in the Northeast</characteristic> 
  <characteristic>Single females</characteristic> 
  <characteristic>Single males</characteristic> 
  <characteristic>Wealthy retirees</characteristic> 
  </category>
- <category type="Transportation">
  <characteristic>Get to work by bus</characteristic> 
  <characteristic>Walk to work</characteristic> 
  </category>
  </uniqueness>
  </page>
  </pages>
  </response>
  </Demographics:demographics>
- <!--  H:14  T:75ms  S:17327  R:Mon Feb 09 20:10:55 PST 2009  B:3.0.62464-comp_rel_a 
  --> 

Select allOpen in new window

just do something like this


<img src="#mynewXML.SearchResults.response.results.result.charts.chart.url.xmltext#">

i didn't test the xml... the the idea will fit

i don't understand though how to get all the charts... There are 4 or more there all with the same node name.

<charts>
- <chart>
  <name>Average Condo Value</name> 
  <url>http://www.zillow.com/app?chartType=affordability_avgCondoValue&graphType=barChart&regionId=16037&regionType=6&service=chart</url> 
  </chart>
- <chart>
  <name>Average Home Value</name> 
  <url>http://www.zillow.com/app?chartType=affordability_avgHomeValue&graphType=barChart&regionId=16037&regionType=6&service=chart</url> 
  </chart>
- <chart>
  <name>Dollars Per Square Feet</name> 
  <url>http://www.zillow.com/app?chartType=affordability_pricePerSqft&graphType=barChart&regionId=16037&regionType=6&service=chart</url> 
  </chart>
- <chart>
  <name>Zindex Distribution</name> 
  <url>http://www.zillow.com/app?chartType=affordability_ZindexByDistribution&graphType=barChart&regionId=16037&regionType=6&service=chart</url> 
  </chart>
- <chart>
  <name>Home Type</name> 
  <url>http://www.zillow.com/app?chartType=home_homeType&graphType=barChart&regionId=16037&regionType=6&service=chart</url> 
  </chart>
- <chart>
  <name>Owners vs. Renters</name> 
  <url>http://www.zillow.com/app?chartType=home_ownVsRent&graphType=barChart&regionId=16037&regionType=6&service=chart</url> 
  </chart>
- <chart>
  <name>Home Size in Square Feet</name> 
  <url>http://www.zillow.com/app?chartType=home_homeSize&graphType=barChart&regionId=16037&regionType=6&service=chart</url> 
  </chart>
- <chart>
  <name>Year Built</name> 
  <url>http://www.zillow.com/app?chartType=home_yearBuilt&graphType=barChart&regionId=16037&regionType=6&service=chart</url> 
  </chart>
  </charts>

Select allOpen in new window

hmmmm
 An error occured while Parsing an XML document.
The reference to entity "graphType" must end with the ';' delimiter.
 

is graphtype a reserved word??

I don't know if this helps, but here is a CFDUMP of the feed to show it parsed.  As far as I know, graphtype is not reserved.

http://cfauthority.com/fc/feed/test.cfm

Also here is a link to the page for this demographic data:
http://www.zillow.com/howto/api/GetDemographics.htm

<img src="#Demographics.response.charts.chart.url# />

sorry..

try

<img src="#Demographics.response.charts.chart.url.xmltext# />

oh but you want to loop them... standby..

I don'tk know what it was, whatever you put, and then what I added made it all work. Now I get the idea.  


 

 
            #xmlData.Demographics.response.charts.chart[i].name.xmlText#"

     

cool, looks good.. what is cfauthority about?

I emailed you too at info@cfauthority.com
Andrew