topic Re: Load All Files from Specified Google Drive Folder in App Development

Load All Files from Specified Google Drive Folder

mlin — Tue, 19 Sep 2023 22:14:51 GMT

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/Connectors_StorageProvider/Storage%20provider%20connectors/Google-Drive-storage-provider-connector.htm

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.

Re: Load All Files from Specified Google Drive Folder

MartW — Wed, 20 Sep 2023 09:34:04 GMT

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.

Re: Load All Files from Specified Google Drive Folder

mlin — Wed, 20 Sep 2023 14:09:16 GMT

1 file type. Xlsx.

Re: Load All Files from Specified Google Drive Folder

MartW — Wed, 20 Sep 2023 14:31:44 GMT

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

Re: Load All Files from Specified Google Drive Folder

mlin — Wed, 20 Sep 2023 17:46:04 GMT

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...

Re: Load All Files from Specified Google Drive Folder

mlin — Wed, 20 Sep 2023 23:26:37 GMT

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

Re: Load All Files from Specified Google Drive Folder

stevedark — Thu, 21 Sep 2023 07:55:48 GMT

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.