Creating a JSON file from JSON response data in Python

Question

I want to take the json response data from a REST request and create an actual json file. I tried something like this, but it did not work. Essentially, it just prints the headers. Any suggestions?

params = {'f': 'json', 'where': '1=1', 'geometryType': 'esriGeometryPolygon', 'spatialRel': 'esriSpatialRelIntersects','outFields': '*', 'returnGeometry': 'true'}
r = requests.get('https://hazards.fema.gov/gis/nfhl/rest/services/CSLF/Prelim_CSLF/MapServer/3/query', params)

cslfJson = r.json()
path = r"C:/Workspace/Sandbox/ScratchTests/cslf.json"
file = open(path, 'w')
for line in cslfJson:
    file.write(line + "\r\n")

file.close()

have a look at json.dump

Nimish Bansal
– Nimish Bansal

2018-08-20 19:33:40 +00:00
Commented Aug 20, 2018 at 19:33 — Nimish Bansal
– Nimish Bansal, Commented Aug 20, 2018 at 19:33
Possible duplicate of How do I write JSON data to a file?

AnkDasCo
– AnkDasCo

2018-08-20 19:34:38 +00:00
Commented Aug 20, 2018 at 19:34 — AnkDasCo
– AnkDasCo, Commented Aug 20, 2018 at 19:34

Massimo Costa · Accepted Answer · 2018-08-20 19:33:03Z

1

use the json module

my_data = json.loads(r.json())
# my_data is a dict mapping the JSON

with open(path, 'w') as f:
    json.dump(my_data, f)

if you want, you can print in pretty way using the indent parameter

json.dump(my_data, f, indent=2)

answered Aug 20, 2018 at 19:33

Massimo Costa

1,88015 silver badges24 bronze badges

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

3 Comments

gwydion93 Over a year ago

OK, I just tried cslfJson = json.loads(r.json()) which creates a dictionary, then I used with open(path, 'w') as f: json.dump(cslfJson, f, indent=2). I got the following error - TypeError: the JSON object must be str, bytes or bytearray, not 'dict'.

Daniel Roseman Over a year ago

This is a bit pointless. There's no reason to load the JSON only to dump it back to a file. Just save the response content directly.

Massimo Costa Over a year ago

You are right. It makes sense only if you want to pretty print

Collectives™ on Stack Overflow

Creating a JSON file from JSON response data in Python

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related