Qlik Web Connectors: Qlik Google Drive & Spreadsheets Connector - 400 Error

[mccook]

Hi,

Since Monday night at 7pm we have been getting this error for any QlikView applications that use:

Qlik Web Connectors: Qlik Google Drive & Spreadsheets Connector.

There was an error running the table (Failed on attempt 1 to GET. (The remote server returned an error: (400) Bad Request.))

We've tried restarting the servers/services etc, if we switch from GetWorksheet to GetSheetValues it works (but we have over 100 connections to change...)

Any help or advice appreciated 

Thanks,

Dean

[abdulaziz]

Hi Dean

We have the same issue in the server only in (Qlik Google Drive & Spreadsheets Connector), I test on 2 PCs and same the issue.
I think the problem with API in google. 

let me know if you find the solution.  

[mccook]

https://community.qlik.com/t5/Knowledge-Base/Qlik-Web-connectors-google-spreadsheets-connector-Error...

[PadmaPriya · Accepted solution]

Hello @mccook 

Error:

<Exception>APIConnectorInterfaces.Exceptions.APIConnectorException: Failed on attempt 1 toGET. (The remote server returned an error: (400) Bad Request.) ---&gt; System.Net.WebException: Theremote server returned an error: (400) Bad Request.

Please follow the below article:

https://community.qlik.com/t5/Support-Updates-Blog/Issue-identified-with-Google-Spreadsheet-Connecto...

Thanks,

Padma Priya