encoding string into json not working as expected

Question

I am using below code to encode a string (after variable replacement) to json , but the final json coming as an Invalid json.

data = '''{
    "firstName": "%s",
    "lastName": "%s",
    "dept": ["IT"]
    }'''

v_data = data % ('rob','bob')

with open("new_file.json", 'w') as file:
    json.dump(v_data, file)

The content of the json file "new_file.json" shows as Invalid json.

You should just file.write(v_data) as v_data is already a JSON encoded string. — metatoaster
– metatoaster, Commented Feb 11, 2020 at 4:34
I didn't found any problem The json is valid on evey validators. "{\n \"firstName\": \"rob\",\n \"lastName\": \"bob\",\n \"dept\": [\"IT\"]\n }" — diffuse
– diffuse, Commented Feb 11, 2020 at 4:36
Python json.dump takes a Python dictionary, not a string. You could use v2_data = json.loads(v_data) which would return a dictionary {'firstName': 'rob', 'lastName': 'bob', 'dept': ['IT']}, that you can then use with json.dump with v2_data the dictionary, or just start with a dictionary, instead of a string — Mark Mikofski
– Mark Mikofski, Commented Feb 11, 2020 at 4:38

FoviBot · Accepted Answer · 2020-02-11 04:37:28Z

3

json.dump changes a json to a string, while it is already a string, use:

data = '''{
    "firstName": "%s",
    "lastName": "%s",
    "dept": ["IT"]
    }'''

v_data = data % ('rob','bob')

with open("new_file.json", 'w') as file:
    file.write(v_data)

answered Feb 11, 2020 at 4:37

FoviBot

604 bronze badges

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

Collectives™ on Stack Overflow

encoding string into json not working as expected

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related