How to parse returned XML from SOAP request - jQuery

Question

I haven't dealt with xml in this format before, w/no tag name. There may be more or less nodes returned, so I can't count them. There may be one or two after, so I can't count from end. I need to find the who's value is result. From there find the 's text.

The returned data is this:

<pre><?xml version="1.0" encoding="utf-8"?>
    <soapenv:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
    <ns1:demosetupResponse soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1="http://tempuri.org/">
    <demosetupReturn xmlns:ns2="http://xml.apache.org/xml-soap" xsi:type="ns2:Map">
    <item xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
      <key xsi:type="soapenc:string">DemoUName</key>
      <value xsi:type="soapenc:string"></value>
    </item>
    <item xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
      <key xsi:type="soapenc:string">DemoPass</key>
      <value xsi:type="soapenc:string"></value>
    </item>
    <item xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
      <key xsi:type="soapenc:string">FutAcct</key>
      <value xsi:type="soapenc:string"></value>
    </item>
    <item xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
      <key xsi:type="soapenc:string">FxAcct</key>
      <value xsi:type="soapenc:string"></value>
    </item>
    <item xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
      <key xsi:type="soapenc:string">UUID</key>
      <value xsi:type="soapenc:string"></value>
    </item>
    <item xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
      <key xsi:type="soapenc:string">Result</key>
      <value xsi:type="soapenc:string">Error: Duplicate user account!</value>
    </item>
  </demosetupReturn>
</ns1:demosetupResponse>

Relevant part of my PHP cURL script:

f(curl_exec($soap_do) === false) {
        $err = 'Curl error: ' . curl_error($soap_do);
        curl_close($soap_do);
        print $err;
    } else {
        $result = curl_exec($soap_do);
        echo '<pre>';
        print_r($result);
        // print_r($xml_post_string);
    }
    curl_close($soap_do);

I can't get "(key).val('Result').next(value).text()" to do anything — Dirty Bird Design
– Dirty Bird Design, Commented Mar 21, 2018 at 20:45

Nigel Ren · Accepted Answer · 2018-03-21 21:12:48Z

1

You can use XPath to extract the main body of the SOAP message ( I think in this case it is the <demosetupReturn xml... element. And then use SimpleXML to iterate over the <item> elements and create an output array of the key/value pairs.

$xml = simplexml_load_string($result);
$body = $xml->xpath("//soapenv:Body//demosetupReturn")[0];
$output = [];
foreach ( $body as $item)  {
    $output[(string)$item->key] = (string)$item->value;
}
print_r($output);

edited Mar 21, 2018 at 21:12

answered Mar 21, 2018 at 20:38

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

Anthony Over a year ago

I don't think they're using php.

Dirty Bird Design Over a year ago

Updated question to show my PHP output. Is it better to do it in the PHP vs JS?

Anthony Over a year ago

If you're retrieving it with curl in php, then it would be better to parse it in php.

Dirty Bird Design Over a year ago

I have yet to get that working... any help is appreciated

Anthony Over a year ago

Is there any reason you are using curl and not SOAPClient?

|

Collectives™ on Stack Overflow

How to parse returned XML from SOAP request - jQuery

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related