Encoding error when trying to open json file from django app

Question

I have a json file in the same directory with my app where I have saved some names and passwords. When a user clicks a button, I am trying to retrieve these data and compare it with the input he gave. However, I get an encoding error JSONDecodeError: Expecting value: line 1 column 1 (char 0)

I tried adding errors='ignore' and change encoding without success.

My login function which opens the json file:

def login(name,password):
    with open('data.json', 'r', encoding='utf-8', errors='ignore') as f:
        try:
            data = json.loads(f.read())
            #data = json.load(f) didnt work also
            print(data)

        except ValueError:  # includes simplejson.decoder.JSONDecodeError
            print('Decoding JSON has failed')
            return False

        f.close()

And this is in my django app

def test(request):
    if request.method == 'POST':
        given_name = request.POST.get('name', None)
        given_password = request.POST.get('pass', None)
        # do something with user
        if login(given_name, given_password):
            about(request)
        else:
            test_home(request)
         ....

Json file:

{
    "names": [
        "test",
    ],
    "passwords": [
        "test",
    ]
}

This brings up another error: TypeError: the JSON object must be str, bytes or bytearray, not 'TextIOWrapper' which doesnt show up if i use json.load(f) — Jordan
– Jordan, Commented Oct 5, 2019 at 14:46
Your json file is probably empty or you are using a wrong path to open it. — Abhyudai
– Abhyudai, Commented Oct 5, 2019 at 14:47
Do you have these weird characters in your 'data.json'? stackoverflow.com/questions/38883476/… — chaooder
– chaooder, Commented Oct 5, 2019 at 14:48
It isnt empty and its in the same folder so why would the path cause problems? — Jordan
– Jordan, Commented Oct 5, 2019 at 14:49
looking at your json content, there are commas after the strings in "names" / "passwords" lists. json therefore expects more list elements... try removing the commas, worked for me. — FObersteiner
– FObersteiner, Commented Oct 5, 2019 at 15:01

FObersteiner · Accepted Answer · 2019-10-05 15:03:51Z

3

try modifying the json file as I pointed out in the comment;

{
    "names": [
        "test"
    ],
    "passwords": [
        "test"
    ]
}

now you should get

with open(file) as f:
    data = json.load(f)

data
Out[5]: {'names': ['test'], 'passwords': ['test']}

answered Oct 5, 2019 at 15:03

FObersteiner

26.1k9 gold badges60 silver badges94 bronze badges

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

Collectives™ on Stack Overflow

Encoding error when trying to open json file from django app

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related