Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. READ MORE

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

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Francisco_Fernandez

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

Last Update:

May 10, 2022 3:15:54 PM

Updated By:

Jamie_Gregory

Created date:

May 4, 2021 3:05:00 AM

Attachments

When using the google drive & spreadsheet the table "GetWorksheet"  it might fail with one of the following messages depending on the platform used 

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.

Cloud error message:

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

 

Environment

 

Current Status

 

This issue has been resolved in a fix that was pushed to Qlik Sense Enterprise SaaS and Qlik Sense Business on Friday, May 7th. A patch is available for Qlik Web Connectors, December 2020 Patch 2. The patch can be found on the Qlik Download site.

GetWorksheet is now deprecated. GetWorksheetV2 or GetSheetValues should be used moving forward.

Workarounds

 

If the Gsheet has to be Private:

Alternatively, to "GetWorksheet" the "GetSheetValues" and the parameters shown in the attached PDF, should return the same data as the table "GetWorksheet".  Please, make sure to double-check that the data matches before doing any changes to the apps.

If the Gsheet can be Public:

Making the sheet public also solves the problem and allows you to keep using the table "GetWorksheet", but please note that we only suggest this workaround for very specific cases where the data is already public or doesn't contain confidential information.

 

Cause

Qlik Web Connectors used a legacy method for getWorksheet. A change to this API by Google caused the defect. This has been logged with Qlik as product Defect ID: QCWP-3096.

Labels (1)
Comments
sid-ri-001
Contributor
Contributor

Provided the log in the support case.

As we still dont know the root cause, we are not able to fix this and our reload tasks are still failing.

AdamG
Contributor II
Contributor II

@Francisco_Fernandez We are slowly unclogging the app reload pipeline. Looks like Google Web Connector is working fine again. Thanks for the fix 😊💪!

btremain_s
Contributor
Contributor

also still not working here, will supply the log files via support ticket

p_verkooijen
Partner - Specialist
Partner - Specialist

@Francisco_Fernandez what is the underlying reason of eventually deprecating the GetWorksheet since the issue seems to have been resolved at Googles side ? At least for now.

Version history
Last update:
‎2022-05-10 03:15 PM
Updated by: