Dropbox Adapter

Access Dropbox files and folders through SQL and REST commands.

This adapter requires a subscription to Dropbox.

Want to try it in Azure? Click here to learn more or click here to create a new Enzo Server RTM 3.1 Azure VM now.

Want to try it in AWS? Click here to learn more or click here to create a new Enzo Server RTM 3.1 AWS VM now.

OAuth Configuration

This adapter requires OAuth to be configured.

show steps

Obtain an API Key and API Secret from Dropbox and save in a Config Setting in Enzo
In this initial step, you first register an Application in Dropbox (AppConsole). Once an application has been created, you will obtain an App API Key and App API Secret. These need to be saved in a Configuration setting in Enzo Manager.
Execute GetAuthUrl to obtain the correct URL and paste it in a browser to authenticate
Start SQL Server Management Studio (SSMS), connect to Enzo directly, and execute the GetAuthUrl method. The GetAuthUrl method returns a URL that you can copy and paste in a browser; this URL is constructed dynamically. Once the authentication flow is completed, you will get a blank webpage; the URL bar on the browser will contain a return code. Copy the complete URL provided before going to the next step.
Copy the ResponseCode provided and execute the GetTokens command passing the Response Code
The GetTokens method requires the complete URL provided in the previous step. This will extract the response code and return an Access Token. Note that the URL is only valid for a period of time. Copy the AccessToken in memory.
Copy the AccessToken and RefreshToken provided by the previous call and save them into the same Config Setting
These tokens must be saved in the Config Setting previously created.

Configuration Settings

Name	Description	Default
Boolean _isDefault	Make this the default configuration. Defaults to true if configName is already the default.
String accessToken	accessToken is used for authenticate with dropbox
String appKey	the appKey is useful to authenticate
String appSecret	the app secret key

Handlers

CreateFolder
Folders

Create new folder at specific path using dropbox details

Arguments

Name	Description	Default
folderPath R

SQL Call

EXEC Dropbox.CreateFolder
INSERT INTO Dropbox.Folders (folderPath) VALUES ('/test')

Http Call

/bsc/dropbox/createfolder

Output Columns

String fileId

The fileId of the folder created

CreateFolderEx
FoldersEx

Create new folder at specific path using dropbox details

Arguments

Name	Description	Default
configName
folderPath R

SQL Call

EXEC Dropbox.CreateFolderEx@config1
INSERT INTO Dropbox.FoldersEx@config1 (folderPath) VALUES ('/test')

Http Call

/bsc/dropbox/createfolderex

Output Columns

String fileId

The fileId of the folder created

DeleteFile
Files

Delete particular file by passing file path details

Arguments

Name	Description	Default
filePath R

SQL Call

EXEC Dropbox.DeleteFile '/abc.txt' 
delete FROM Dropbox.files where filePath='/abc.txt'
delete FROM Dropbox.[files] where filePath='/abc.txt'

Http Call

/bsc/dropbox/deletefile

Output Columns

This call does not return data.

DeleteFileEx
FilesEx

Delete particular file by passing file path details

Arguments

Name	Description	Default
configName
filePath R

SQL Call

EXEC Dropbox.DeleteFileEx 'config1','/abc.txt' 
delete FROM Dropbox.filesEx@configName where filePath='/abc.txt'
delete FROM Dropbox.[filesEx@configName] where filePath='/abc.txt'

Http Call

/bsc/dropbox/deletefileex

Output Columns

This call does not return data.

DeleteFolder
Folders

Delete particular file or folder by passing folder path details

Arguments

Name	Description	Default
folderPath R

SQL Call

EXEC Dropbox.DeleteFolder  @folderPath='/Test1'
DELETE FROM Dropbox.Folders where folderPath='/Test1'
DELETE FROM Dropbox.[Folders] where folderPath='/Test1'

Http Call

/bsc/dropbox/deletefolder

Output Columns

This call does not return data.

DeleteFolderEx
FoldersEx

Delete particular file or folder by passing folder path details

Arguments

Name	Description	Default
configName
folderPath R

SQL Call

EXEC Dropbox.DeleteFolderEx 'Config1',@folderPath='/Test1'
DELETE FROM Dropbox.FoldersEx@configName where folderPath='/Test1'
DELETE FROM Dropbox.[FoldersEx@configName] where folderPath='/Test1'

Http Call

/bsc/dropbox/deletefolderex

Output Columns

This call does not return data.

DownloadFile

upload file at dropbox on given path details

Arguments

Name	Description	Default
filename R
downloadPath
override		False
timeout		0
retryCount		3

SQL Call

EXEC Dropbox.DownloadFile

Http Call

/bsc/dropbox/downloadfile

Output Columns

String fileName
String tmpFileName
Int64 byteTx
Double elapsedTime

DownloadFileEx

upload file at dropbox on given path details

Arguments

Name	Description	Default
configName
filename R
downloadPath
override		False
timeout		0
retryCount		3

SQL Call

EXEC Dropbox.DownloadFileEx

Http Call

/bsc/dropbox/downloadfileex

Output Columns

String fileName
String tmpFileName
Int64 byteTx
Double elapsedTime

getAuthURL
authURL

Get Authentication url details

Arguments

Name	Description	Default
baseURL		https://www.dropbox.com/oauth2/authorize

SQL Call

EXEC Dropbox.getAuthURL
SELECT * FROM Dropbox.authURL

