Google Drive Direct Folder Connection

[malradi88]

To Whom it May Concern,

I hope this finds you well. Is there a way to create a connection to a google drive folder? Using the Google Drive & Sheets connector in Qlik Web Connectors, and the regular web file connector I am able to connect to individual google sheets but not a specific folder.  Thank you for your support!

Best,

Mohammed

[Henri_Rufin]

Now I am looking to do it with xlsx files instead 

[stevedark]

Hi @Henri_Rufin 

Is that with XLSX files stored in Google Drive? If so, that is much closer to the solution I describe in this blog post: https://www.quickintelligence.co.uk/cloud-file-services-qlik-sense/

The difference with the example code in this post is purely that your search will need to be for xlsx files and the format specifier will need to change from (txt) to (ooxml, etc.). In order to get the right format specifier, load the spreadsheet from a standard file location (such as DataFiles) and then copy and paste the format string from there to where you load from the Google Drive Files connector.

Good luck!

[Henri_Rufin]

As far as I know you can't which is why I suggested a workaround in this thread.