SOAP + https + user authentication...possible?

You must Login before you can answer or comment on any questions.

I have a project I'm working on for someone, and this is the last step. I've looked at the kitchen sink and have the SOAP working from that example. However, for my project, my client has a service that 1) is only accessible via https, and 2) has a username and password. Is this possible in Appcelerator, and if so, how would I change the KitchenSink example?

6 Answers

How is it a bad idea if its sending it across an https-only connection?

— answered 3 years ago by Josh Lewis
answer permalink
1 Comment
  • That protects it in transit, but anyone that can get their hands on your program can unpack it and get the credentials to the SOAP service out of it.

    If you trust the users of your app with the password to the SOAP service, then SSL will be all you need. But if people you do not trust can get the application on their device and it has the credentials hard coded in it, then you've compromised the data in the SOAP service.

    — commented 3 years ago by Todd Wade

Well, lets assume that I'm not worried about the app getting hacked. Where would I go about with an HTTPS/user authenticated SOAP service?

— answered 3 years ago by Josh Lewis
answer permalink
1 Comment
  • Are you talking http BASIC auth here, or auth that goes in the SOAP request? Did you look in suds.js? Its a pretty simple program, should be easy to modify to your needs.

    — commented 3 years ago by Todd Wade

Here is the link I'm provided, and when you open it in a browser it asks for a user/pass.

https://extdata.uspta.com/iphonefap/fapwebsvc.asmx

— answered 3 years ago by Josh Lewis
answer permalink
1 Comment
  • Hi,

    DId you ever solve this? (the following comments appear to be moving onto a different issue).

    I am using suds.js, and I have

    var suds = new SudsClient({ endpoint: url, targetNamespace: nameSpace, authorization: authString });

    But I can't find the right format for authString, I have tried lots of variations e.g username:password@domain:port but none of them work

    — commented 2 years ago by Paul Parton

Here is the xml that I'm SUPPOSED to get. Any idea how I can get one element by adapting the soap/suds form kitchen sink? My XML isn't the greatest, so I'm not sure if I'm grabbing the right hiearchy or not.

Here is the KS code, and below is the xml that the service should be sending back.

try {
    suds.invoke('SearchByZipCode', callparams, function(xmlDoc) {
        var results = xmlDoc.documentElement.getElementsByTagName('sp_uspta_SearchZipCode');
       // alert(results);
        if (results && results.length>0) {
            var result = results.item(0);
            label.text = '1 Euro buys you ' + results.item(0).text + ' U.S. Dollars.';
        } else {
            label.text = 'Oops, could not determine result of SOAP call.';
        }
    });
} catch(e) {
    Ti.API.error('Error: ' + e);
}

— answered 3 years ago by Josh Lewis
answer permalink
2 Comments
  • You need to do something like this to pick out the data:

    var nameS = results.getElementsByTagName('name');
    var addresseS = results.getElementsByTagName('address');
     
    for (var i = 0; i < results.length; i++) {
      var name = nameS.getElement(i).text();
      var address = addresseS.getElement(i).text();
     
      // Do something with that set of data e.g. 
      var user = new User(name, address);
     
      userGroup.push(user);
    }
    The getElementByTagName and getElement may not be the correct calls but they are almost correct... cant remember the exact syntax.

    Also I would recomment you add this to your Syds.js after or before the onload call:

    suds.onerror(_callback, null);
    then add to the suds call in your other js file:
    if (xmlDoc != null) {
      // Your code for parsing the suds response.
    } else {
      // There was an error...
    }
    Again the syntax for the suds.js file is probably not correct but you can look those specific calls up in 2 mins.

    Hope it helps.

    — commented 3 years ago by James Adams

  • Well, that doesnt really help. I've used modified KS code (rss.js) for another app and understand the getElementsByTagName...my problem is with the specific XML response I posted, I dont know how to drill down to say the first example, ID.

    — commented 3 years ago by Josh Lewis

hmm,my xml didnt post...

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

