Unable to get JSON rest response into an array through PHP Function

Question

So I'm working on expedia's API, and have successfully worked many of the API requests but am unable to get just one to work though I've tried and searched in vain for what could be the problem.

My Function looks like this:

global $cid, $apiKey, $sig, $minor_rev;


$url= 'http://api.ean.com/ean-services/rs/hotel/v3/paymentInfo?minorRev='.$minor_rev.'';
$url .= '&cid='.$cid.'';
$url .= '&sig='.$sig.'';
$url .= '&apiKey='.$apiKey.'';
$url .= '&customerUserAgent='.$PaymentTypeData['customerUserAgent'].'';
$url .= '&customerIpAddress='.$PaymentTypeData['customerIpAddress'].'';
$url .= '&customerSessionId='.$PaymentTypeData['customerSessionId'].'';
$url .= '&locale=en_US&_type=json';
$url .= '&amp;currencyCode='.$PaymentTypeData['currencyCode'].'';
$url .= '&hotelId='.$PaymentTypeData['hotelId'].'';
$url .= '&supplierType=E';
$url .= '&rateType=MerchantStandard';



$header[] = "Accept: application/json";
$header[] = "Accept-Encoding: gzip, deflate";
$ch = curl_init();
curl_setopt( $ch, CURLOPT_HTTPHEADER, $header );
curl_setopt($ch,CURLOPT_ENCODING , "gzip");
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'GET');
curl_setopt( $ch, CURLOPT_URL, $url );
curl_setopt( $ch, CURLOPT_RETURNTRANSFER, true );
$result = json_decode(curl_exec($ch), true);


$HotelPaymentResponse = array();
$HotelPaymentResponse[] = $result['HotelPaymentResponse'];


echo '<pre>';
echo $url;
print_r($result);
echo '<h1>GET HOTEL PAYMENT TYPES</h1>';
print_r($HotelPaymentResponse);
echo '</pre>';

return $HotelPaymentResponse;

When I echo the URL and try it in the browser the result is as expected, an array of the payment types in json form.... but for the life of me getting this into the php array for the return eludes me.

Here is a link to the API spec: http://developer.ean.com/docs/payment-types/

And yes I have checked out JSON guides often posted on S.Overflow....

any help would be so very appreciated...

PS:

the API says the repose will look like:

{
"HotelPaymentResponse": {
    "@size": "4",
    "@currencyCode": "USD",
    "customerSessionId": "0ABAAAC9-9A32-7914-9E32-D7EC7F906769",
    "PaymentType": [
        {
            "code": "AX",
            "name": "American Express"
        },
        {
            "code": "DS",
            "name": "Discover"
        },
        {
            "code": "CA",
            "name": "Master Card"
        },
        {
            "code": "VI",
            "name": "Visa"
        }
    ]
}
}

BUT my Array is returning:

Array
(
    [0] => 
)

SOLVED:

Thanks to working through the comments below and researching the error thrown, 505 - I googled and found someone say they had an error because of a stray space in the url. My error was because my Customer user agent was populating from php's user HTTP agent... Removed that and manually entered and now I can curl the response.

No error being thrown, but the array is printing Array ( [0] => ) — Daniel Butler
– Daniel Butler, Commented Apr 8, 2016 at 16:41
run a var_dump() on the $result and see what it shows. If it's NULL, then your array will be empty, and there's an issue in your API call — Pazuzu156
– Pazuzu156, Commented Apr 8, 2016 at 16:53
Yeah it is NULL, but what I don't understand is that when I visit the echoed URL it shows up fine in the browser - any ideas? — Daniel Butler
– Daniel Butler, Commented Apr 8, 2016 at 16:55
This specific bit: echo $url; print_r($result); What does that show? — Pazuzu156
– Pazuzu156, Commented Apr 8, 2016 at 16:59

Barmar · Accepted Answer · 2016-04-08 16:43:24Z

1

When you use true as the second argument to json_decode, JSON objects are decoded to PHP associative arrays, not objects. So $result->HotelPaymentResponse should be $result['HotelPaymentResponse'].

Or don't use the second argument to json_decode().

answered Apr 8, 2016 at 16:43

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

5 Comments

Daniel Butler Over a year ago

Thanks, I did try that but still throwing Array ( [0] => )

Barmar Over a year ago

What does the response from the API look like before you call json_decode()?

Daniel Butler Over a year ago

I'm not sure hot to check that?

Barmar Over a year ago

$response = curl_exec($ch); var_dump($response); $result = json_decode($response, true);

Barmar Over a year ago

So you're getting an empty response from the API. Everything after that is irrelevant, you need to figure out why that's happening.

Collectives™ on Stack Overflow

Unable to get JSON rest response into an array through PHP Function

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related