How to parse GetSOAPRequest result

[Eymard]

Hi,

Can someone help me, how can I parse the following GetSOAPRequest result? The following xml is the sample that I am trying to parse. Thank you.

<?xml version="1.0" encoding="UTF-8"?>
<soap:Envelope xmlns:soap=" http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<getCountriesListResponse xmlns=" http://www.voxbone.com/VoxService">
<countries>
<ns1:Country xmlns:ns1=" http://containers.services.webservices.voxbone">
<availableDidsCount xmlns=" http://containers.services.webservices.voxbone">79</availableDidsCount>
<countryCodeA2 xmlns=" http://containers.services.webservices.voxbone">AR</countryCodeA2>
<countryName xmlns=" http://containers.services.webservices.voxbone">ARGENTINA</countryName>
<countryPhoneCode xmlns=" http://containers.services.webservices.voxbone">54</countryPhoneCode>
</ns1:Country>
<ns1:Country xmlns:ns1=" http://containers.services.webservices.voxbone">
<availableDidsCount xmlns=" http://containers.services.webservices.voxbone">73</availableDidsCount>
<countryCodeA2 xmlns=" http://containers.services.webservices.voxbone">BR</countryCodeA2>
<countryName xmlns=" http://containers.services.webservices.voxbone">BRAZIL</countryName>
<countryPhoneCode xmlns=" http://containers.services.webservices.voxbone">55</countryPhoneCode>
</ns1:Country>
</countries>
</getCountriesListResponse>
</soap:Body>

[MikerRoo]

That's not a valid soap request.

It's missing </soap:Envelope> at the end.

[Eymard]

Here's my code to pull the GetSOAPRequest result. I want to display it by: ie. Country Name, Country code & etc. But it is difficult to do an xmlparse due to ie "soap:Envelope" notation. Appreciate it if somebody could help me show how to parse a GetSOAPRequest result.

Thanks a lot!

<cfscript>
ws = CreateObject("webservice", " http://www.voxbone.com/ws/services/VoxService?wsdl");
ret = ws.GetCountriesList(args);

</cfscript>

<cfset outxml = GetSOAPResponse(ws)>
<h2>SOAP Response</h2>
<cfoutput>#outxml#</cfoutput>
<cfdump var="#outxml#">

[MikerRoo]

XmlSearch() is about useless with ¿non standard? name spaces.

Anyway, does the attached code get you started?

[Eymard]

Mike,

I tried parsing it using xmlparse and xmlsearch but it wasn't friendly anymore. I tried your code and it give me an error:

seems that it can't read this line. "outxml["soap:Envelope"]["soap:Body"].getCountriesListResponse.countries.XmlChildren;"

I'm new to this and I googled it but can't see solutions for this soap parsing.

The sequence of the notation is exactly the same as the soap response. Any other trick?

Thank you

[MikerRoo]

That parse code works on the XML you supplied above.

Please run the following code and attach the results here:

<CFSCRIPT>
ws = CreateObject ("webservice", " http://www.voxbone.com/ws/services/VoxService?wsdl");
ret = ws.GetCountriesList (args);

outxml = GetSOAPResponse (ws);
// aCountries = outxml["soap:Envelope"]["soap:Body"].getCountriesListResponse.countries.XmlChildren;
</CFSCRIPT>
<CFDUMP var="#ret#">
<CFDUMP var="#outxml#">

[Eymard]

Hi,

The code was too long to attach here. Here's a link below to show the SOAP dump results at

http://melo3.melotec.com:60/voxbone.cfm

<CFSCRIPT>
ws = CreateObject ("webservice", " http://www.voxbone.com/ws/services/VoxService?wsdl");
ret = ws.GetCountriesList (args);

outxml = GetSOAPResponse (ws);
// aCountries = outxml["soap:Envelope"]["soap:Body"].getCountriesListResponse.countries.XmlChildren;
</CFSCRIPT>
<CFDUMP var="#ret#">
<CFDUMP var="#outxml#">

[Eymard · Accepted solution]

Hi Mike,

I had it working with this code snippet.

<cfset xmlContainer = Xmlparse(outxml)>
<cfset aCountries = xmlContainer["soap:Envelope"]["soap:Body"].getCountriesListResponse.countries.XmlChildren>

Thank you very much!