Introduction

Enzo Server
  Installation
  Quick Start
  Core Features
    Async Calls
    ConnectionStrings
    Edge Cache
    HTTP Access
    Scheduling
    Views
  Advanced Capabilities
    Change Data Capture
  Administration
    Configuration Settings
    Logins & ACL
    Auditing
    Current Executions
    Linked Server
    SSL

  User Guides
     Sharding
     Sharding Overview

     SharePoint

   Adapters
    All Adapters
    ActiveCampaign
    Azure Bus
    Azure IoT Hub
    Azure Key Vault
    Azure Storage
    Bing Search
    ConstantContact
    Couchbase
    CSV
    DB (RDBMS)
    Dropbox
    Files
    Flight Aware
    FreshBooks
    FTP
    Geonames
    GoogleDrive
    GoogleSearch
    GoogleSheet
    GreenMile
    GpsInsight
    HttpEndpoint (REST)
    Intacct
    Insteon
    Loggly
    MailChimp
    Messaging (SMS/SMTP)
    MongoDB
    Motus
    MSAD
    MSMQ
    OneDrive
    OneDrive365 (Business)
    Pipeline
    Pressero
    RabbitMQ
    SalesForce
    Shard
    SharePoint
    Slack
    SQL Server
    SQLX
    Sudoku
    Teams
    Threading
    Twilio
    Twitter
    VellemanDMX
    Whiparound
    WMI
    Xls (Excel)
    ZIP


  SDK
    Overview
    Installation
    DevHost
    Create A Simple Adapter
    Handler Columns

    Advanced SDK Concepts
      Handler Decorators
      Dynamic Columns
      Table & Table Enumerators
      Virtual Tables

/adapters/dropbox




Dropbox


Manage and access your Dropbox files and folders easily. Download/upload documents to/from Dropbox.


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 fileIdThe 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 fileIdThe 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