Python3 remove newline character from json response

Question

I am currently using the urllib to load a url request and then I load the response to json. This works perfectly but when I change the date range one field contains the \n character and is breaking the line.

How would I stop this from happening I have tried replace and rstrip but can't seem to get them to work.

Here is my code that extracts the data:

req = urllib.request.Request("http://example.com/file.json")

r = urllib.request.urlopen(req).read()
#r = r.rstrip('\n')
content = json.loads(r.decode('utf-8'))
#content.replace('\n','') - fails due to incorrect type

Thanks

What do you mean by "when I change the date range", and who is producing this json ? (if it's you then fix the problem at the source instead, if it's not you and the json is invalid then contact the site's admins/maintainer and ask them to fix it) — bruno desthuilliers
– bruno desthuilliers, Commented Oct 18, 2018 at 11:25

DeepSpace · Accepted Answer · 2018-10-18 10:18:49Z

4

You try to call .replace on a dictionary. You should call .replace on the string:

content = json.loads(r.decode('utf-8').replace('\n', ''))

However, keep in mind that this may invalidate the string as json, depending on its content.

BTW, if you use requests you can get json directly:

import requests

content = requests.get("http://example.com/file.json").json()

answered Oct 18, 2018 at 10:18

DeepSpace

82.1k12 gold badges119 silver badges166 bronze badges

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

1 Comment

seanie_oc Over a year ago

Hi, I tried to add the .replace it ran but didn't remove the \n

BrokenBenchmark · Accepted Answer · 2022-01-11 00:29:12Z

0

json.loads accepts an argument indents which will indent each line in the JSON. Setting the argument to None removes new line breaks.

You can try:

json.dumps(indents=None)

edited Jan 11, 2022 at 0:29

BrokenBenchmark

19.4k7 gold badges26 silver badges40 bronze badges

answered Jan 7, 2022 at 7:33

christopherjamescurtin

612 silver badges2 bronze badges

Comments

Andy Wong · Accepted Answer · 2018-10-18 11:12:17Z

-1

Try the python String method

json.loads(str(r,”utf-8”))

To replace string only

New_str = str(r,”utf-8”)

edited Oct 18, 2018 at 11:12

answered Oct 18, 2018 at 10:33

Andy Wong

4,5941 gold badge24 silver badges20 bronze badges

3 Comments

seanie_oc Over a year ago

Hi I change the following: content = json.loads(str(r,'utf-8')) and added cont.replace('\n','') When I ran the code I got an error saying replace could not be preformed on a dict

Andy Wong Over a year ago

I think after executed json.loads it will convert the response to dict format that’s why it can not replace because replace is a string function.

seanie_oc Over a year ago

Hi, I'm not having any luck with the solution provided.

Collectives™ on Stack Overflow

Python3 remove newline character from json response

3 Answers 3

1 Comment

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related