FOXPRO: get data from browser returned XML into a table

Explore the STREXTRACT() function, this might get you what you need.

If you want to convert an XML to a cursor, use the function XMLTOCURSOR

I appreciate the replies but what I need is a sample code snipit.  How do I access the browser text?  Imagine a browser display of a pure XML because that is what I have.  I create a browser object, give it a url with parameters and get back XML; but how do I access the XML from the browser object?  This is probably VERY VERY trivial but I'm just not getting it.

Code might look like this:

Create browser object
browserobject.url_string_with parameters
browserobject.execute

var = xml_to_data(browserobject.result_page_text)

I don't know . . . .

What does
browserobject.Document.firstchild.innerHtml
or
browserobject.Document.firstchild.innerText
give you ?

Dealing with XML depends on how it is arranged.

Show us a sample of the web page source.

Here is what I see.  I want the contact information' address and phone.  There may be more than one value returned as in any ambiguous auery,

  <?xml version="1.0" encoding="UTF-8" ?>
- <wp:wp xmlns:wp="http://api.whitepages.com/schema/">
  <wp:result wp:type="success" wp:message="" wp:code="Found Data" />
- <wp:meta>
  <wp:linkexpiration>2008-11-26</wp:linkexpiration>
  <wp:recordrange wp:lastrecord="2" wp:firstrecord="1" wp:totalavailable="2" />
  <wp:apiversion>1.0</wp:apiversion>
- <wp:searchlinks>
  <wp:link wp:linktext="Whitepages.com" wp:type="homepage">http://www.whitepages.com/16176/</wp:link>
  <wp:link wp:linktext="Link to this api call" wp:type="self">http://api.whitepages.com/find_person/1.0/?firstname=Gene;lastname=Head;name=Gene+Head;street=22344+SW+Main+St;city=Sherwood;state=OR;api_key=a087e4d4407878265d7c57a739bf5049</wp:link>
  <wp:link wp:linktext="View All Results" wp:type="allresults">http://www.whitepages.com/16176/track/10211/log_feature/listing_category/search/Replay/?search_id=64211301729610712863</wp:link>
  <wp:link wp:linktext="View Work Listings" wp:type="worklistings">http://www.whitepages.com/16176/track/10209/log_feature/listing_category/search/Replay/?search_id=64211301729610712863&view=&listing_category=B</wp:link>
  </wp:searchlinks>
  </wp:meta>
- <wp:listings>
- <wp:listing>
- <wp:people>
- <wp:person wp:rank="primary">
  <wp:firstname>Gene</wp:firstname>
  <wp:middlename>R</wp:middlename>
  <wp:lastname>Head</wp:lastname>
  </wp:person>
- <wp:person wp:rank="secondary">
  <wp:firstname>Jacqueline</wp:firstname>
  <wp:middlename>J</wp:middlename>
  <wp:lastname>Head</wp:lastname>
  </wp:person>
  </wp:people>
- <wp:phonenumbers>
- <wp:phone wp:type="home" wp:rank="primary">
  <wp:fullphone>(503) 625-1768</wp:fullphone>
  <wp:areacode>503</wp:areacode>
  <wp:exchange>625</wp:exchange>
  <wp:linenumber>1768</wp:linenumber>
  </wp:phone>
  </wp:phonenumbers>
- <wp:address wp:deliverable="true">
  <wp:fullstreet>22344 SW Main St</wp:fullstreet>
  <wp:house>22344</wp:house>
  <wp:predir>SW</wp:predir>
  <wp:street>SW Main St</wp:street>
  <wp:streettype>St</wp:streettype>
  <wp:city>Sherwood</wp:city>
  <wp:state>OR</wp:state>
  <wp:zip>97140</wp:zip>
  <wp:zip4>9416</wp:zip4>
  <wp:country>US</wp:country>
  </wp:address>
- <wp:geodata>
  <wp:geoprecision>5</wp:geoprecision>
  <wp:latitude>45.354570</wp:latitude>
  <wp:longitude>-122.864160</wp:longitude>
  </wp:geodata>
- <wp:listingmeta>
  <wp:lastvalidated>03/2008</wp:lastvalidated>
  <wp:type>home</wp:type>
