Wildcard Load in Dropbox for Qlik Sense Business Cloud

[George_Metrakos]

Hello all,

I have been unable to find if anyone has resolved the issue of creating a wildcard load from within a dropbox folder using the Qlik Dropbox Connector in Business Cloud.  Is this possible?

Is a wildcard load only possible from FTP/SFTP?

Thanks

[stevedark]

Hi Chris,

I don't disagree with any of that. If the FileList function didn't exist for DropBox then that would have been for good reason, and that's fine. I only think it is a bit odd that the same function exists as for a folder but it works in a different way.

Totally agree that using the MetaData connector is a better approach, as this will be more efficient and there are a lot of filtering options and interesting extra data.

The biggest challenge, that I had and I know others do also, is knowing that after you set up your connection to the service to load files that you also need to set up a separate connector to get the metadata. Some sign posts that the other connector exists and why it should be used when you set up the main connector may be all that is needed?

Cheers,

Steve

[chrisbrain]

Hi Steve - Yea I think docs and/or some improved signposting as you use the connectors could help here also.

[stevedark]

As I can see that it is something that people are going to be increasingly wanting with Cloud being an obvious focus for Qlik, I have written these notes up into a blog post, which can be found here:

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

Hopefully people will find this if they are stuck loading from one of those connectors and it will point them in the right direction.

Steve

[Wallibee]

I have a similar problem in loading from my one drive. on my Qs desktop I load the files with no issues since the desktop supports wildcards. In the QS cloud environment, I am unable to generate a loop that will load the files from excel.

Is there any example loop with regards to OneDrive ?

[stevedark]

Hi @Wallibee 

One Drive was not available at the time I wrote that blog, but the implementation is very similar. I don't have code to hand, but believe I have posted it on another thread on Community. 

Steve