Google Drive Connector error: "Too Many Requests, Message: The remote server returned an error: (429)"

[Andrea_Bertazzo]

The Qlik Google Drive Web Storage Provider connector shows this error message when loading data from spreadsheets:

HttpStatusCode: 429, StatusCode: 429, StatusDescription: Too Many Requests, Message: The remote server returned an error: (429) Too Many Requests., ResponseBody: { "error": { "code": 429, "message": "Quota exceeded for quota metric 'Read requests' and limit 'Read requests per minute' of service 'sheets.googleapis.com' for consumer 'xxxx_xxxxx'.", "status": "RESOURCE_EXHAUSTED", "details": [ { "@type": "type.googleapis.com/google.rpc.ErrorInfo", "reason": "RATE_LIMIT_EXCEEDED" ....

The error message can be seen by different users.

Environment

• Qlik Google Drive Web Storage Provider connector, all versions

Cause

The error message is shown when the connector passes the 60 calls per minute for a user. This is a current limitation that the connector inherits from the Google API.

Resolution

The limitation is currently part of the connectors design. A post has been open in the Qlik Community to remove it. Here are two possible workarounds. Their implementation is left to the user:

1. It is possible to connect to Google Drive using the Rest connector. It will be necessary to authenticate against the "paid API access" since Google asks for a fee to exceed the 60 calls per minute limit.
2. It is possible to try with multiple users and thus gets more calls per minute.

Internal Investigation ID

QB-10009