4 Replies Latest reply on Mar 21, 2013 11:32 AM by sana.masroor

    API output in XML to display table in Tableau dashboard.

    sana.masroor

      I am using Zillow estimate calculator API to calculate Zestimates.

      http://www.zillow.com/howto/api/GetSearchResults.htm

       

      I call the API from URL Filter in my sheet like this:

       

      http://www.zillow.com/webservice/GetSearchResults.htm?zws-id=<MyZWSID>&address=<Subject_Property_Address>&citystatezip=<Subject_Property_City>+<Subject_Property_State>+<Subject_Property_Zip>

       

      As a result, I have an API output like below and I want to display this API output in my Tableau dashboard as a table. This means I have a
      sheet in my dashboard with a number of addresses. As soon as a user clicks an address, the table updates with Zillow estimates of that particular address.
      Any help on how to achieve this?

          

      <?xml version="1.0" encoding="utf-8" ?>

      <xsd:schema attributeFormDefault="unqualified"
      elementFormDefault="unqualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
      xmlns:ZillowTypes="http://www.zillow.com/vstatic/3/static/xsd/ZillowTypes.xsd"
      targetNamespace="http://www.zillow.com/vstatic/3/static/xsd/SearchResults.xsd">

      <xsd:import namespace="http://www.zillow.com/vstatic/3/static/xsd/ZillowTypes.xsd"
      />

      <xsd:element name="searchresults">

      <xsd:complexType>

      <xsd:sequence>

      <xsd:element name="request">

      <xsd:complexType>

      <xsd:sequence>

      <xsd:element name="address" type="xsd:string" />

      <xsd:element name="citystatezip" type="xsd:string"
      />

      </xsd:sequence

      </xsd:complexType>

      </xsd:element>

      <xsd:element name="message"
      type="ZillowTypes:Message" />

      <xsd:element minOccurs="0" name="response">

      <xsd:complexType>

      <xsd:sequence>

      <xsd:element name="results">

      <xsd:complexType>

      <xsd:sequence>

      <xsd:element minOccurs="1" maxOccurs="unbounded"
      name="result" type="ZillowTypes:SimpleProperty" />

      </xsd:sequence>

      </xsd:complexType>

      </xsd:element>

      </xsd:sequence>

      </xsd:complexType>

      </xsd:element>

      </xsd:sequence>

      </xsd:complexType>

      </xsd:element>

      </xsd:schema>

      Any help on this is highly appreciated.

             

      Thanks,