Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I got this working, however, the code I used is not fundamentally different from the snippet you posted. Just in case you'd like to diff my version with yours, attached below is a complete copy of a Python program that worked for me. I initially got a 403, just like you, which was due to inheriting your project id :). After updating that value to use my project ID, I got a correct bucket listing. Two things to check:</p> <ol> <li><p>Make sure the project id you are using is correct and has the "Google Cloud Storage JSON API" enabled on the Google Developer Console "Services" tab (it's a different service from the other Google Cloud Storage API).</p></li> <li><p>Make sure you are loading the service accounts private key exactly as it came from the developer's console. I would recommend reading it into memory from the file you downloaded, as I've done here, rather than trying to copy it into a string literal in your code. </p></li> </ol> <hr> <pre><code>#!/usr/bin/env python import pprint import oauth2client from oauth2client.client import SignedJwtAssertionCredentials import httplib2 from apiclient.discovery import build f = open('key.p12', 'r') key = f.read() f.close() credentials = SignedJwtAssertionCredentials( 'REDACTED', key, scope='https://www.googleapis.com/auth/devstorage.full_control') http = httplib2.Http() http = credentials.authorize(http) service = build("storage", "v1beta1", http=http) # Build the request request = service.buckets().list(projectId="REDACTED") # Diagnostic pprint.pprint(request.headers) pprint.pprint(request.to_json()) # Do it! response = request.execute() pprint.pprint(response) </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POCannot get service account authorization to work on GCS script using Python client lib APIs
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMarc Cohen
    1. USMarc Cohen
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCannot get service account authorization to work on GCS script using Python client lib APIs
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COHi Marc, Thanks for the positive response. I initially thought that my lack of having the GCS JSON API enabled was the problem, but then I was able to get an OK and a bucket list from the web page I mentioned above. Maybe that page uses a different authentication scheme... I requested access to the JSON API yesterday and it has not yet been granted. I'll try again when I get that approval.
      singulars
      1. PO
      1. USDavid V
    2. COIf by the web page you mean the Google Cloud Storage web UI, that uses the older XML API, not the new JSON API so that wouldn't necessarily verify your access via the JSON API. Given you requested access yesterday, I'm betting that was your problem. At any rate, comment here if you don't get access soon or get access and it doesn't work.
      singulars
      1. PO
      1. USMarc Cohen
    3. COThanks Marc - The approval came through just now and it works as expected. I was thrown because the web-based api-explorer (https://developers.google.com/apis-explorer/#p/storage/v1beta1/storage.buckets.list?projectId=) returns JSON, so I presumed it was using the JSON API.
      singulars
      1. PO
      1. USDavid V
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload