Load All Files from Specified Google Drive Folder

[mlin]

I'm trying to load all files from a google drive folder using the built in google drive connector. 

It says you can load all files from a specific folder, but I haven't been able to figure out how. 

https://help.qlik.com/en-US/connectors/Subsystems/Web_Storage_Provider_Connectors_help/Content/Conne...

I have tried a loop, wild card, etc. Any ideas?

I can't use the web connector because they are xlsx files and I think you can only read google spreadsheets.

[MartW]

what is the load that you are using?

and in the google drive folder you are connected to are there only 1 filetype in there or are there multiple filetypes.

[mlin]

1 file type. Xlsx.

[MartW]

oke. with excel files in general you also need to give Qlik the sheet you want Qlik to read

can you by any change give the error and a the part in the load script where you created the loop?

this will help with debugging

[mlin]

I'm not getting an error, but it just doesn't load.

I think my issue is here:

For each File in FileList('[lib://Google_Drive/google folder path/*.xlsx]')

I think it doesn't accept the wild card from what I read here: 

https://help.qlik.com/en-US/connectors/Subsystems/Web_Storage_Provider_Connectors_help/Content/Conne...

[mlin]

I figured out that I need to use the google drive & spreadsheets connector to get the meta data from some @stevedark posts!

[stevedark]

Thanks @mlin 

For anyone else who is here looking for the same... this post gives an outline:

https://www.quickintelligence.co.uk/cloud-file-services-qlik-sense/

It's a bit old now, and there are more and better connectors than were around then, but the premise of having to load the metadata and make separate calls to then load the file is the same.

Hope that helps.