我有下面生成错误的代码:
GoogleAppClient.errors.httperror:<httperror 429请求时https://sheets.googleapis.com/v4/spreadsheets/1fjivwqu2aaca06dpkoh20zqygyyq8rbzj8xwzgglcs4/values/1.%20forge%20operator%20shift%20form%20-%20v1.12%211%3a200?alt=json返回“超过了服务配额指标‘读取请求’和限制‘每用户每分钟读取请求’的配额”“sheets.googleapis.com”用于消费者“项目编号:1”。详细信息:“[{@type':'type.googleapis.com/google.rpc.errorinfo','reason':'rate_limit_excelled','domain':'googleapis.com','metadata':{'quota_limit':'readrequestsperminuteperuser','projects/1','service':'sheets.googleapis.com','quota_metric':'sheets.googleapis.com/read requests'}]>
我想捕捉错误,以指数方式避免频繁调用api。但是,当我运行脚本时,我不确定如何针对这个特定错误。在“except”行中,我尝试了httperror,429,“googleapiclient.errors.httperror”。如何捕获上面的错误?
# gets data from google spreadsheet
def fetch_data_from_google_spreadsheet(SPREADSHEET_ID, google_credentials):
# looks at connecting to the google api service
# If modifying these scopes, delete the file token.pickle.
SCOPES = ['https://www.googleapis.com/auth/spreadsheets.readonly']
try :
service = build('sheets', 'v4', credentials=google_credentials)
# Call the Sheets API
sheet = service.spreadsheets()
# Returns all sheets (tabs) in a spread sheet
time.sleep(3)
return_sheet_ID = sheet.get(spreadsheetId=SPREADSHEET_ID, ranges=None, includeGridData=None, x__xgafv=None).execute()
# extracts just the sheets
individual_sheets = return_sheet_ID.get("sheets")
list_of_dict_sheets = []
# loops through each tab and returns the rows within each sheet
for item in individual_sheets:
# returns the sheet names to pass into sheet values
RANGE_NAME = item.get("properties").get("title") + "!" + "1" + ":" + str(item.get("properties").get("gridProperties").get("rowCount"))
time.sleep(3)
# returns the rows within the spreadsheets
list_of_dict_sheets.append (sheet.values().get(spreadsheetId=SPREADSHEET_ID,
range=RANGE_NAME).execute())
df2 = None
# loops through each sheet and returns the details
for each_sheet in list_of_dict_sheets:
df = pd.DataFrame(each_sheet.get("values"))
df = df.rename(columns=df.iloc[0])
df = df.iloc[1:]
df2 = pd.concat([df,df2])
return df2
except Exception as e:
print("Unexpected error:", sys.exc_info()[0])
暂无答案!
目前还没有任何答案,快来回答吧!