Dropbox Connector

Dropbox Connector

Your journey to data connectivity — from start to finish.

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

All inside your favorite applications.

SSIS integration
Download SSIS PowerPack
SQL Server & ODBC/JDBC connectivity
Download ODBC PowerPack
Find out more
Documentation

Pick an application to access your Dropbox data in

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.

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.

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.

Need another action for Dropbox?

Ping us via chat: