topic Google Spreadsheet ListWorksheet Failes? in Connectivity & Data Prep

Google Spreadsheet ListWorksheet Failes?

Luuk — Mon, 13 Dec 2021 21:41:14 GMT

Hello everyone,

This used to work but:

If I go to the Qlik Google Drive & Spreadsheets Connector an run ListSpreadsheets, I get a list of valid spreadsheets. I copy paste the Spreadsheet Key into the ListWorksheet, and this gives me the following error:

There was an error running the table (Failed on attempt 1 to GET. (The underlying connection was closed: An unexpected error occurred on a send.))

I tried this with several sheets and several (Google) users.

Please advise.

Re: Google Spreadsheet ListWorksheet Failes?

chrisbrain — Thu, 25 Jun 2020 09:34:11 GMT

Hi - This is working for me. Can you confirm what version of Qlik Web Connectors you are using?

The 'The underlying connection was closed' could also suggest that the connection is being terminated by the server or some other network device on the way. Is it possible something changed with your network/proxy recently?

Re: Google Spreadsheet ListWorksheet Failes?

stevedark — Thu, 25 Jun 2020 10:00:12 GMT

Hi,

It's working here for me.

Are you on the latest version of the connectors?

If you go to the log files (back at the top menu) is anything shown in the logs that indicates what went wrong?

Steve

Re: Google Spreadsheet ListWorksheet Failes?

Luuk — Thu, 25 Jun 2020 10:27:23 GMT

Thanks you both for responing on this short notice.

The version I am running is: Version: March-2020 (2.77.1.23956)

It could be that network components (firewall?) have been changed without me knowing; but then I would expect the ListSpreadsheets to also not work....

This message is in the logfiles:

<WebExcp>System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a send. ---> System.IO.IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
--- End of inner exception stack trace ---

But I can imagine that that is not going to bring us any further....

Kind regards, Luuk

Re: Google Spreadsheet ListWorksheet Failes?

chrisbrain — Thu, 25 Jun 2020 13:28:34 GMT

This is a long shot but have you got a virus checker running? I think I have seen issues before where that closes a connection. If so might be worth trying the request with it disabled.

Re: Google Spreadsheet ListWorksheet Failes?

stevedark — Thu, 25 Jun 2020 14:47:35 GMT

I had SFTP falling foul of something on my domestic router blocking things.

Tried with mobile tethering and it was fine.

Same issue was there with FileZilla though - so not a QWC issue.

The joys of remote working!