SoapClient To Php Variables

Question

cambraydesign 0 Newbie Poster

8 Years Ago

I'm trying to change this soap response into php variables and failing!

I am trying this like:

$return = $response->DownloadDataByUserStringResult->UserId;

But this doesn't work

            $options = array( 
                'soap_version'=>SOAP_1_1, 
                'exceptions'=>true, 
                'trace'=>1, 
                'cache_wsdl'=>WSDL_CACHE_NONE               
            ); 
            $client = new SoapClient('http://client.Service.asmx?WSDL', $options); 

        } catch (Exception $e) { 
            echo "<h2>Exception Error!</h2>"; 
            echo $e->getMessage(); 
        }

            $params = array(
                'domain' => 'mydomain',
                'username' => 'myuser',
                'password' => 'mypass',
                'xmlMessage' => '<data clientid="10588"> <Report.Disposition.Summary3 reportid="3" startdatetime="2015-08-01 00:00:00" enddatetime="2015-08-10 00:00:00"/> </data>'
                );

$response = $client->__soapCall('DownloadDataByUserString', array($params));

var_dump($response);



Response: 

<?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <soap:Body> <DownloadDataByUserStringResponse xmlns="http://**.net/"> <DownloadDataByUserStringResult>
<?xml version="1.0" encoding="utf-16"?>
<results>
<data>
<Report.Disposition.Summary3 rows="258">
<row UserId="104" Name="Agent Template" Code="9999 " Count="8" TalkDuration="28" AvgTalkDuration="3" WrapDuration="0" AvgWrapDuration="0" PercentageOfTotalCalls="100" />
<row UserId="123" Name="Gareth Wright" Code="106 DUPLICATE" Count="7" TalkDuration="193" AvgTalkDuration="27" WrapDuration="110" AvgWrapDuration="15" PercentageOfTotalCalls="0.8" />
<row UserId="123" Name="Gareth Wright" Code="109 NI -FEES TOO HIGH" Count="14" TalkDuration="5539" AvgTalkDuration="395" WrapDuration="456" AvgWrapDuration="32" PercentageOfTotalCalls="1.6" />
<row UserId="123" Name="Gareth Wright" Code="111 NI -WENT WITH COMPETITOR " Count="17" TalkDuration="1125" AvgTalkDuration="66" WrapDuration="405" AvgWrapDuration="23" PercentageOfTotalCalls="2" /><

php soap

Edited 8 Years Ago by cambraydesign

2 Contributors
10 Replies
2K Views
2 Days Discussion Span
Latest Post 8 Years Ago Latest Post by cambraydesign

All 10 Replies

jkon 636 Posting Whiz in Training

8 Years Ago

If the $response->DownloadDataByUserStringResult is the string you have after the <DownloadDataByUserStringResult> tag in your first post then the only thing you have to do is:

$xml = new SimpleXMLElement( $response->DownloadDataByUserStringResult );
print_r($xml);

If it is the string of your first post then follow the first example I gave but instead of:

$response = trim($response);

use:

$response = trim($response->DownloadDataByUserStringResult);

Edited 8 Years Ago by jkon

jkon 636 Posting Whiz in Training

8 Years Ago

Hello and thank you , probably you have figured it out , but here is a simple way to iterate through this SimpleXMLElement object (guess from the output that you are in DownloadDataByUserStringResponse->DownloadDataByUserStringResult->results)

$xmlArray = xml2array($xml);
if( isset($xmlArray["data"]) 
    && isset($xmlArray["data"]["Report.Disposition.Summary3"]) 
    && isset($xmlArray["data"]["Report.Disposition.Summary3"]["row"]) )
{
    $rows = $xmlArray["data"]["Report.Disposition.Summary3"]["row"];
    if( count($rows) > 0 )
    {
        foreach($rows as $row)
        {
            $userDataArray = $row["@attributes"];
            var_export($userDataArray);
            echo "<br/><br/>";
            // you will have for each user something like 
            // array ( 'UserId' => '104', 'Name' => 'Agent Template'
            // , 'Code' => '9999 ', 'Count' => '8', 'TalkDuration' => '28'
            // , 'AvgTalkDuration' => '3', 'WrapDuration' => '0'
            // , 'AvgWrapDuration' => '0', 'PercentageOfTotalCalls' => '100', )
        }
    }
}

/**
 * Takes a SimpleXMLElement as argument and returns the array of its data 
 * and attributes
 * @param SimpleXMLElement $xmlObject
 * @param array $out . Optional array() by default
 * @return array
 * @see http://php.net/manual/en/ref.simplexml.php#111227
 */
function xml2array ( SimpleXMLElement $xmlObject, $out = array () )
{
    foreach ( (array) $xmlObject as $index => $node )
    {
        $out[$index] = ( is_object ( $node ) ||  is_array ( $node ) ) 
        ? xml2array ( $node ) : $node;
    }
    return $out;
}