Http Call

/bsc/dropbox/getauthurl

Output Columns

String url

getAuthURLEx
authURLEx

Get Authentication url details

Arguments

Name	Description	Default
configName
baseURL		https://www.dropbox.com/oauth2/authorize

SQL Call

EXEC Dropbox.getAuthURLEx 'Config1'
SELECT * FROM Dropbox.authURLEx@configname

Http Call

/bsc/dropbox/getauthurlex

Output Columns

String url

getTokens
tokens

Get authentication token details

Arguments

Name	Description	Default
codeResponse R

SQL Call

EXEC Dropbox.getTokens  'code here from getAuthURL Function'
SELECT * FROM Dropbox.tokens where codeResponse='code here from getAuthURL Function'

Http Call

/bsc/dropbox/gettokens

Output Columns

String code
String accessToken
String token_type
String account_id

getTokensEx
tokensEx

Get authentication token details

Arguments

Name	Description	Default
configName
codeResponse R

SQL Call

EXEC Dropbox.getTokensEx 'Config1','code here from getAuthURL Function'
SELECT * FROM Dropbox.tokensEx@configname where codeResponse='code here from getAuthURL Function'

Http Call

/bsc/dropbox/gettokensex

Output Columns

String code
String accessToken
String token_type
String account_id

ListFiles
Files

Read all the files from dropbox root details

Arguments

Name	Description	Default
folder

SQL Call

EXEC Dropbox.ListFiles
SELECT * FROM Dropbox.Files
SELECT * FROM Dropbox.[Files]

Http Call

/bsc/dropbox/listfiles

Output Columns

String fileName
String fileId
DateTime createdDate
DateTime lastModifiedDate
Int64 fileSize
String filePath
String mimeType
Boolean isFolder

ListFilesEx
FilesEx

Read all the files from dropbox root details

Arguments

Name	Description	Default
configName
folder

SQL Call

EXEC Dropbox.ListFilesEx 'config1'
SELECT * FROM Dropbox.FilesEx@configName
SELECT * FROM Dropbox.[FilesEx@configName]

Http Call

/bsc/dropbox/listfilesex

Output Columns

String fileName
String fileId
DateTime createdDate
DateTime lastModifiedDate
Int64 fileSize
String filePath
String mimeType
Boolean isFolder

RenameFile
Folders

Rename specific folder by passing rename file details

Arguments

Name	Description	Default
fromFilePath R
toFilePath R

SQL Call

EXEC Dropbox.renamefile 'config2',@fromFilePath='/abc.txt',@toFilePath='/def.txt'
update Dropbox.folders@config2 set toFilePath = '/test.txt' where fromFilePath='/abc.txt'

Http Call

/bsc/dropbox/renamefile

Output Columns

This call does not return data.

RenameFileEx
FoldersEx

Rename specific folder by passing rename file details

Arguments

Name	Description	Default
configName
fromFilePath R
toFilePath R

SQL Call

EXEC Dropbox.renamefileEx 'config2',@fromFilePath='/abc.txt',@toFilePath='/def.txt'
update Dropbox.foldersEx@config2 set toFilePath = '/test.txt' where fromFilePath='/abc.txt'

Http Call

/bsc/dropbox/renamefileex

Output Columns

This call does not return data.

RenameFolder
Folders

Rename specific folder by passing rename folder details

Arguments

Name	Description	Default
fromFilePath R
toFilePath R

SQL Call

EXEC Dropbox.renamefolder @fromFilePath='/abc',@toFilePath='/def'
update Dropbox.folders set toFilePath = 'def' where fromFilePath='/abc'

Http Call

/bsc/dropbox/renamefolder

Output Columns

This call does not return data.

RenameFolderEx
FoldersEx

Rename specific folder by passing rename folder details

Arguments

Name	Description	Default
configName
fromFilePath R
toFilePath R

SQL Call

EXEC Dropbox.renamefolderEx 'config2',@fromFilePath='/abc',@toFilePath='/def'
update Dropbox.foldersEx@config2 set toFilePath = 'def' where fromFilePath='/abc'

Http Call

/bsc/dropbox/renamefolderex

Output Columns

This call does not return data.

UploadFile
File

upload file at dropbox on given path details

Arguments

Name	Description	Default
sourceFile R
filename R
override		False
timeout		0

SQL Call

EXEC Dropbox.UploadFile
INSERT INTO Dropbox.File@config1 (sourceFile,filename) VALUES ('abc.txt','d2.txt')

Http Call

/bsc/dropbox/uploadfile

Output Columns

String fileName
String fileId
Int64 byteTx
Double elapsedTime

UploadFileEx
FileEx

upload file at dropbox on given path details

Arguments

Name	Description	Default
configName
sourceFile R
filename R
override		False
timeout		0

SQL Call

EXEC Dropbox.UploadFileEx
INSERT INTO Dropbox.FileEx@config1 (sourceFile,filename) VALUES ('abc.txt','d2.txt')

Http Call

/bsc/dropbox/uploadfileex

Output Columns

String fileName
String fileId
Int64 byteTx
Double elapsedTime

BLOGS AND VIDEOS

IN THE NEWS

OTHER

Dropbox Adapter

OAuth Configuration

Configuration Settings

Handlers

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments

SQL Call

Http Call

Output Columns

Arguments