Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 353
  • Last Modified:

CFHTTP Get XML and Output Charts listed in Nodes

I have an XML feed and want to know how I can output the charts that are listed?  I have been using CFHTTP, XMLParse and XMLSearch and trying to loop through an array, but I keep getting no output.. Does anyone have any suggestions on how to get this group of charts.

Thank you!
<?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>

Open in new window

0
jeffmace
Asked:
jeffmace
  • 8
  • 5
1 Solution
 
Jones911Commented:
Show come of you code.  Also can you attache a complete block of the XML
0
 
jeffmaceAuthor Commented:
<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 
  --> 

Open in new window

0
 
Andrew MaurerCommented:
just do something like this


<img src="#mynewXML.SearchResults.response.results.result.charts.chart.url.xmltext#">
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
Andrew MaurerCommented:
i didn't test the xml... the the idea will fit
0
 
jeffmaceAuthor Commented:
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>

Open in new window

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

is graphtype a reserved word??
0
 
jeffmaceAuthor Commented:
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

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

0
 
Andrew MaurerCommented:

<img src="#Demographics.response.charts.chart.url# />
0
 
Andrew MaurerCommented:
sorry..

try

<img src="#Demographics.response.charts.chart.url.xmltext# />
0
 
Andrew MaurerCommented:
oh but you want to loop them... standby..
0
 
Andrew MaurerCommented:

<cfloop index="i" collection="#Demographics.response.charts.chart#">
      <img src="#Demographics.response.charts.chart[i].url# />
</cfloop>

i think

sorry, kinda in a rush
0
 
jeffmaceAuthor Commented:
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#"

     


0
 
Andrew MaurerCommented:
cool, looks good.. what is cfauthority about?

I emailed you too at info@cfauthority.com
Andrew
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 8
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now