How to convert SOAP response to XML or JSON format?

Question

<soapenv:envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
    <soapenv:body>
        <ns1:mbillcommandresponse xmlns:ns1="http://www.mysoap.com/SoapService/">
            <ReturnValues>
                <name>status</name>
                <value>TEHNICAL_ERROR</value>
            </ReturnValues>
            <ReturnValues>
                <name>description</name>
                <value>Please contact your administrator</value>
            </ReturnValues>
        </ns1:mbillcommandresponse>
    </soapenv:body>
</soapenv:envelope>

Above I got response in my CURL response. Here is my PHP code:

    $response = curl_exec($ch);
    $xml = simplexml_load_string($response);
    //$result = $xml->xpath('//name'); //echo "<pre>"; print_r($result); exit;
    $xml->registerXPathNamespace('ns1', 'http://www.mysoap.com/SoapService/');
    foreach ($xml->xpath('//returnvalues') as $item) {
        $json = json_encode($item);
        $convrt_arr = json_decode($json, true);
        break;
    }
    print_r($json); exit;

On my above code I got empty json. Could you please help me.

*btw* Soap is an XML format, but here are special libraries like [ext/soap](http://php.net/manual/de/book.soap.php) to handle it. — ThW, Jun 29 '18 at 20:37
Cannot reproduce the problem. It prints `{"name":"status","value":"TEHNICAL_ERROR"}` on my machine. — Marco, Jun 30 '18 at 08:13
@SupunPraneeth I have posted my SOAP response data. You could check there my `returnvalues` data — Chinmay235, Jun 30 '18 at 13:42
Why not use standard SoapClient instead of CURL? That way you can convert the answer directly to PHP objects (given you provide mappings for the types). Having an address of SOAP web service you can get all the necessary work done for you by libraries like https://github.com/wsdl2phpgenerator/wsdl2phpgenerator — Daniel Protopopov, Jul 02 '18 at 09:12
thr is no error in code able to see result: https://3v4l.org/322K6 — Chetan Ameta, Jul 05 '18 at 11:18
Oh!! Really sorry for that. It is my mistake. Above code is working fine. But in my SOAP response it's coming `ReturnValues` When I copied from `inspect element` its looking small letter. :( — Chinmay235, Jul 07 '18 at 13:23

jstur · Answer 1 · 2018-07-07T16:15:12.463

2

Your question edit is a big clue. You changed the XML from having lowercase to CamelCase elements. Change:

foreach ($xml->xpath('//returnvalues') as $item) {

to:

foreach ($xml->xpath('//ReturnValues') as $item) {

and it will work. Xpath queries are case sensitive.

edited Jul 07 '18 at 16:15

answered Jul 03 '18 at 16:37

jstur

659
6
12

Fairly curious -- why the down vote? If the value of `$response` was what the OP expected, his code would generate a different result than it is. – jstur Jul 03 '18 at 22:42
Thanks for you answer. My code was right. I have edited my question. Could you please check and edit your answer – Chinmay235 Jul 07 '18 at 13:29
Sure thing. Edit complete. – jstur Jul 07 '18 at 16:16

score 0 · Answer 2 · answered Jul 06 '18 at 10:34

Hope this helps

$response = '<soapenv:envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
    <soapenv:body>
        <ns1:mbillcommandresponse xmlns:ns1="http://www.mysoap.com/SoapService/">
            <returnvalues>
                <name>status</name>
                <value>TEHNICAL_ERROR</value>
            </returnvalues>
            <returnvalues>
                <name>description</name>
                <value>Please contact your administrator</value>
            </returnvalues>
        </ns1:mbillcommandresponse>
    </soapenv:body>
</soapenv:envelope>';
$response = preg_replace("/(<\/?)(\w+):([^>]*>)/", "$1$2$3", $response);

$xml = new SimpleXMLElement($response);
$body = $xml->xpath('//returnvalues');
$json = json_encode((array)$body); 
print_r($json);

How to convert SOAP response to XML or JSON format?

2 Answers2