BigQuery Python API GET Tables

Question

I'm trying to access my data using the BigQuery API Python Library but can't seem to do so. My code is below. The data that I used in the code was also used here and it worked there but in my code throws a TypeError: 'HttpRequest' object has no attribute '__getitem__' error.

If I just do a print response instead, output is <googleapiclient.http.HttpRequest object at 0x1031d0d50>.

Any help will be much appreciated.

from apiclient.discovery import build
import logging
from oauth2client.client import GoogleCredentials
logging.basicConfig()
credentials = GoogleCredentials.get_application_default()
bigquery_service = build('bigquery', 'v2', credentials=credentials)
tables = bigquery_service.tables()
response= tables.get(projectId=project_id, datasetId=dataset_id, tableId=table_id)
print response['kind'] #causes TypeError: 'HttpRequest' object has no attribute '__getitem__'

Have you debugged the response object ? I think tables.get wont return the desired output — Kalanamith
– Kalanamith, Commented Jun 17, 2016 at 11:20
@Kalanamith I'm not too sure how one would go about debugging the response object? By adding unicode methods, do you mean, unicode(project_id) , unicode(dataset_id) etc ? If so, then I just tried that but to no avail :( — niknation
– niknation, Commented Jun 18, 2016 at 3:31
docs.python-requests.org/en/master/api this has indepth insights on debugging and its possible — Kalanamith
– Kalanamith, Commented Jun 20, 2016 at 6:32

Graham Polley · Accepted Answer · 2016-06-18 13:55:23Z

2

You are missing .execute() at the end of LN 8:

[..]
response= tables.get(projectId=project_id, datasetId=dataset_id, tableId=table_id).execute()
[..]

answered Jun 18, 2016 at 13:55

Graham Polley

14.8k9 gold badges54 silver badges89 bronze badges

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

Collectives™ on Stack Overflow

BigQuery Python API GET Tables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related