Hope some one can share with me , does the dropbox connector able to solve my issue ?

Now i am using QS 3.2 , and i have upload the QVF file to cloud. now i like to make it automatic update the raw data, instead of manually upload the QVF file,

My question is does dropbox connector able to solve the problem. What i mean is my raw data and put at dropbox and Qlik dropbox connector will automatic reload thru the dropbox connector to update my raw date to cloud.

Business cloud can be set up to automatically update once per day (hopefully it will be changed to make it at least hourly before too long). This can only update from Sales force or files manually uploaded to the cloud. Eventually Qlik plan to have an automatic link to an in house server and many other cloud links apart from SalesForce. But it seems this could be some time off. So what to do

One option is to run the personal edition and create QVDs. And then to manually upload these QVDs. Qlik will then do the rest.

The Dropbox process could be used to simplify this process. For example create QVDs as above and save to a folder linked to Dropbox. Dropbox and Qlik business cloud will then do the rest. Likewise save say an Excel file to a linked Dropbox folder

To clarify - the log post is actually talking about the REST Connector that is included with Qlik Sense Cloud Business. There is a link in the post that references a discussion thread: Update your Qlik Sense Cloud Business workgroup data files with REST and Dropbox - Proof of Concept - Currently, QSCB allows you to connect to files that you upload, Salesforce, Qlik DataMarket and now REST based sources. QSCB also includes a scheduler that will allow you to refresh your Qlik Sense app with new data from these sources. However, if you are using FILES, you would need to first MANUALLY update / upload the new file to the group data import area - there isn't any automated process to do this. So if you have a Qlik Sense app that is scheduled to refresh daily - and that app is using files as a data source, then you need to make sure the new updated file has been uploaded first.

That being said - I created a proof of concept (POC) that will allow you to use the REST Connector AND the Dropbox REST API - a cloud-based file storage solution - in this case I used Dropbox and their provided REST / HTTP API. What this means - is that you can securely store your files in a dropbox folder instead of Qlik Sense Cloud - and create a Qlik Sense Cloud Business REST Connector that accesses the file on Dropbox instead and use that as your data source. THEN you can have some third party tool (such as windows task scheduler) copy a new updated file from the source system to the dropbox folder - and when the Qlik Sense scheduler refreshes the app - it will use the latest data from that file. Again this was more of a POC to help those that wanted to refresh Qlik Sense apps from files, without having to manually import / upload the new file to Qlik Sense Cloud Business.

NOTE: If the file is publicly available AND available in a public Dropbox folder and therefore is NOT in a SECURE LOCATION - you can simply reference with a public link as long as the file is JSON, XML or CSV - YOU CANNOT USE an EXCEL or other files with this method. Just another TIP to share.

Dropbox public folder

Copy Dropbox public link: - for file

Paste Public Dropbox link into REST Connector URL box

Get data (CSV)

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

"Hi Paul - do you mean a Qlik Sense Cloud Business - "TRIAL" - I believe you automatically get a 14 day trial with Qlik Sense Cloud Business when you sign up. DO NOTE - you can also do this with the FREE Qlik Sense Desktop product to test out the REST Connector as it comes included with Desktop and Enterprise."

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Hi Paul - it is assumed you are familiar with Dropbox or another cloud storage service. The path needs to be the path on the Dropbox server, NOT your local drive. As in the video, you need the path to be represented like this:

Note in the Dropbox API explorer you need to click the Show Code button to see the other parameters - just in case you did not know - so you can copy and paste those values. I don't want to provide my app as it has my token, but you can use this to assist you.

{"path":"/data/gettingstarteddata.csv"} - you have [ ] - it should be { }

Authorization

Bearer <your token>

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

One more question how to make it automatic data loading ? My objective is to have the cloud report automatic update the chart when raw data at dropbox is updated. May i know where i can set the schedule reload ?

So you cannot have an automated update or trigger - when the dropbox data is refreshed. Please remember this whole thing you are going through is a proof of concept - to show you that you can have some sort of capability to automatically refresh the data in an app, without having to manually upload the data file to qlik sense cloud.

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.