Upload¶

The two upload to DropBox functions require you to add your DropBoxAccessToken into the settings.

model.UploadExcelFromSqlToDropBox(query, sql, targetpath, filename)¶

Parameters:

• query (str) – see The Query Parameter This will be used to filter the SQL that is executed for use with a BlueToolBar report.

• sql (str) – The SQL code to execute. For the filtering to work with the query, the SQL must include a @qtagid.

• targetpath (str) – The directory path on DropBox where the file will be located.

• filename (str) – The name the file will be given on DropBox.

Note, this will overwrite any existing file with the same location and name.

model.UploadExcelFromSqlToDropBox(query, sql, targetpath, filename)¶

Parameters:

• sql (str) – The SQL code to execute.

• targetpath (str) – The directory path on DropBox where the file will be located.

• filename (str) – The name the file will be given on DropBox.

In this case, the SQL will not be suitable for the BlueToolBar filtering.

Note, this will overwrite any existing file with the same location and name.

model.UploadExcelFromSqlToFtp(sql, username, password, targetpath, filename)¶

Parameters:

• sql (str) – The SQL code to execute.

• username (str) – Username for FTP credentials

• password (str) – Password for FTP credentials

• targetpath (str) – The directory path on DropBox where the file will be located.

• filename (str) – The name the file will be given on DropBox.

In this case, the SQL will not be suitable for the BlueToolBar filtering.