Dropbox Connector

Read and write Dropbox data effortlessly. Integrate, manage, and automate files and folders — almost no coding required.

Establish a two-way connection to query and load Dropbox data using SSIS, SQL Server, ETL platforms, reporting tools, any ODBC/JDBC-compatible application, or your preferred programming language.

Download for SSIS Download for SQL Server and ODBC Documentation

Integrate Dropbox with these applications

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC applications

Actions supported by Dropbox Connector

Dropbox Connector supports following actions for REST API integration:

Create folder

Description

Creates a folder.

Parameters

You can provide the following parameters to this action:

  • Path

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Name
  • PathLower
  • PathDisplay

Visit documentation for more information.

Delete file or folder

Description

Deletes a file or folder.

Parameters

You can provide the following parameters to this action:

  • Path

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Name
  • PathLower
  • PathDisplay
  • ClientModified
  • ServerModified
  • Revision
  • Size
  • IsDownloadable
  • ContentHash

Visit documentation for more information.

Download file

Description

Downloads a file to a disk.

Parameters

You can provide the following parameters to this action:

  • SourceFilePath

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Status

Visit documentation for more information.

Download folder as ZIP archive

Description

Downloads a folder with all the files and folders it contains as ZIP file.

Parameters

You can provide the following parameters to this action:

  • SourcePath

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Status

Visit documentation for more information.

List files

Description

Lists files within a folder.

Parameters

You can provide the following parameters to this action:

  • Filter files by extensions
  • Path
  • Recursively scan subfolders

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Name
  • Type
  • PathLower
  • PathDisplay
  • ClientModified
  • ServerModified
  • Revision
  • Size
  • IsDownloadable
  • ContentHash

Visit documentation for more information.

List files and folders

Description

Lists files and folders within a folder.

Parameters

You can provide the following parameters to this action:

  • Path
  • Recursively scan subfolders

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Name
  • Type
  • PathLower
  • PathDisplay
  • ClientModified
  • ServerModified
  • Revision
  • Size
  • IsDownloadable
  • ContentHash

Visit documentation for more information.

Make connection test

Description

Makes a connection test.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Result

Visit documentation for more information.

Read CSV file

Description

Reads the contents of a CSV file straight into a result set, without requiring a download to disk.

Parameters

You can provide the following parameters to this action:

  • File path or ID

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Read CSV files from folder

Description

Reads the contents of every CSV file in the specified folder directly into a result set without downloading to disk.

Parameters

You can provide the following parameters to this action:

  • Folder path or ID
  • Recursively scan subfolders
  • Filter files by extensions

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Upload file

Description

Uploads a file from a disk.

Parameters

You can provide the following parameters to this action:

  • TargetFilePath
  • SourceFilePath

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Name
  • PathLower
  • PathDisplay
  • ClientModified
  • ServerModified
  • Revision
  • Size
  • IsDownloadable
  • ContentHash

Visit documentation for more information.

Make Generic REST API Request

Description

This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • HTTP - Url or File Path
  • HTTP - Request Body
  • HTTP - Is MultiPart Body (Pass File data/Mixed Key/value)
  • HTTP - Headers (e.g. hdr1:aaa || hdr2:bbb)
  • Parser - Filter (e.g. $.rows[*] )
  • Download - Enable reading binary data
  • Download - File overwrite mode
  • Download - Save file path
  • Download - Enable raw output mode as single row
  • Download - Raw output data RowTemplate
  • Download - Request Timeout (Milliseconds)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Make Generic REST API Request (Bulk Write)

Description

This is a generic endpoint for bulk write purpose. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • Url
  • IsMultiPart
  • Filter
  • Headers

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.