Problem parsing JSON data from external url in PHP

Question

Im really new in json code, even javascript code but I got this so far. I'm able to get json data from a local file with the same information but not from this external URL: https://s3.amazonaws.com/dolartoday/data.json

This is my code:

<?php

$json = file_get_contents("https://s3.amazonaws.com/dolartoday/data.json", 'jsonp');
$data = json_decode($json, true);

echo $data['USD']['dolartoday'];

?>

Expected result, something like this: 6124.24

Note: this code is ok, I get data from a local file with the same values but I cant fetch json data from this external URL specifically. I also added 'jsonp' but that didnt work.

Stephen Clouse · Accepted Answer · 2019-05-01 21:57:57Z

5

Your JSON document on S3 is invalid.

JSON is required to be in UTF-8, but you appear to have extended ASCII characters in it instead.

Proper error checking would have revealed this.

$data = json_decode($json, true);
if (is_null($data)) {
    echo json_last_error_msg();
    die;
}

which would have printed

Malformed UTF-8 characters, possibly incorrectly encoded

answered May 1, 2019 at 21:57

Stephen Clouse

4012 silver badges7 bronze badges

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

4 Comments

Dharman Over a year ago

If on >PHP 7.3 then you can use the flag JSON_THROW_ON_ERROR

rickdenhaan Over a year ago

If on PHP 7.2 or higher, you can pass the JSON_INVALID_UTF8_IGNORE option

Irvıng Ngr Over a year ago

Thanks @Stephen Clouse I didnt know that.

Stephen Clouse Over a year ago

I should clarify that other encodings have been allowed in the past, but UTF-8 is the only encoding that has been part of the spec for its entire lifetime, thus it is the only guaranteed interoperable encoding. The most recent revision of the JSON spec (RFC 8259) clarifies this and essentially mandates UTF-8 as the only supported encoding.

Irvıng Ngr · Accepted Answer · 2019-05-02 01:33:59Z

0

Thanks to @Stephen's clarification I found a solution to my problem.

<?php
$json = file_get_contents("https://s3.amazonaws.com/dolartoday/data.json", 'jsonp');
$utf8 = utf8_decode($json); //decode UTF-8
$data = json_decode($utf8, true);

echo $data['USD']['dolartoday'];
?>

answered May 2, 2019 at 1:33

Irvıng Ngr

4387 silver badges15 bronze badges

Collectives™ on Stack Overflow

Problem parsing JSON data from external url in PHP

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related