Hi all,
we were wondering if there's any documentation about the different kind of
error responses that are connected to the Sheets API quota(s). Previously,
we've seen 429 errors that looked like this:
{
"error" : {
"code" : 429,
"errors" : [
{
"domain" : "global",
"message" : "Insufficient tokens for quota 'ReadGroup' and
limit 'USER-100s' of service 'sheets.googleapis.com' for consumer
'project_number:1234567890'.",
"reason" : "rateLimitExceeded"
}
],
"message" : "Insufficient tokens for quota 'ReadGroup' and limit
'USER-100s' of service 'sheets.googleapis.com' for consumer 'project_number:
1234567890'.",
"status" : "RESOURCE_EXHAUSTED"
}
}
At some point, the content of these errors changed somewhat, looking like
this:
{
"error" : {
"code" : 429,
"errors" : [
{
"domain" : "global",
"message" : "Quota exceeded for quota group 'ReadGroup' and
limit 'Read requests per user per 100 seconds' of service
'sheets.googleapis.com' for consumer 'project_number:1234567890'.",
"reason" : "rateLimitExceeded"
}
],
"message" : "Quota exceeded for quota group 'ReadGroup' and limit
'Read requests per user per 100 seconds' of service 'sheets.googleapis.com'
for consumer 'project_number:1234567890'.",
"status" : "RESOURCE_EXHAUSTED"
}
}
And recently we've seen errors that look like this:
{
"error" : {
"code" : 429,
"errors" : [
{
"domain" : "global",
"message" : "Resource has been exhausted (e.g. check quota).",
"reason" : "rateLimitExceeded"
}
],
"message" : "Resource has been exhausted (e.g. check quota).",
"status" : "RESOURCE_EXHAUSTED"
}
}
The only article in the Sheets API documentation that seems relevant is the
one about Usage Limits <https://developers.google.com/sheets/api/limits>.
But there doesn't seem to be much information about the messages of the
quota errors themselves, which makes it hard to correctly implement a sound
exponential backoff strategy.
I would be thankful for any pointers where the exact structure and content
of these errors is documented.
Thanks & best regards,
Dorian
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-spreadsheets-api/0b0f2780-38e9-4eb1-a0fb-ca6448087332%40googlegroups.com.