The same thing we did here with arrays we could have done it with objects instantiators and objects list but of course the first step is to understand how SOAP is working in general. (For the specific method that your app had to consume I keep my doubts that maybe it wasn't designed well on the provider side or it wasn't designed for Web Services at all (sometimes , some people in order not having more providers they add a plain method from post (from example) inside a service ( I don't think that is a good way either but would explain the xml inside the xml response) )

Edited 8 Years Ago by jkon

jkon 636 Posting Whiz in Training

8 Years Ago

The output that you had were SimpleXMLElement Object was this from var_export or var_dump ?

ok ... this might be correct (this method added the || is_array)
So try:

/**
 * Takes a SimpleXMLElement as argument and returns the array of its data 
 * and attributes
 * @param SimpleXMLElement | array $xmlObject
 * @param array $out . Optional array() by default
 * @return array
 * @see http://php.net/manual/en/ref.simplexml.php#111227
 */
function xml2array ( $xmlObject, $out = array () )
{
    foreach ( (array) $xmlObject as $index => $node )
    {
        $out[$index] = ( is_object ( $node ) ||  is_array ( $node ) ) 
        ? xml2array ( $node ) : $node;
    }
    return $out;
}

(if you aren't in the node I guessed you can use this function to understand where you are and do the rest from there)

Edited 8 Years Ago by jkon

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

jkon 636 Posting Whiz in Training Featured Poster · Answer 1 · 2015-10-13T04:51:22+00:00

What is very strange with your question is that this web service method (DownloadDataByUserString) returns an XML inside (that more over has different encoding !!!). I have worked with web services methods that returned XML but in a CDATA wrapper , not that way. If you have something to do with the provider , thing seriously refactoring , if your app is only the consumer – client than lets figure out a way to parse those data (you didn't provided the full response so I had to speculate and create one from your example).

<?php
$response = <<<XML
<?xml version="1.0" encoding="utf-8"?> 
    <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> 
    <soap:Body> 
    <DownloadDataByUserStringResponse xmlns="http://**.net/"> 
        <DownloadDataByUserStringResult>
            <?xml version="1.0" encoding="utf-16"?>
                <results>
                    <data>
                        <Report.Disposition.Summary3 rows="4">
                            <row UserId="104" Name="Agent Template" Code="9999 " Count="8" TalkDuration="28" AvgTalkDuration="3" WrapDuration="0" AvgWrapDuration="0" PercentageOfTotalCalls="100" />
                            <row UserId="123" Name="Gareth Wright" Code="106 DUPLICATE" Count="7" TalkDuration="193" AvgTalkDuration="27" WrapDuration="110" AvgWrapDuration="15" PercentageOfTotalCalls="0.8" />
                            <row UserId="123" Name="Gareth Wright" Code="109 NI -FEES TOO HIGH" Count="14" TalkDuration="5539" AvgTalkDuration="395" WrapDuration="456" AvgWrapDuration="32" PercentageOfTotalCalls="1.6" />
                            <row UserId="123" Name="Gareth Wright" Code="111 NI -WENT WITH COMPETITOR " Count="17" TalkDuration="1125" AvgTalkDuration="66" WrapDuration="405" AvgWrapDuration="23" PercentageOfTotalCalls="2" />
                        </Report.Disposition.Summary3>
                    </data>
                </results>
        </DownloadDataByUserStringResult>    
    </DownloadDataByUserStringResponse>
    </soap:Body>
    </soap:Envelope>
XML;


$response = trim($response);
$response = str_ireplace(array("soap:","<?xml version=\"1.0\" encoding=\"utf-16\"?>")
    , "", $response);
$xml = new SimpleXMLElement($response);
print_r($xml);

?>

cambraydesign 0 Newbie Poster · Answer 2 · 2015-10-13T08:16:32+00:00

That gets me an error:

Warning: trim() expects parameter 1 to be string, object given in /home//public_html/soap.php on line 58

Fatal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in /home/public_html/soap.php:61 Stack trace: #0 /home/public_html/soap.php(61): SimpleXMLElement->__construct('') #1 {main} thrown in /home/public_html/soap.php on line 61

jkon 636 Posting Whiz in Training Featured Poster · Answer 3 · 2015-10-13T09:12:25+00:00

What is the result when you var_dump or var_export the $response ? Is it string as you wrote in the first post or is it an object ?

cambraydesign 0 Newbie Poster · Answer 4 · 2015-10-13T10:22:45+00:00

var_dump:

object(stdClass)#4 (1) { ["DownloadDataByUserStringResult"]=> string(50421) "" }

cambraydesign 0 Newbie Poster · Answer 5 · 2015-10-13T11:17:00+00:00

You're a genius :)

Ok so the output looks like this now, how do I call individual rows:

For example if I wanted all of the UserId from this how would I call them, would it be like this:

foreach($xml->UserId as $id){
    echo $id.'<br />';
}

Once again thanks for your help!!!!! :)

cambraydesign 0 Newbie Poster · Answer 6 · 2015-10-13T15:53:18+00:00

I have to agree that it hasn't been designed well, compared to other soapclients this one has been horrible! Again thank you for your help, my brain has been hurting over this for a while.

The example you have just sent to me returns this error:

Catchable fatal error: Argument 1 passed to xml2array() must be an instance of SimpleXMLElement, array given, called in

cambraydesign 0 Newbie Poster · Answer 7 · 2015-10-14T15:30:57+00:00

That my friend is perfect, I can now call each individual element of that array with $row['@attributes']['element']. Thanks so much for your help. Kudos to you!!

SoapClient To Php Variables

Recommended Answers Collapse Answers

All 10 Replies

Recommended Answers