Insufficient tokens for quota 'ReadGroup'

[j2318]

Hi,
Can you shed some light on this error:
Error: <class 'googleapiclient.errors.HttpError'> <HttpError 429 when requesting https://sheets.googleapis.com/v4/spreadsheets/1YSo5QBlo6eagKruQIVCGmg-0q9emCKp3e892sR1o430/values/Case%20Units%21B1%3AB16?valueRenderOption=FORMATTED_VALUE&alt=json&majorDimension=COLUMNS returned "Insufficient tokens for quota 'ReadGroup' and limit 'USER-100s' of service 'sheets.googleapis.com' for consumer 'project_number:247898894239'.">
Is there way to increse this limit?
-- jacek

[nithinmurali]

I am not sure which quota you are exceeding. Either way in the Api quota page there is an option apply for higher quota you could try that.

[j2318]

It looks like the 100 requests per sec. I assume that one API pygsheets translates into one Google's API call, but I don't think I call your API 100 times a sec. Anyway I will run more tests a let you know. ⁣Jacek Sent from BlueMail ​

…

On May 5, 2017, 13:52, at 13:52, Nithin Murali ***@***.***> wrote: Closed #78. -- You are receiving this because you authored the thread. Reply to this email directly or view it on GitHub: #78 (comment)

[nithinmurali]

If you could you post your code or mention which functions you are calling, i could look into it.

[oreniko26]

I have the same problem only with the WriteGroup tokens. I'm trying to execute 178 update_cell() calls for 7 different sheets. Is it possible to somehow buffer those calls and burn less writing tokens? or does update_cell() have the ability to write multiple cell updates?

P.S
Applied for higher quota, thinking about how to deal with this in case they deny it.

[nithinmurali]

Can you please share your code which uses pygsheets

[ghanshyam-schoolbook]

Hello,
I am getting following error
"Google::Apis::RateLimitError: rateLimitExceeded: Insufficient tokens for quota 'WriteGroup' and limit 'USER-100s' of service 'sheets.googleapis.com' for consumer 'project_number:864617607794'."
Can anyone guide me how to resolve this issue

[nithinmurali]

You are making more than 100 requests per second, reduce it.