Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Qlik Dropbox connector what are the purpose ?

Hi All

I have read the below blog post , but i am still blur.

Qlik Design Blog

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.

Hope some one can share with me.

Paul Yeo

30 Replies
paulyeo11
Master
Master
Author

Hi Michael

Can you pls just send me your QVF file , so I can see all your Dropbox connector setting , and from there I think I should be able clear the error.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Michael_Tarallo
Employee
Employee

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.

Your query parameters are wrong it should look like this:

URL:

https://content.dropboxapi.com/2/files/download

Dropbox-API-Arg

NOTE

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

Regards,

Michael Tarallo (@mtarallo) | Twitter

Qlik

Regards,
Mike Tarallo
Qlik
paulyeo11
Master
Master
Author

Hi Michael

Thank you very much for your patience with me. Now i still get below error msg. it mentioned that my Token access should be "Bearer ..... Instead of "buhChTY.......

bearer.png

Now Let me zoom into Token Access code issue. So first let look at my dropbox folder as below :-

/Data/gettingstarteddata.csv

Where i store my raw data file.

dropbox.png

Now look at

Dropbox API Explorer • download using below link :-

Dropbox API Explorer

API wrong token.png

Michael , pls advise me why my Token Access above show "buhChTY which is wrong. it should be Bearer. where did i go wrong ?

Paul Yeo

Michael_Tarallo
Employee
Employee

Actually the message is correct as you also need the word 'Bearer' to be present in your Authorization value - see mine below.

Regards,
Mike Tarallo
Qlik
paulyeo11
Master
Master
Author

Hi Michael

Thank you very much , now it work fine.

Below is the step that i summarise. Hope it can help other :-

URL:

https://content.dropboxapi.com/2/files/download

Request Path :

/data/gettingstarteddata.csv

(Above is the dropbox folder that i save the raw data file )

Click on :

Show Code and Get Token ( If no error , mean above step is correct )

buhChTY8u1gAAAAAAADJotNK7zlh44_kmLBJ7i7XYeQbA2zPIH0AIBv7ZuNw5EFe


Dropbox-API-Arg

NOTE

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

 

Authorization


Bearer <your token>

Bearer buhChTY8u1gAAAAAAADJotNK7zlh44_kmLBJ7i7XYeQbA2zPIH0AIBv7ZuNw5EFe


Paul Yeo

paulyeo11
Master
Master
Author

Hi Michael

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 ?

automate.png

paulyeo11
Master
Master
Author

Hi Micheal

I have one more question below :-

2qvf.png

Hope you can advise me.

Paul Yeo

Michael_Tarallo
Employee
Employee

Hi Paul - scheduled reload in Qlik Sense Cloud Business (only) is limited to the following:

Qlik Sense Cloud Business - Orientation Overview - YouTube - watch at this time-code - 10:38s

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.

Regards,

Michael Tarallo (@mtarallo) | Twitter

Qlik

Regards,
Mike Tarallo
Qlik
Michael_Tarallo
Employee
Employee

Hi Paul - no - you can have multiple files in a Qlik Sense App (.qvf file) - however if there isn't anything in common (key fields, field names) - it will just be a separate table in the data model.

Regards,
Mike Tarallo
Qlik
paulyeo11
Master
Master
Author

Hi Michael

What I mean is for example I have 2 raw data at Dropbox/data/ folder :-

Gettingstarteddata_USA

Gettingstarteddata_EURO

The above 2 data file have same data structure , only different the SOURCE are from USA or EURO

Since in your example , when you make the Dropbox connection , in Dropbox-API-Arg need to enter the file name . There I can only enter Gettingstarteddata_USA

{"path":"/data/gettingstarteddata_USA.csv"}

As it does not allow me enter more then one file name.

Pls advise.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>