Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Leovalente
Contributor II
Contributor II

Loading All files in Google Drive Folder

I'm trying to load several .txt files from a google drive folder, an operation that was quite easy using qlikview, just using a * wildcard.

While reading the Drive connector documentation i found that:

"Limitations and known issues

When authoring load/store scripts for use with the Google Drive Web Storage Provider Connector, there are specific limitations to be aware of.

  • Folders and files with the same name are not supported.
  • Wildcard/masking syntax is not supported. You may only load specified individual files, or all files in a specified folder"

Ok, so if wildcard is not an option, how can at least load all files in a folder? That will be enough for me.
Thanks!

Labels (1)
2 Replies
SandraLM1
Contributor
Contributor

Same question,. Could you solve the problem?

Joseph_Musekura
Support
Support

Hi @Leovalente ,

You can use the "Google Drive and Spreadsheets" connector of our Qlik  WebConnector (https://help.qlik.com/en-US/connectors/Subsystems/Integrated_Web_Connectors_help/Content/Connectors_...)

Then use "ListFiles" to list all file on Google drive.

/joseph