Qlik Community

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
Jamie_Gregory
Community Manager
Community Manager

Hello Qlik Users!

An issue has been identified with the Google Spreadsheet Connector when using “GetWorksheet”. The issue affects:

  • Qlik Web Connectors December 2020
  • Qlik Sense Business
  • Qlik Sense Enterprise SaaS

 

Two error messages can occur, depending on the platform.

Qlik Web Connectors on-premise error message

<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.

Qlik Cloud Services error message

HttpStatusCode: BadRequest, StatusCode: 400, StatusDescription: Bad Request, Message: The remote server returned an error: (400) Bad Request., ResponseBody: Error 400 (Bad Request)!!1

There is currently a workaround, which you can find in the article:

Qlik Web connectors, google spreadsheets connector Error "The remote server returned an error: (400)...

R&D is currently investigating the issue. Qlik Support will update the article with information as it comes in.

Kind regards,

Qlik Digital Support

Edited to add: There is also the Known Issues for Qlik Sense SaaS article. Please bookmark this page to use for future reference. 

Update 5/6/2021 at 9:45 am EDT: Qlik is developing an update to the Connector package to use an improved getWorksheetmethod. We expect the update to be available Monday. When the update is released, we will also post instructions on how to move to the new method, along with considerations for testing.

Update 5/11/2021 at 9:04 am EDT: A fix was pushed out to Qlik Sense Enterprise SaaS on Friday, May 7th. A patch is now available for Qlik Web Connectors. Please see Qlik Web Connectors Patch available for Google Spreadsheet Connector Issue for more information.

6 Comments