- <wp:moreinfolinks>
  <wp:link wp:linktext="Find Neighbors" wp:type="findneighbors">http://www.whitepages.com/16176/track/10214/search/FindNeighbors?addr_research=1&tmpl=search_research_neighbors&search_id=64211301729610712863&rarl=&element_id=0</wp:link>
  <wp:link wp:linktext="View Map" wp:type="viewmap">http://www.whitepages.com/16176/track/10213/map_provider?full_address=22344+SW+Main+St&city=Sherwood&state=OR&zip=97140&country=US&lat=45.354570&long=-122.864160&name=Head&firstname=Gene+R&show_form=false</wp:link>
  <wp:link wp:linktext="Driving Directions" wp:type="drivingdirections">http://www.whitepages.com/16176/track/10216/map_provider?=&show_form=true&full_address=22344+SW+Main+St&city=Sherwood&state=OR&zip=97140&country=US&lat=45.354570&long=-122.864160&name=Head&firstname=Gene+R</wp:link>
  <wp:link wp:linktext="View Listing Detail" wp:type="viewdetails">http://www.whitepages.com/16176/track/10215/search/Replay?search_id=64211301729610712863&lower=1&more_info=1</wp:link>
  </wp:moreinfolinks>
  </wp:listingmeta>
  </wp:listing>
- <wp:listing>
- <wp:people>
- <wp:person wp:rank="primary">
  <wp:firstname>Gene</wp:firstname>
  <wp:lastname>Head</wp:lastname>
  </wp:person>
  </wp:people>
- <wp:business wp:rank="primary">
  <wp:businessname>Liftedup</wp:businessname>
  </wp:business>
- <wp:phonenumbers>
- <wp:phone wp:type="work" wp:rank="primary">
  <wp:fullphone>(503) 799-5381</wp:fullphone>
  <wp:areacode>503</wp:areacode>
  <wp:exchange>799</wp:exchange>
  <wp:linenumber>5381</wp:linenumber>
  </wp:phone>
  </wp:phonenumbers>
- <wp:address wp:deliverable="true">
  <wp:fullstreet>22344 SW Main St</wp:fullstreet>
  <wp:house>22344</wp:house>
  <wp:predir>SW</wp:predir>
  <wp:street>SW Main St</wp:street>
  <wp:streettype>St</wp:streettype>
  <wp:city>Sherwood</wp:city>
  <wp:state>OR</wp:state>
  <wp:zip>97140</wp:zip>
  <wp:zip4>9416</wp:zip4>
  <wp:country>US</wp:country>
  </wp:address>
- <wp:geodata>
  <wp:geoprecision>5</wp:geoprecision>
  <wp:latitude>45.354570</wp:latitude>
  <wp:longitude>-122.864160</wp:longitude>
  </wp:geodata>
- <wp:listingmeta>
  <wp:lastvalidated>02/2008</wp:lastvalidated>
  <wp:type>work</wp:type>
- <wp:moreinfolinks>
  <wp:link wp:linktext="Find Neighbors" wp:type="findneighbors">http://www.whitepages.com/16176/track/10214/search/FindNeighbors?addr_research=1&tmpl=search_research_neighbors&search_id=64211301729610712863&rarl=&element_id=1</wp:link>
  <wp:link wp:linktext="View Map" wp:type="viewmap">http://www.whitepages.com/16176/track/10213/map_provider?full_address=22344+SW+Main+St&city=Sherwood&state=OR&zip=97140&country=US&lat=45.354570&long=-122.864160&name=Head&firstname=Gene&show_form=false</wp:link>
  <wp:link wp:linktext="Driving Directions" wp:type="drivingdirections">http://www.whitepages.com/16176/track/10216/map_provider?=&show_form=true&full_address=22344+SW+Main+St&city=Sherwood&state=OR&zip=97140&country=US&lat=45.354570&long=-122.864160&name=Head&firstname=Gene</wp:link>
  <wp:link wp:linktext="View Listing Detail" wp:type="viewdetails">http://www.whitepages.com/16176/track/10215/search/Replay?search_id=64211301729610712863&lower=2&more_info=1</wp:link>
  </wp:moreinfolinks>
  </wp:listingmeta>
  </wp:listing>
  </wp:listings>
  </wp:wp>

you would not use a browser object for that, but an XMLRequest. Also take a look at the vfp help topics on wb services, soap and the soap toolkit.

I found that whitepages.com offers an XSD schema you can use to parse their XML results: http://developer.whitepages.com/docs/XSD

Save this xsd as an xsd file. Take a look at the XMLAdapter class, you can set it's XMLSchemalocation to the xsd file and it will use the xsd schema for validating the xml, when you use the LoadXML method and pass on the xml you get by the xmlrequest.

Bye, Olaf.

Local lcXML, loXMLRequest
loXMLRequest = CreateObject("msxml2.xmlhttp")
loXMLRequest.open("GET",cSomeWhitepagesURL,.F.)
loXMLRequest.send(.null.)
lcXML = o.responseXML
                                              

1:
2:
3:
4:
5:

edit the last line of my code snippet to

lcXML = loXMLRequest.responseXML

                                              

1:

Olaf's reply looks like what I need - THANKS.  Let me test it and I'll award the points.

Thanks to all who commented.

gene

Thanks