Python3 - Replace Values in JSON Object

Question

I'm running an API query that returns three key value pairs:

{'enabled': True, 'recording': False, 'autoDeletion': False}

I need to replace the values with 1 and 0 respectively, to obtain:

{'enabled': 1, 'recording': 0, 'autoDeletion': 0}

I've tried using json.dumps.replace, but I just get a list of errors from the JSON encoder module, culminating in "TypeError: Object of type Response is not JSON serializable", which is why it's commented out in the code.

Is there a simple way to achieve this seemingly trivial substitution please?

Here's the code

#Make API request
api_response = requests.request("GET", server + query_endpoint, headers=query_headers, data=query_payload)

#api_test = json.dumps(api_response).replace('"true"','"1"')

print(api_response.json())

And the output looks like this:

{'enabled': True, 'recording': False, 'autoDeletion': False}

>>> d = {'enabled': True, 'recording': False, 'autoDeletion': False} >>> {k: 1 if v else 0 for k, v in d.items()} {'enabled': 1, 'recording': 0, 'autoDeletion': 0} — Gorgine
– Gorgine, Commented Nov 27, 2020 at 12:16

funie200 · Accepted Answer · 2020-11-27 12:52:37Z

5

I think the .json() return a dict, then do like this,

data = api_response.json()
for k,v in data.items():
    data[k] = int(v)
print(data)

Output:

{'enabled': 1, 'recording': 0, 'autoDeletion': 0}

Hope that works!

edited Nov 27, 2020 at 12:52

funie200

3,9355 gold badges25 silver badges38 bronze badges

answered Nov 27, 2020 at 12:16

Shri Hari L

4,9732 gold badges8 silver badges22 bronze badges

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

Comments

Sash Sinha · Accepted Answer · 2020-11-27 12:25:05Z

3

You can use a dict comprehension and just cast each value to an int:

api_response_json = {k: int(v) for k, v in api_response.json().items()}
print(api_response_json)

Output:

{'enabled': 1, 'recording': 0, 'autoDeletion': 0}

edited Nov 27, 2020 at 12:25

answered Nov 27, 2020 at 12:16

Sash Sinha

22.8k4 gold badges27 silver badges48 bronze badges

1 Comment

Brian Over a year ago

Thanks gents. That seems to have done it!

Collectives™ on Stack Overflow

Python3 - Replace Values in JSON Object

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related