使用google服务帐户时出现授权问题.超过未经验证使用的每日限制.继续使用需要注册

Question

我正在为融合表编写一个python包装器。我决定使用谷歌服务帐户访问该服务。我的代码是:

import httplib2
from googleapiclient.discovery import build
from oauth2client.service_account import ServiceAccountCredentials
scopes = ['https://www.googleapis.com/auth/fusiontables']
credentials = ServiceAccountCredentials.from_json_keyfile_name('__Remak APIS-37c11e21531ad.json', scopes)
http = httplib2.Http()
if not credentials.access_token:
    credentials.refresh(http)
service = build('fusiontables', 'v2', http=http)

def test():
    table_id = '1esH-YayZegZH69VsiVBq0YK9hxgP-JWTCljRuQUZy'
    print(service.query().sql(sql='SELECT * FROM {}'.format(table_id)).execute(http=http))

if __name__ == '__main__':
    test()

输出为:

googleapiclient.errors.HttpError: <HttpError 403 when requesting https://www.googleapis.com/fusiontables/v2/query?alt=json&sql=SELECT+%2A+FROM+1esH-YayrtegZH6VsiVBq0YK9hxgP-JWTCljRuQUZy returned "Daily Limit for Unauthenticated Use Exceeded. Continued use requires signup.">

我刚刚启用了这个API，这就是为什么每天的限制肯定没有达到。我也试着在类似的题目中寻找答案，但是没有成功。

提前感谢

Answer 1

终于成功了:缺了一个部分: credentials.authorize(http) 现在看起来没问题了

代码是:

import httplib2
from googleapiclient.discovery import build
from oauth2client.service_account import ServiceAccountCredentials
scopes = ['https://www.googleapis.com/auth/fusiontables']
KEY = '__Remak APIS-a8cd56ca2b4e.json'
credentials = ServiceAccountCredentials.from_json_keyfile_name(KEY,     scopes)
http = httplib2.Http()
credentials.authorize(http)
if not credentials.access_token:
    credentials.refresh(http)
fusiontables = build('fusiontables', 'v2', http=http)

def test():
    table_id = '1esH-YayZegZH97VsiVBq0YK9hxgP-JWTCljRuQUZy'
    print(fusiontables.query().sql(sql='SELECT * FROM     {}'.format(table_id)).execute())

if __name__ == '__main__':
    test()