API Keys will not work with the Google Sheets API. You need to use OAuth
<https://developers.google.com/sheets/quickstart/python>, as you were doing
originally.
The reason you only see 500 Internal Server Errors client-side is because
every time some exception occurs, you aren't handling it and just letting
your code crash on the back end. A 500 does not mean "try something
completely different", it means "go look at the logs to see exactly what
exception was thrown, and fix the relevant part of your code".
So the next step would be: Go back to using OAuth 2.0 with Client IDs. When
you see 500 errors, don't abandon your approach, but check the request logs
in the console (Logging -> Logs) to see what went wrong, and go from there.
Feel free to post the stack trace details if you need help interpreting
them.
On Sunday, July 17, 2016 at 12:04:08 AM UTC-4, Ridhwanul Haque wrote:
>
> I was making this app where it gets data from Google Spreadsheet
> This is the code I used to get data from my Spreadsheet :
>
> json_key = json.load(open('service.json'))
> scope = ['https://spreadsheets.google.com/feeds']
> credentials = SignedJwtAssertionCredentials(json_key['client_email'],
> json_key['private_key'], scope)
> self.gc = gspread.authorize(credentials)
> self.sheet = self.gc.open('Order Database').sheet1
> self.menuSheet = self.gc.open('Menu and Stocking').sheet1
> return self.menuSheet.get_all_values()
>
> At the beginning the code was working fine, I was using OAuth 2.0 client
> IDs.
> Later when I was working with my android app, to get the data from the
> website on that url, I started getting Internal Server 500 error, and I can
> access to that url even from chrome where other part of my website works
> fine. While searching for solution, I found some people saying to use a API
> Keys, so I created a server key and even used that, this is the android
> code :
>
> HttpClient client = new DefaultHttpClient();
> HttpGet request =new HttpGet(url);
> request.addHeader("x-api-key",apikey);
> HttpResponse response = client.execute(request);
> BufferReader rd = new BufferReader(new InputStreamReader(response.
> getEntity().getContent()));
> String line = rd.readLine();
>
> The code works fine, at least thats what I think. Every time I get the
> Internal Server Error 500, if I deploy it again, it starts working fine,
> but only for a while, soon it starts showing the same error. Looking
> through the Dashboard of my project I found some detail of the error so I
> will also include that here :
>
> HTTPError: 401: <HTML> <HEAD> <TITLE>Unauthorized</TITLE> </HEAD> <BODY
> BGCOLOR="#FFFFFF" TEXT="#000000"> <H1>Unauthorized</H1> <H2>Error 401</H2>
> </BODY> </HTML>
>
> 1.
> 1. at request (/base/data/home/apps/s~gowcanteen/
> 1.394247265273324301/lib/gspread/httpsession.py:75
>
> <https://console.cloud.google.com/debug/fromlog?appModule=default&appVersion=1&file=%2Fbase%2Fdata%2Fhome%2Fapps%2Fs~gowcanteen%2F1.394247265273324301%2Flib%2Fgspread%2Fhttpsession.py&line=75&project=gowcanteen>
> )
> 2. at get (/base/data/home/apps/s~gowcanteen/1.394247265273324301/
> lib/gspread/httpsession.py:79
>
> <https://console.cloud.google.com/debug/fromlog?appModule=default&appVersion=1&file=%2Fbase%2Fdata%2Fhome%2Fapps%2Fs~gowcanteen%2F1.394247265273324301%2Flib%2Fgspread%2Fhttpsession.py&line=79&project=gowcanteen>
> )
> 3. at get_cells_feed (/base/data/home/apps/s~gowcanteen/
> 1.394247265273324301/lib/gspread/client.py:250
>
> <https://console.cloud.google.com/debug/fromlog?appModule=default&appVersion=1&file=%2Fbase%2Fdata%2Fhome%2Fapps%2Fs~gowcanteen%2F1.394247265273324301%2Flib%2Fgspread%2Fclient.py&line=250&project=gowcanteen>
> )
> 2.
> 3.
> 1. at getMenuItems (/base/data/home/apps/s~gowcanteen/
> 1.394247265273324301/server.py:24
>
> <https://console.cloud.google.com/debug/fromlog?appModule=default&appVersion=1&file=%2Fbase%2Fdata%2Fhome%2Fapps%2Fs~gowcanteen%2F1.394247265273324301%2Fserver.py&line=24&project=gowcanteen>
> )
> 2. at API_MENU (/base/data/home/apps/s~gowcanteen/
> 1.394247265273324301/main.py:61
>
> <https://console.cloud.google.com/debug/fromlog?appModule=default&appVersion=1&file=%2Fbase%2Fdata%2Fhome%2Fapps%2Fs~gowcanteen%2F1.394247265273324301%2Fmain.py&line=61&project=gowcanteen>
> )
> 3. at dispatch_request (/base/data/home/apps/s~gowcanteen/
> 1.394247265273324301/lib/flask/app.py:1461
>
> <https://console.cloud.google.com/debug/fromlog?appModule=default&appVersion=1&file=%2Fbase%2Fdata%2Fhome%2Fapps%2Fs~gowcanteen%2F1.394247265273324301%2Flib%2Fflask%2Fapp.py&line=1461&project=gowcanteen>
> )
> 4. at full_dispatch_request (/base/data/home/apps/s~gowcanteen/
> 1.394247265273324301/lib/flask/app.py:1475
>
> <https://console.cloud.google.com/debug/fromlog?appModule=default&appVersion=1&file=%2Fbase%2Fdata%2Fhome%2Fapps%2Fs~gowcanteen%2F1.394247265273324301%2Flib%2Fflask%2Fapp.py&line=1475&project=gowcanteen>
> )
> 5. at handle_user_exception (/base/data/home/apps/s~gowcanteen/
> 1.394247265273324301/lib/flask/app.py:1381
>
> <https://console.cloud.google.com/debug/fromlog?appModule=default&appVersion=1&file=%2Fbase%2Fdata%2Fhome%2Fapps%2Fs~gowcanteen%2F1.394247265273324301%2Flib%2Fflask%2Fapp.py&line=1381&project=gowcanteen>
> )
> 6. at full_dispatch_request (/base/data/home/apps/s~gowcanteen/
> 1.394247265273324301/lib/flask/app.py:1477
>
> <https://console.cloud.google.com/debug/fromlog?appModule=default&appVersion=1&file=%2Fbase%2Fdata%2Fhome%2Fapps%2Fs~gowcanteen%2F1.394247265273324301%2Flib%2Fflask%2Fapp.py&line=1477&project=gowcanteen>
> )
> 7. at wsgi_app (/base/data/home/apps/s~gowcanteen/
> 1.394247265273324301/lib/flask/app.py:1817
>
> <https://console.cloud.google.com/debug/fromlog?appModule=default&appVersion=1&file=%2Fbase%2Fdata%2Fhome%2Fapps%2Fs~gowcanteen%2F1.394247265273324301%2Flib%2Fflask%2Fapp.py&line=1817&project=gowcanteen>
> )
>
>
> I am new to developing and have very little knowledge about OAuths and
> Credentials, so there might be issues that I do not know and thats why
> unable to find the problem and fix it. I have added everything that I could
> think of that could have been related to this issue, so please I ask for
> your help.
>
>
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-appengine/68a3b243-cfc5-4556-a2c3-f1a50aa888b9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
