Qlik WebConnectors - GetWorksheet Stopped working

[pauljohansson]

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 · Accepted solution]

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

-Rob

[rzenere_avvale]

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