Convert a string from json to Python: Problem

Question

I am trying to convert a Json string, that i got from a Website, to a python string, but it doesent work.

import json

y = json.loads({"title":null,"icon":null,"iphoneURL":null,"splitURL":null,"splitPercent":null,"expiresAt":null,"expiredURL":null,"clicksLimit":null,"source":"api","integrationGA":null,"integrationFB":null,"integrationAdroll":null,"integrationGTM":null,"id":,"originalURL":"http://instagramm.com","DomainId":,"archived":false,"path":"","cloaking":null,"redirectType":null,"createdAt":"2021-08-03T17:02:20.935Z","OwnerId":,"updatedAt":"2021-08-03T17:02:20.935Z","secureShortURL":"","idString":"lnk_X1P_RGeQY","shortURL":"","duplicate":false})

print(y["originalURL"])

As far as I can tell, I am missing some ' in front and back of the JSON string, but I have no idea, how to add them.

Sorry for my bad English and python Skills

Edit: ive tried adding ' with comma, + and .join ('"""')

Edit2:

import requests

url = "https://api.short.io/links/xxxxxx"
wurl = "youtube.com"

response = requests.request("POST", url, json={"allowDuplicates": False, "domain": "1cr0.short.gy", "originalURL": wurl}, headers={"Accept": "application/json", "Content-Type": "application/json", "Authorization": "xxxxxxxxxxxxxxxxxxxxxx"})

print(response.text)

TimoRJensen · Accepted Answer · 2021-08-04 07:41:27Z

2

You need to make the json string an actual sting. So try putting single quotes around it. Like so:

import json

y = json.loads('{"title":null,"icon":null,"iphoneURL":null,"splitURL":null,"splitPercent":null,"expiresAt":null,"expiredURL":null,"clicksLimit":null,"source":"api","integrationGA":null,"integrationFB":null,"integrationAdroll":null,"integrationGTM":null,"id":793212684,"originalURL":"http://instagramm.com","DomainId":226909,"archived":false,"path":"5n316HkujOzP","cloaking":null,"redirectType":null,"createdAt":"2021-08-03T17:02:20.935Z","OwnerId":221852,"updatedAt":"2021-08-03T17:02:20.935Z","secureShortURL":"https://1cr0.short.gy/5n316HkujOzP","idString":"lnk_X1P_RGeQY","shortURL":"https://1cr0.short.gy/5n316HkujOzP","duplicate":false}')

print(y["originalURL"])

answered Aug 4, 2021 at 7:41

TimoRJensen

212 bronze badges

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

9 Comments

KKirschi Over a year ago

yes, but I don't know how to add them automatically. That's my problem

TimoRJensen Over a year ago

I don't understand the question here, sorry. What are you actually receiving? Can you give a more precise example?

KKirschi Over a year ago

I am getting the string without the quotes, as I put it there, now my problem is, to add quotes automatically in front and in the back, but I don't know, how to.

TimoRJensen Over a year ago

The string itself should not include the quotes. They are just denoting the sequence of characters as a string. So if you already receive a str try passing this to json.loads()

KKirschi Over a year ago

If you look to my code, that is my string, that's how I got him, but I don't know, how to add quotes, and if I pass it directly through, it gives me an error.

|

MundaneHassan · Accepted Answer · 2021-08-04 07:43:38Z

0

You forgot the quotes around your y variable to make it a string, I recommend an ide so it can point out stuff like this.

y = json.loads('{"title":null,"icon":null,"iphoneURL":null,"splitURL":null,"splitPercent":null,"expiresAt":null,"expiredURL":null,"clicksLimit":null,"source":"api","integrationGA":null,"integrationFB":null,"integrationAdroll":null,"integrationGTM":null,"id":793212684,"originalURL":"http://instagramm.com","DomainId":226909,"archived":false,"path":"5n316HkujOzP","cloaking":null,"redirectType":null,"createdAt":"2021-08-03T17:02:20.935Z","OwnerId":221852,"updatedAt":"2021-08-03T17:02:20.935Z","secureShortURL":"https://1cr0.short.gy/5n316HkujOzP","idString":"lnk_X1P_RGeQY","shortURL":"https://1cr0.short.gy/5n316HkujOzP","duplicate":false}')

answered Aug 4, 2021 at 7:43

MundaneHassan

1469 bronze badges

3 Comments

KKirschi Over a year ago

yes, but I don't know how to add them. That's my problem

MundaneHassan Over a year ago

I have already added them you can copy them

KKirschi Over a year ago

but automatically?

Hamza Abbasi · Accepted Answer · 2021-08-04 07:48:32Z

0

Please pass your json data in a string.

Try:

import json

y = json.loads('{"title":null,"icon":null,"iphoneURL":null,"splitURL":null,"splitPercent":null,"expiresAt":null,"expiredURL":null,"clicksLimit":null,"source":"api","integrationGA":null,"integrationFB":null,"integrationAdroll":null,"integrationGTM":null,"id":793212684,"originalURL":"http://instagramm.com","DomainId":226909,"archived":false,"path":"5n316HkujOzP","cloaking":null,"redirectType":null,"createdAt":"2021-08-03T17:02:20.935Z","OwnerId":221852,"updatedAt":"2021-08-03T17:02:20.935Z","secureShortURL":"https://1cr0.short.gy/5n316HkujOzP","idString":"lnk_X1P_RGeQY","shortURL":"https://1cr0.short.gy/5n316HkujOzP","duplicate":false}')

print(y["originalURL"])

Output:

http://instagramm.com

answered Aug 4, 2021 at 7:48

Hamza Abbasi

1114 bronze badges

2 Comments

KKirschi Over a year ago

I know, but i don't know, how to add them automatically, that's my problem.

Hamza Abbasi Over a year ago

There's nothing that can be done automatically, you have to get it done by yourself

Ram · Accepted Answer · 2021-08-04 07:48:36Z

0

You have to pass a JSON String to json.loads(). You are just passing the JSON as is (Not a string).

From the Docs:

json.loads(s) - Deserialize s (a str, bytes or bytearray instance containing a JSON document)

import json

y = json.loads('{"title":null,"icon":null,"iphoneURL":null,"splitURL":null,"splitPercent":null,"expiresAt":null,"expiredURL":null,"clicksLimit":null,"source":"api","integrationGA":null,"integrationFB":null,"integrationAdroll":null,"integrationGTM":null,"id":793212684,"originalURL":"http://instagramm.com","DomainId":226909,"archived":false,"path":"5n316HkujOzP","cloaking":null,"redirectType":null,"createdAt":"2021-08-03T17:02:20.935Z","OwnerId":221852,"updatedAt":"2021-08-03T17:02:20.935Z","secureShortURL":"https://1cr0.short.gy/5n316HkujOzP","idString":"lnk_X1P_RGeQY","shortURL":"https://1cr0.short.gy/5n316HkujOzP","duplicate":false}')

print(y["originalURL"])

http://instagramm.com

answered Aug 4, 2021 at 7:48

Ram

4,7892 gold badges17 silver badges23 bronze badges

4 Comments

KKirschi Over a year ago

I know, but i don't know, how to add them automatically, that's my problem.

Ram Over a year ago

What do you mean by automatically ? Put your JSON in between single quotes- 'JSON'. Is your JSON stored in any variable ?

KKirschi Over a year ago

yes, but can´t python do that for me? I am getting these strings relatively often, and I don't want to add quotes every single time.

Ram Over a year ago

If you have the JSON stored in a variable, you don't need to add any quotes. You can just do json.loads(x) - x is the variable containing JSON. If you want more clarity, I suggest you clearly mention (in your question from where you are getting that JSON. Is it an API/file etc.,) what your problem is so that we can help you out.

Unsung · Accepted Answer · 2021-08-04 07:50:28Z

Try This: import json

y = '''{"title":null,"icon":null,"iphoneURL":null,"splitURL":null,"splitPercent":null,"expiresAt":null,"expiredURL":null,"clicksLimit":null,"source":"api","integrationGA":null,"integrationFB":null,"integrationAdroll":null,"integrationGTM":null,"id":793212684,"originalURL":"http://instagramm.com","DomainId":226909,"archived":false,"path":"5n316HkujOzP","cloaking":null,"redirectType":null,"createdAt":"2021-08-03T17:02:20.935Z","OwnerId":221852,"updatedAt":"2021-08-03T17:02:20.935Z","secureShortURL":"https://1cr0.short.gy/5n316HkujOzP","idString":"lnk_X1P_RGeQY","shortURL":"https://1cr0.short.gy/5n316HkujOzP","duplicate":false}'''

y = json.loads(y)

print(y["originalURL"])

I just converted the json to string before loading

Hamza Abbasi · Accepted Answer · 2021-08-04 10:36:24Z

0

print(response.text)

You can save the return of this code into a variable.

var = str(response.text)
y = json.loads(var)

print(y["originalURL"])

and type cast it into a string before passing it into the variable.

edited Aug 4, 2021 at 10:36

answered Aug 4, 2021 at 9:56

Hamza Abbasi

1114 bronze badges

4 Comments

KKirschi Over a year ago

OMG, Thx! that's exactly, what i was looking for, tywm!

Hamza Abbasi Over a year ago

Do upvote and mark it as a correct answer!

KKirschi Over a year ago

cant, too les carma

Hamza Abbasi Over a year ago

That's actually sad :p

Collectives™ on Stack Overflow

Convert a string from json to Python: Problem

6 Answers 6

9 Comments

3 Comments

2 Comments

4 Comments

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

9 Comments

3 Comments

2 Comments

4 Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related