"Expecting value: line 1 column 1 (char 0)"

Question

I'm trying to make a program that gets the "name" field out of the json file:

{
  "accounts" : {
    "fd1c3f81187b4a12b8e1226b0177a23basw" : {
      "accessToken" : "",
      "Profile" : {
        "id" : "ca227f281b6e40eebcb4fa9ef6c326fawedsa34",
        "name" : "random name"
      },
      
      "userProperites" : []
    }
  }
}

with the following code:

import json

json = json.loads('data.json')
accounts = json["accounts"]
    
for value in json["accounts"].values():
    print(value["name"])

but i am getting the "Expecting value: line 1 column 1 (char 0)" error, how can i make it work?

Please read the docs for `json.loads`. That is **not** how you tell it to read the content of a file — DeepSpace, Sep 29 '22 at 13:48
Also, naming a variable and an imported module with the same name is asking for problems — DeepSpace, Sep 29 '22 at 13:48
use `json.load` instead and do `json.load(open('file_path_goes_here', 'r'))` — Gurbakhshish Singh, Sep 29 '22 at 13:49
@GurbakhshishSingh Using `json.loads` is ok if used correctly. Also, you should `open` a file using `with` — DeepSpace, Sep 29 '22 at 13:50

chitown88 · Answer 1 · 2022-09-29T13:57:55.960

0

If you use .loads(), it's looking for the json as a string. So you need to ready in the json file

import json

# JSON file
with open('data.json', "r") as f:
    jsonStr = f.read()
    jsonData = json.loads(jsonStr)
    
accounts = jsonData["accounts"]
        
for value in jsonData["accounts"].values():
    print(value["name"])

Or

with open("data.json", "r") as f:
    jsonData = json.load(f)

edited Sep 29 '22 at 13:57

answered Sep 29 '22 at 13:50

chitown88

27,527
4
30
59

2

Let's use `with` to promote best practices – DeepSpace Sep 29 '22 at 13:51

"Expecting value: line 1 column 1 (char 0)"

1 Answers1