How do I read the soap response from UPS web services?

Question

I am trying to parse the UPS sample code for the Rating service and while I get the response from UPS, I cannot seem to do anything with it. How do I read through and find the data I want? eg

and


   USD
   126.72

I need that code and the total charges. My code so far looks like this:

        $result = $client->__soapCall($operation ,array($this->processRate()));
        $resp = $client->__getLastResponse() ;
        echo $resp ;

output:



  
  
    
      
        
          1
          Success
        
        
          110971
          Your invoice may vary from the displayed reference rates
        
        
          110920
          Ship To Address Classification is changed from Residential to Commercial
        
        
      
      
        
          03
          
        
        
          110971
          Your invoice may vary from the displayed reference rates
        
        
          110920
          Ship To Address Classification is changed from Residential to Commercial
        
        
          
            LBS
            Pounds
          
          3.0
        
        
          USD
          17.76
        
        
          USD
          0.00
        
        
          USD
          17.76
        
      
      ......

I then run this code on it:

$xml = simplexml_load_string($resp);
\TYPO3\Flow\var_dump($xml  );  

$json = json_encode($xml);
$xmlarray = json_decode($json,TRUE);

echo "
".__FILE__.' '.__LINE__."   xmlarray   
";  
\TYPO3\Flow\var_dump($xmlarray);
die;

This outputs

    
            
                Flow Variable Dump
            
            
                SimpleXMLElementprototypeobject
            
        

/home/me/domains/shop.me.com/public_html/releases/20131219160416/Data/Temporary/Development/Cache/Code/Flow_Object_Classes/Shop_Shipping_UPSShippingHandler.php 336   xmlarray   

        
            
                Flow Variable Dump
            
            
                array(empty)

Seems my simplexml_load_string($resp) call is not working.

UPDATE: Thanks alien. This is what my code looks like now - it is not perfect yet but you get the idea - :

                $result = $client->__soapCall($operation ,array($this->processRate()));                 
                $resp =   $client->__getLastResponse() ; 
                $sxe = simplexml_load_string($resp);
                $sxe->registerXPathNamespace('r', "http://www.ups.com/XMLSchema/XOLTWS/Rate/v1.1");
                $codes = $sxe->xpath('//r:RatedShipment/r:Service/r:Code');

                $mv = $sxe->xpath('//r:TotalCharges/r:MonetaryValue');
                $indx=0;
                $estimates = array();
                foreach ($codes as $c) {
                    $temporaryEstimate = array();
                    $temporaryEstimate['estimateId'] = $this->getServiceTitleByCode($c->__toString());
                    $temporaryEstimate['estimatePrice'] = '$' .$mv[$indx];
                    $estimates[] = $temporaryEstimate;                    
                    $indx++;
                }
                return $estimates;

i alarmed alien · Accepted Answer

There is no real need to do the conversion to JSON and back again (unless you like making your computer work!); I loaded the XML you posted directly into a SimpleXMLElement and then queried it using XPath:

$sxe = new SimpleXMLElement($resp);

The elements that you are interested in are all in the rate namespace, so you need to register the namespace to be able to query it:

$sxe->registerXPathNamespace('r', "http://www.ups.com/XMLSchema/XOLTWS/Rate/v1.1");

We can now refer to all the rate: nodes in the XML using the shorthand r:.

Query for all the Code elements under RatedShipment/Service in the r namespace:

$codes = $sxe->xpath('//r:RatedShipment/r:Service/r:Code');
foreach ($codes as $c) {
    echo "code: $c" . PHP_EOL;
}

Output:

code: 03

Find the total cost of the shipment, which is under r:TotalCharges as r:MonetaryValue and r:CurrencyCode:

# xpath returns an array; we want the first element of that array for both these
$curr = $sxe->xpath('//r:TotalCharges/r:CurrencyCode')[0];
$mv = $sxe->xpath('//r:TotalCharges/r:MonetaryValue')[0];
echo "total charges: $mv $curr ". PHP_EOL;

Output:

total charges: 17.76 USD

If you aren't familiar with XPath, see the PHP documentation for more information on SimpleXML's XPath implementation.

How do I read the soap response from UPS web services?

Answers (1)

Related Questions