read json in Python

Question

I can't believe it's not working! Here is my sample.json file:

{
  "SupportedTests": [
    "example1",
    "example2",
    "example3"
  ],
  "ExecutableFilePath": "C:\\Program Files\\Python37\\python.exe"
}

and the python code for reading this file:


# Opening JSON file
with open('sample.json') as jsonfile:
    jsonfile.seek(0)
    data = json.load(jsonfile)

Here is the error messsage:

raise JSONDecodeError("Expecting value", s, err.value) from None
json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

Any idea why this is not working? It's driving me nuts! Thanks

In your code snippet you didn't include the opening { in the JSON, is it there in the file ? — arhr
– arhr, Commented Feb 9, 2021 at 16:49
@NidalBarada If the file wasn't there, the open() call would have thrown an exception — John Gordon
– John Gordon, Commented Feb 9, 2021 at 19:09

D Hudson · Accepted Answer · 2021-02-09 17:01:26Z

3

Edited to reflect latest question change

Your code is valid and should open and parse the file fine. Note that you don't need jsonfile.seek(0)

The error indicates that the file you've opened is empty - are you sure the path to the file with the JSON is correct?

Original answer

Your json has a comma at the end of this line "ExecutableFilePath": "C:\\Program Files\\Python37\\python.exe",. This is invalid json and won't be parsed.

Because your have this comma, the parser is expecting another key in the json object - hence a string is expected.

Ensure that your JSON is valid with this tool: www.jsonlint.com

edited Feb 9, 2021 at 17:01

answered Feb 9, 2021 at 16:53

D Hudson

1,0926 silver badges13 bronze badges

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

3 Comments

Mohammad Over a year ago

@D Hudson that was a typo, I fixed it and validate the json file. Same issue exists.

John Gordon Over a year ago

This wouldn't cause the error Expecting value: line 1 column 1 (char 0), would it?

D Hudson Over a year ago

Thanks, no it wouldn't - good point! Answer updated

Collectives™ on Stack Overflow

read json in Python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related