topic Re: Google Drive & Spreadsheets Connector - 404 Error in Connectivity & Data Prep

Google Drive & Spreadsheets Connector - 404 Error

twixMiller0113 — Mon, 13 Sep 2021 19:41:28 GMT

Hello!

I am having an issue with the Google Drive & Spreadsheets Connector where I'm getting a 404 Error when trying to run the ListWorksheets table. I can't make the sheets public.. how can I fix this? And are there any alternatives to using ListWorksheets.

Also, the google sheets we're using our v3..I know google has switched over to sheets v4 so not sure if this affects anything.

Thanks!

Re: Google Drive & Spreadsheets Connector - 404 Error

chrisbrain — Tue, 14 Sep 2021 10:17:12 GMT

Hi - Are you getting the value for the 'Spreadsheet Key' parameter from the key column of the ListSpreadsheets table?

Re: Google Drive & Spreadsheets Connector - 404 Error

twixMiller0113 — Tue, 14 Sep 2021 11:02:39 GMT

hello @chrisbrain yes. I also double checked that it matched the google spreadsheet and it does.

Re: Google Drive & Spreadsheets Connector - 404 Error

chrisbrain — Tue, 14 Sep 2021 11:34:40 GMT

OK thanks. Are you able to retrieve any sheets from any other spreadsheets?

Re: Google Drive & Spreadsheets Connector - 404 Error

twixMiller0113 — Tue, 14 Sep 2021 11:45:51 GMT

@chrisbrain nope, none of the keys work

Re: Google Drive & Spreadsheets Connector - 404 Error

chrisbrain — Tue, 14 Sep 2021 12:28:45 GMT

Can you confirm you web connectors version?

And maybe take a look in the logs for anything which might look relevant?

Re: Google Drive & Spreadsheets Connector - 404 Error

twixMiller0113 — Tue, 14 Sep 2021 15:40:14 GMT

Hi @chrisbrain we are using version 'May-2019 (2.59.1.26570)'. The only relevant information I see is that the sheets v3 API has been turned down. Would that be the issue? If so, would that mean we need to upgrade our connector? My only issue with upgrading the connector is that according to qlik's help website, we'd have to turn down all the connectors just to upgrade one.

Re: Google Drive & Spreadsheets Connector - 404 Error

chrisbrain — Wed, 15 Sep 2021 09:38:20 GMT

Hi,

Yes that does sound like the issue - in general we recommend updating to the latest version.

I am not sure what you mean by 'turn down all the connectors' - do you mean you will have to upgrade them all just to fix this one issue?

Re: Google Drive & Spreadsheets Connector - 404 Error

twixMiller0113 — Thu, 16 Sep 2021 12:50:43 GMT

@chrisbrain correct. But I just read the snippet below so I think we should be okay..