CODEWITHSUNDEEP
pythonjsonpython-requeststablib
budgiebeaks
budgiebeaks

Reputation: 161

result of response.json() causes " 'Response' object has no attribute 'read' " error

I am trying to convert json from an external api to an xls file using requests and tablib. In order to do this, I send a request to the external api, which returns a valid json file. This is my code:

response = req.request("GET", url, params=querystring)
response.json()
data = tb.Dataset()
data.json = response.read()

This is what I get:

Traceback (most recent call last):
  File "...\python\lib\tkinter\__init__.py", line 1705, in __call__
    return self.func(*args)
  File ".../python/Scripts/myscript", line 37, in submit
    data.json = response.read()
AttributeError: 'Response' object has no attribute 'read'

If the code is, 

 response = req.request("GET", url, params=querystring)
 response.json()
 data = tb.Dataset()
 data.json = response.json()

I get: 

Traceback (most recent call last):
  File "...\Bitnami\djangostack-3.0.5-1\python\lib\tkinter\__init__.py", line 1705, in __call__
    return self.func(*args)
  File "...\Bitnami/djangostack-3.0.5-1/python/Scripts/buzzsumo.py", line 37, in submit
    data.json = response.json()
  File "...\Bitnami\djangostack-3.0.5-1\python\lib\site-packages\tablib\formats\__init__.py", line 66, in __set__
    return self._format.import_set(obj, normalize_input(val))
  File "...\Bitnami\djangostack-3.0.5-1\python\lib\site-packages\tablib\formats\_json.py", line 38, in import_set
    dset.dict = json.load(in_stream)
  File "...\Bitnami\djangostack-3.0.5-1\python\lib\json\__init__.py", line 293, in load
    return loads(fp.read(),
AttributeError: 'dict' object has no attribute 'read'

What am I doing wrong?

Upvotes: 1

Views: 2466

Answers (0)

Related Questions