Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
twixMiller0113
Contributor III
Contributor III

Google Drive & Spreadsheets Connector - 404 Error

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.

twixMiller0113_1-1631562030528.png

 

 

Thanks!

8 Replies
chrisbrain
Partner - Specialist II
Partner - Specialist II

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

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
twixMiller0113
Contributor III
Contributor III
Author

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

chrisbrain
Partner - Specialist II
Partner - Specialist II

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

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
twixMiller0113
Contributor III
Contributor III
Author

@chrisbrain nope, none of the keys work 

chrisbrain
Partner - Specialist II
Partner - Specialist II

Can you confirm you web connectors version?

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

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
twixMiller0113
Contributor III
Contributor III
Author

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. 

chrisbrain
Partner - Specialist II
Partner - Specialist II

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?

 

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
twixMiller0113
Contributor III
Contributor III
Author

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

twixMiller0113_0-1631796637322.png