topic Re: Qlik Web Connectors: Qlik Google Drive & Spreadsheets Connector - 400 Error in App Development

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

mccook — Tue, 04 May 2021 09:18:02 GMT

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

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

abdulaziz — Tue, 04 May 2021 11:02:27 GMT

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.

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

mccook — Tue, 04 May 2021 11:13:04 GMT

https://community.qlik.com/t5/Knowledge-Base/Qlik-Web-connectors-google-spreadsheets-connector-Error-quot-The/tac-p/1804868#M2525

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

PadmaPriya — Wed, 05 May 2021 17:27:56 GMT

Hello @mccook

Error:

<Exception>APIConnectorInterfaces.Exceptions.APIConnectorException: Failed on attempt 1 toGET. (The remote server returned an error: (400) Bad Request.) ---> 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-Connector/bc-p/1805100#M1542

Thanks,

Padma Priya