Just a polite bump.
On Monday, 20 January 2020 14:45:49 UTC+1, Dorian Kind wrote:
>
> 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/aa235789-4316-4b6f-89a7-60f0bbc9699e%40googlegroups.com.
