topic Re: Qlik WebConnectors - GetWorksheet Stopped working in Integration, Extension & APIs

Qlik WebConnectors - GetWorksheet Stopped working

pauljohansson — Tue, 04 May 2021 20:11:52 GMT

Hej

Suddenly my connection link to a shared google spreadsheet stopped worked. Im using Web Connectors - Connector Version: 1.2.0.16945

The only thing that changed is that there was an added row on the sheet. I'm still able to authenticate and list the worksheetKeys

But when I want to retrieve an actual column with data with GetWorksheet, I recieve:

"There was an error running the table (Failed on attempt 1 to GET. (The remote server returned an error: (401) Unauthorized.))"

Any ideas or pointers?

thanks in advance

Paul

rwunderlich — Tue, 04 May 2021 20:55:37 GMT

I believe that is a known current problem. Contact Qlik Support for workaround and status.

-Rob

rzenere_avvale — Wed, 05 May 2021 06:46:57 GMT

Hey @pauljohansson ,
as @rwunderlich mentioned, this is a known issue. Take a look at this post: Issue identified with Google Spreadsheet Connector

I hope this helps,
Riccardo