&lt;DocumentElement &gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode1&quot; msdata:rowOrder=&quot;0&quot;&gt;
    &lt;ID&gt;56593&lt;/ID&gt;
    &lt;Last_Name&gt;Nzewi&lt;/Last_Name&gt;
    &lt;First_Name&gt;Temituoyo&lt;/First_Name&gt;
    &lt;Address_1&gt;10375 Richmond Ave Ste 950&lt;/Address_1&gt;
    &lt;Address_2&gt;Ciscon Inc.&lt;/Address_2&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77042-4124&lt;/Zip&gt;
    &lt;Phone&gt;(281) 449-5512&lt;/Phone&gt;
    &lt;Website&gt;http://temituoyonzewi.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;0&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode2&quot; msdata:rowOrder=&quot;1&quot;&gt;
    &lt;ID&gt;6688&lt;/ID&gt;
    &lt;Last_Name&gt;Blume&lt;/Last_Name&gt;
    &lt;First_Name&gt;Bradley&lt;/First_Name&gt;
    &lt;Address_1&gt;11022 Westheimer Rd&lt;/Address_1&gt;
    &lt;Address_2&gt;Tennis Express&lt;/Address_2&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77042-3206&lt;/Zip&gt;
    &lt;Phone&gt;(713) 781-4848&lt;/Phone&gt;
    &lt;Website&gt;http://bradleyblume.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;0&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode3&quot; msdata:rowOrder=&quot;2&quot;&gt;
    &lt;ID&gt;24004&lt;/ID&gt;
    &lt;Last_Name&gt;Bucic&lt;/Last_Name&gt;
    &lt;First_Name&gt;Scott&lt;/First_Name&gt;
    &lt;Address_1&gt;3535 Briarpark Dr Ste 1&lt;/Address_1&gt;
    &lt;Address_2 /&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77042-5233&lt;/Zip&gt;
    &lt;Phone&gt;(713) 978-7782&lt;/Phone&gt;
    &lt;Website&gt;http://scottbucic.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;0&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode4&quot; msdata:rowOrder=&quot;3&quot;&gt;
    &lt;ID&gt;2254&lt;/ID&gt;
    &lt;Last_Name&gt;Fanning&lt;/Last_Name&gt;
    &lt;First_Name&gt;Rich&lt;/First_Name&gt;
    &lt;Address_1&gt;3535 Briarpark Dr Ste 1&lt;/Address_1&gt;
    &lt;Address_2 /&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77042-5233&lt;/Zip&gt;
    &lt;Phone&gt;(713) 978-7782&lt;/Phone&gt;
    &lt;Website&gt;http://rfanning.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;0&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode5&quot; msdata:rowOrder=&quot;4&quot;&gt;
    &lt;ID&gt;1003&lt;/ID&gt;
    &lt;Last_Name&gt;Heckler&lt;/Last_Name&gt;
    &lt;First_Name&gt;Tim&lt;/First_Name&gt;
    &lt;Address_1&gt;3535 Briarpark Dr Ste 1&lt;/Address_1&gt;
    &lt;Address_2 /&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77042-5233&lt;/Zip&gt;
    &lt;Phone&gt;(713) 978-7782&lt;/Phone&gt;
    &lt;Website&gt;http://heckler.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;0&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode6&quot; msdata:rowOrder=&quot;5&quot;&gt;
    &lt;ID&gt;53825&lt;/ID&gt;
    &lt;Last_Name&gt;Husaru&lt;/Last_Name&gt;
    &lt;First_Name&gt;Laura&lt;/First_Name&gt;
    &lt;Address_1&gt;3535 Briarpark Dr Ste 1&lt;/Address_1&gt;
    &lt;Address_2 /&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77042-5233&lt;/Zip&gt;
    &lt;Phone&gt;713-978-7782&lt;/Phone&gt;
    &lt;Website&gt;http://ramonahusaru.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;0&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode7&quot; msdata:rowOrder=&quot;6&quot;&gt;
    &lt;ID&gt;6202&lt;/ID&gt;
    &lt;Last_Name&gt;Viancos&lt;/Last_Name&gt;
    &lt;First_Name&gt;Fred&lt;/First_Name&gt;
    &lt;Address_1&gt;3535 Briarpark Dr Ste 1&lt;/Address_1&gt;
    &lt;Address_2 /&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77042-5233&lt;/Zip&gt;
    &lt;Phone&gt;(713) 978-7782&lt;/Phone&gt;
    &lt;Website&gt;http://viancos.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;0&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode8&quot; msdata:rowOrder=&quot;7&quot;&gt;
    &lt;ID&gt;22872&lt;/ID&gt;
    &lt;Last_Name&gt;Goldstraw&lt;/Last_Name&gt;
    &lt;First_Name&gt;Ralph&lt;/First_Name&gt;
    &lt;Address_1&gt;2222 Westerland Dr Apt 168&lt;/Address_1&gt;
    &lt;Address_2 /&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77063-2292&lt;/Zip&gt;
    &lt;Phone /&gt;
    &lt;Website&gt;http://ralphgoldstraw.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;2.0929209186947961&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode9&quot; msdata:rowOrder=&quot;8&quot;&gt;
    &lt;ID&gt;22630&lt;/ID&gt;
    &lt;Last_Name&gt;Park&lt;/Last_Name&gt;
    &lt;First_Name&gt;Lawton&lt;/First_Name&gt;
    &lt;Address_1&gt;14435 Briarhills Pkwy&lt;/Address_1&gt;
    &lt;Address_2 /&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77077-1009&lt;/Zip&gt;
    &lt;Phone&gt;(713) 557-5551&lt;/Phone&gt;
    &lt;Website&gt;http://lawtonpark.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;3.2380266087295131&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode10&quot; msdata:rowOrder=&quot;9&quot;&gt;
    &lt;ID&gt;27883&lt;/ID&gt;
    &lt;Last_Name&gt;Ohmer&lt;/Last_Name&gt;
    &lt;First_Name&gt;Justine&lt;/First_Name&gt;
    &lt;Address_1&gt;14619 Carolcrest St&lt;/Address_1&gt;
    &lt;Address_2 /&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77079-6405&lt;/Zip&gt;
    &lt;Phone&gt;(713) 252-4822&lt;/Phone&gt;
    &lt;Website&gt;http://justineohmer.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;3.5121616796111885&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode11&quot; msdata:rowOrder=&quot;10&quot;&gt;
    &lt;ID&gt;19723&lt;/ID&gt;
    &lt;Last_Name&gt;Bush&lt;/Last_Name&gt;
    &lt;First_Name&gt;George&lt;/First_Name&gt;
    &lt;Address_1&gt;10000 Memorial Dr Ste 900&lt;/Address_1&gt;
    &lt;Address_2 /&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77024-3412&lt;/Zip&gt;
    &lt;Phone /&gt;
    &lt;Website&gt;http://georgebush.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;3.8197804638621653&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode12&quot; msdata:rowOrder=&quot;11&quot;&gt;
    &lt;ID&gt;26087&lt;/ID&gt;
    &lt;Last_Name&gt;May&lt;/Last_Name&gt;
    &lt;First_Name&gt;Mike&lt;/First_Name&gt;
    &lt;Address_1&gt;111 N Post Oak Ln&lt;/Address_1&gt;
    &lt;Address_2 /&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77024-7703&lt;/Zip&gt;
    &lt;Phone&gt;(713) 685-6847&lt;/Phone&gt;
    &lt;Website&gt;http://mikemay.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;3.8197804638621653&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode13&quot; msdata:rowOrder=&quot;12&quot;&gt;
    &lt;ID&gt;746&lt;/ID&gt;
    &lt;Last_Name&gt;Giammalva&lt;/Last_Name&gt;
    &lt;First_Name&gt;Sam&lt;/First_Name&gt;
    &lt;Address_1&gt;226 Tamerlaine Dr&lt;/Address_1&gt;
    &lt;Address_2 /&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77024-6118&lt;/Zip&gt;
    &lt;Phone /&gt;
    &lt;Website&gt;http://samgiammalva.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;3.8197804638621653&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode14&quot; msdata:rowOrder=&quot;13&quot;&gt;
    &lt;ID&gt;60254&lt;/ID&gt;
    &lt;Last_Name&gt;Bishop&lt;/Last_Name&gt;
    &lt;First_Name&gt;William&lt;/First_Name&gt;
    &lt;Address_1&gt;359 Tealwood Dr&lt;/Address_1&gt;
    &lt;Address_2 /&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77024-6133&lt;/Zip&gt;
    &lt;Phone /&gt;
    &lt;Website&gt;http://williambishop.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;3.8197804638621653&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode15&quot; msdata:rowOrder=&quot;14&quot;&gt;
    &lt;ID&gt;6687&lt;/ID&gt;
    &lt;Last_Name&gt;Ayala&lt;/Last_Name&gt;
    &lt;First_Name&gt;Juan&lt;/First_Name&gt;
    &lt;Address_1&gt;9950 Memorial Dr&lt;/Address_1&gt;
    &lt;Address_2&gt;The Forest Club&lt;/Address_2&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77024-3402&lt;/Zip&gt;
    &lt;Phone&gt;(713) 686-3720&lt;/Phone&gt;
    &lt;Website&gt;http://juanayala.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;3.8197804638621653&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode16&quot; msdata:rowOrder=&quot;15&quot;&gt;
    &lt;ID&gt;14608&lt;/ID&gt;
    &lt;Last_Name&gt;Morehouse&lt;/Last_Name&gt;
    &lt;First_Name&gt;Christopher&lt;/First_Name&gt;
    &lt;Address_1&gt;Houstonian Hotel, Club &amp;amp; Spa&lt;/Address_1&gt;
    &lt;Address_2&gt;111 N Post Oak Ln&lt;/Address_2&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77024-7703&lt;/Zip&gt;
    &lt;Phone&gt;(713) 685-6847&lt;/Phone&gt;
    &lt;Website&gt;http://christophermorehouse.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;3.8197804638621653&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode17&quot; msdata:rowOrder=&quot;16&quot;&gt;
    &lt;ID&gt;2928&lt;/ID&gt;
    &lt;Last_Name&gt;Ladig&lt;/Last_Name&gt;
    &lt;First_Name&gt;Debbie&lt;/First_Name&gt;
    &lt;Address_1&gt;The Houstonian&lt;/Address_1&gt;
    &lt;Address_2&gt;111 N Post Oak Ln&lt;/Address_2&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77024-7703&lt;/Zip&gt;
    &lt;Phone /&gt;
    &lt;Website&gt;http://debbieladig.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;3.8197804638621653&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode18&quot; msdata:rowOrder=&quot;17&quot;&gt;
    &lt;ID&gt;15149&lt;/ID&gt;
    &lt;Last_Name&gt;Shaw&lt;/Last_Name&gt;
    &lt;First_Name&gt;Ross&lt;/First_Name&gt;
    &lt;Address_1&gt;8215 Carvel Ln&lt;/Address_1&gt;
    &lt;Address_2 /&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77036-6319&lt;/Zip&gt;
    &lt;Phone /&gt;
    &lt;Website&gt;http://rossshaw.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;3.91341671310795&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode19&quot; msdata:rowOrder=&quot;18&quot;&gt;
    &lt;ID&gt;29123&lt;/ID&gt;
    &lt;Last_Name&gt;Kenny&lt;/Last_Name&gt;
    &lt;First_Name&gt;Chuck&lt;/First_Name&gt;
    &lt;Address_1&gt;8900 Bellaire Blvd&lt;/Address_1&gt;
    &lt;Address_2&gt;Strake Jesuit College Preparatory&lt;/Address_2&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77036-4610&lt;/Zip&gt;
    &lt;Phone&gt;(713) 490-8261&lt;/Phone&gt;
    &lt;Website&gt;http://chuckkenny.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;3.91341671310795&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode20&quot; msdata:rowOrder=&quot;19&quot;&gt;
    &lt;ID&gt;21909&lt;/ID&gt;
    &lt;Last_Name&gt;Lui&lt;/Last_Name&gt;
    &lt;First_Name&gt;Alfred&lt;/First_Name&gt;
    &lt;Address_1&gt;Lee LeClear Tennis Center&lt;/Address_1&gt;
    &lt;Address_2&gt;9506 S Gessner&lt;/Address_2&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77074-3814&lt;/Zip&gt;
    &lt;Phone&gt;(713) 272-3697&lt;/Phone&gt;
    &lt;Website&gt;http://alfredlui.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;4.1093554124039162&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode21&quot; msdata:rowOrder=&quot;20&quot;&gt;
    &lt;ID&gt;20111&lt;/ID&gt;
    &lt;Last_Name&gt;Derby&lt;/Last_Name&gt;
    &lt;First_Name&gt;Michael&lt;/First_Name&gt;
    &lt;Address_1&gt;1 Potomac Dr&lt;/Address_1&gt;
    &lt;Address_2&gt;Houston Country Club&lt;/Address_2&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77057-1207&lt;/Zip&gt;
    &lt;Phone /&gt;
    &lt;Website&gt;http://michaelderby.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;4.22819965664966&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode22&quot; msdata:rowOrder=&quot;21&quot;&gt;
    &lt;ID&gt;28192&lt;/ID&gt;
    &lt;Last_Name&gt;Hobson&lt;/Last_Name&gt;
    &lt;First_Name&gt;John&lt;/First_Name&gt;
    &lt;Address_1&gt;1811 Fountain View Dr Apt 54&lt;/Address_1&gt;
    &lt;Address_2 /&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77057-3044&lt;/Zip&gt;
    &lt;Phone /&gt;
    &lt;Website&gt;http://johnhobson.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;4.22819965664966&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode23&quot; msdata:rowOrder=&quot;22&quot;&gt;
    &lt;ID&gt;24859&lt;/ID&gt;
    &lt;Last_Name&gt;Fernandez-Wynter&lt;/Last_Name&gt;
    &lt;First_Name&gt;Javier&lt;/First_Name&gt;
    &lt;Address_1&gt;2426 S Voss Rd&lt;/Address_1&gt;
    &lt;Address_2&gt;Oakwood International Tennis&lt;/Address_2&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77057-&lt;/Zip&gt;
    &lt;Phone&gt;(832) 455-9238&lt;/Phone&gt;
    &lt;Website&gt;http://javierfernandezwynte.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;4.22819965664966&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode24&quot; msdata:rowOrder=&quot;23&quot;&gt;
    &lt;ID&gt;21161&lt;/ID&gt;
    &lt;Last_Name&gt;Adams&lt;/Last_Name&gt;
    &lt;First_Name&gt;James&lt;/First_Name&gt;
    &lt;Address_1&gt;5868 Westheimer Rd # 461&lt;/Address_1&gt;
    &lt;Address_2 /&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77057-5641&lt;/Zip&gt;
    &lt;Phone /&gt;
    &lt;Website&gt;http://jimadams.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;4.22819965664966&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
  &lt;sp_uspta_SearchZipCode diffgr:id=&quot;sp_uspta_SearchZipCode25&quot; msdata:rowOrder=&quot;24&quot;&gt;
    &lt;ID&gt;4130&lt;/ID&gt;
    &lt;Last_Name&gt;Maxa&lt;/Last_Name&gt;
    &lt;First_Name&gt;Don&lt;/First_Name&gt;
    &lt;Address_1&gt;12327 Shadowhollow Dr&lt;/Address_1&gt;
    &lt;Address_2 /&gt;
    &lt;City&gt;Houston&lt;/City&gt;
    &lt;State_Province&gt;TX&lt;/State_Province&gt;
    &lt;Zip&gt;77082-2391&lt;/Zip&gt;
    &lt;Phone /&gt;
    &lt;Website&gt;http://donmaxa.usptapro.com&lt;/Website&gt;
    &lt;Distance&gt;4.6767315005222958&lt;/Distance&gt;
  &lt;/sp_uspta_SearchZipCode&gt;
&lt;/DocumentElement&gt;

</sp_uspta_SearchZipCodeDataTable>

Your Answer

Think you can help? Login to answer this question!