I have error in Google Drive API Requests: "Sorry, you have exceeded your sharing quota.", but it was few requests
It was 235 requests evenly in five hours, and 30 errors last time (screenshot 1). All last requests get errors.
But all limits are full at console (screenshot 2).
What I do wrong?
screenshot 1
Requests is:
#! /usr/bin/env python
# -*- coding: utf-8 -*-
import sys, json, base64, time
import httplib2
import apiclient.discovery
from oauth2client.service_account import ServiceAccountCredentials
input_data = json.loads(base64.b64decode(sys.argv[1]))
user_mail = input_data['user_mail']
admin_mail = input_data['admin_mail']
donor_spreadsheet_id = input_data['donor_spreadsheet_id']
#donor_spreadsheet_id = '*****' #hided
CREDENTIALS_FILE = '*****.json' #hided
scope = ['https://www.googleapis.com/auth/spreadsheets', 'https://www.googleapis.com/auth/drive']
credentials = ServiceAccountCredentials.from_json_keyfile_name(CREDENTIALS_FILE, scope)
httpAuth = credentials.authorize(httplib2.Http())
driveService = apiclient.discovery.build('drive', 'v3', http=httpAuth)
try:
new_spreadsheet = driveService.files().copy(fileId=donor_spreadsheet_id).execute()
except Exception as e:
print('Copy error: ', json.loads(e.content)['error']['errors'][0]['message'])
try:
shareRes = driveService.permissions().create(
fileId = new_spreadsheet['id'],
body = {'type': 'user', 'role': 'writer', 'emailAddress': user_mail},
fields = 'id'
).execute()
except Exception as e:
print('Adding user mail error: ', json.loads(e.content)['error']['errors'][0]['message'])
new_url = 'https://docs.google.com/spreadsheets/d/' + new_spreadsheet['id'] + '/'
print(new_url)
