JSON vs. XML using webread()

Question

0 个投票

I have a url that I am able to get data when I set the output to xml as an optional parameter in the url, but when I set it to json, I get NaN... the url is 'http://api.eia.gov/series/?api_key=####&series_id=NG.RNGC1.D&out=json' where #### is a private key. Any ideas? I am able to get a struct array when I use the World Bank Climate example in Matlab help documentation.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Kevin Lapret 2015-8-4

Not sure what you will be doing with the JSON data but if you want to convert it to a more import friendly format, there are some JSON to CSV converters like json-csv.com

请先登录，再进行评论。

请先登录，再回答此问题。

Follow Question

Answer 1

Robert Snoeberger 2015-8-3

在 MATLAB Online 中打开

3 个投票

The JSON text received from the web service contains the UTF-8 byte order mark (BOM), ï»¿, at the beginning [1]. The BOM is causing the JSON parser to fail. You can see the BOM by calling webread with a content type of text.

>> url = 'http://api.eia.gov/series/?api_key=####&series_id=NG.RNGC1.D&out=json';
>> webread(url, weboptions('ContentType', 'text'))
ans =
ï»¿{"request":{"command":"series"},"data":{"error":"No api_key. For key registration, documentation, and examples see http:\/\/www.eia.gov\/developer\/"}}
>>