首页 > 解决方案 > requests.json 和 json.loads() JSONDecodeError:预期值:第 1 行第 1 列(字符 0)

问题描述

我正在尝试转换我在 json 中的响应

response = requests.get('http://solr.library.ucla.edu/solr/sheetmusic/select/?q=%5C*%20AND%20(url_keyword:http*)&version=2.2&start=0&rows=100&indent=on&facet=true&facet.field=r_date_facetRange&wt=json&json.wrf=jsonp1530647389471')
response = json.loads(response.content.decode('utf-8'))

但我得到了这个错误

~/.virtualenvs/pistache/lib/python3.6/site-packages/requests/models.py in json(self, **kwargs)
        890                     # used.
        891                     pass
    --> 892         return complexjson.loads(self.text, **kwargs)
        893 
        894     @property

    /usr/lib/python3.6/json/__init__.py in loads(s, encoding, cls, object_hook, parse_float, parse_int, parse_constant, object_pairs_hook, **kw)
        352             parse_int is None and parse_float is None and
        353             parse_constant is None and object_pairs_hook is None and not kw):
    --> 354         return _default_decoder.decode(s)
        355     if cls is None:
        356         cls = JSONDecoder

    /usr/lib/python3.6/json/decoder.py in decode(self, s, _w)
        337 
        338         """
    --> 339         obj, end = self.raw_decode(s, idx=_w(s, 0).end())
        340         end = _w(s, end).end()
        341         if end != len(s):

    /usr/lib/python3.6/json/decoder.py in raw_decode(self, s, idx)
        355             obj, end = self.scan_once(s, idx)
        356         except StopIteration as err:
    --> 357             raise JSONDecodeError("Expecting value", s, err.value) from None
        358         return obj, end

    JSONDecodeError: Expecting value: line 1 column 1 (char 0)

标签: pythonjson

解决方案


这个 url 返回的不是 JSON,而是JSONP。为了解析响应,您可以json.wrf=jsonp1530647389471从 url 中删除最后一个参数 () - 然后响应将变为 JSON,您将能够使用json.loads.

response = requests.get('http://solr.library.ucla.edu/solr/sheetmusic/select/?q=%5C*%20AND%20(url_keyword:http*)&version=2.2&start=0&rows=100&indent=on&facet=true&facet.field=r_date_facetRange&wt=json')
print json.loads(response.content.decode('utf-8'))
# {u'facet_counts': {u'facet_ranges': {}...

或者,为了更简单:

response = requests.get('http://solr.library.ucla.edu/solr/sheetmusic/select/?q=%5C*%20AND%20(url_keyword:http*)&version=2.2&start=0&rows=100&indent=on&facet=true&facet.field=r_date_facetRange&wt=json').json()

推荐阅读