gspread gives TypeError: expected bytes when trying to log in

Question

I'm trying to use Google Spreadsheets OAuth with the gspread library. I get a TypeError: expected bytes, not str exception when sending credentials. How do I fix this?

import gspread
import json
from oauth2client.client import SignedJwtAssertionCredentials

json_key = json.load(open('Test for gspread-78c678a7fb15.json'))
scope = ['https://spreadsheets.google.com/feeds']
credentials = SignedJwtAssertionCredentials(json_key['client_email'], json_key['private_key'], scope)
gc = gspread.authorize(credentials)

Traceback (most recent call last):
  File "<pyshell#27>", line 1, in <module>
    credentials = SignedJwtAssertionCredentials(json_key['client_email'], json_key['private_key'], scope)
  File "C:\Python33\lib\site-packages\oauth2client\util.py", line 137, in positional_wrapper
    return wrapped(*args, **kwargs)
  File "C:\Python33\lib\site-packages\oauth2client\client.py", line 1515, in __init__
    self.private_key = base64.b64encode(private_key)
  File "C:\Python33\lib\base64.py", line 58, in b64encode
    raise TypeError("expected bytes, not %s" % s.__class__.__name__)
TypeError: expected bytes, not str

how about to try transfer `str` to `bytes`? look [this](http://stackoverflow.com/questions/7585435/best-way-to-convert-string-to-bytes-in-python-3) — stamaimer, May 27 '15 at 14:57
Yes, thanks, that does work. I discovered that after posting the question and posted an answer shorlty after. Thank you for replying! — Jon Bresler, May 28 '15 at 16:44

score 1 · Answer 1 · edited May 27 '15 at 19:16

1

The key is a string and needs to be encoded to bytes. Replace credentials = with the following:

credentials = SignedJwtAssertionCredentials(json_key['client_email'], json_key['private_key'].encode(), scope)

edited May 27 '15 at 19:16

davidism

121,510
29
395
339

answered May 27 '15 at 15:02

Jon Bresler

21
2

gspread gives TypeError: expected bytes when trying to log in

1 Answers1