Qlik Sense Desktop: Bundled Dropbox Connector STORE statement fails

[Sonja_Bauernfeind]

Using the bundled Dropbox Connector for Qlik Sense Desktop allows for LOAD statements, but STORE statements fail.

 

Resolution

There are two Dropbox connectors available for Qlik Sense Desktop. The bundled connector does not support storing of data in Dropbox.

To store data, use the Qlik Web Connectors. 

Example configuration of the Dropbox connection:

When using this connector, you will need to store the file locally and then trigger the upload from the load script editor.

Connector settings:

Local path: the path where your source file is stored.
Dropbox upload path: the path and file to which you will upload data.
Mode: choose if you want to overwrite the file or not

Example script in the source file:

let vQwcConnectionName = 'lib://dropboxconnection';

Characters:
Load Chr(RecNo()+Ord('A')-1) as Alpha, RecNo() as Num autogenerate 26;

STORE Characters into [lib://localstorage/test.qvd] (qvd);

DropboxConnector_UploadFile:
LOAD
status as UploadFile_status,
error_message as UploadFile_error_message
FROM [$(vQwcConnectionName)]
(URL IS [http://localhost:5555/data?connectorID=DropboxConnector&table=UploadFile&encrypted_refresh_token=YOUR TOKEN], qvx); 

Related Content 

Qlik Web Connectors: Dropbox

Environment

• Qlik Sense Desktop 

Internal Investigation ID(s)

00040285