Write data in DropBox using DropBox Connector in SSIS

In this section we will learn how to configure and use DropBox Connector in the API Destination to write data in the DropBox.

Video Tutorial - Write or lookup data to DropBox using SSIS

This video covers following and more so watch carefully. After watching this video follow the steps described in this article.

• How to download SSIS PowerPack for DropBox integration in SSIS
• How to configure connection for DropBox
• How to Write or lookup data to DropBox
• Features about SSIS API Destination
• Using DropBox Connector in SSIS

How to write or lookup data to DropBox in SSIS (Import data)

In upper section we learned how to read data, now in this section we will learn how to configure DropBox in the API Source to Post data to the DropBox.

1. Read the data from the source, being any desired source component. In example we will use ZappySys Dummy Data Source component.

2. From the SSIS Toolbox drag and drop API Destination (Predefined Templates) on the Data Flow Designer surface and connect source component with it, and double click to edit it.
   

3. Select New Connection to create a new connection:
   

   API Destination - DropBox

   Read / write DropBox data inside your app; perform many DropBox operations without coding, just use easy to use high performance API Connector for DropBox

   

4. Use a preinstalled DropBox Connector from Popular Connector List or press Search Online radio button to download DropBox Connector. Once downloaded simply use it in the configuration:
   

   DropBox

   

5. Proceed with selecting the desired Authentication Type. Then select API Base URL (in most cases default one is the right one). Finally, fill in all the required parameters and set optional parameters if needed. You may press a link Steps to Configure which will help set certain parameters. More info is available in Authentication section.

    User Account [OAuth]

   Steps to get DropBox Credentials : User Account [OAuth]
   

   To use OAuth authentication, firstly, you need to create OAuth application:

   1. Log into your DropBox account.
   2. Go to https://www.dropbox.com/developers/apps.
   3. Press Create app button to create a new app.
   4. Once a new page opens, select Scoped access option.
   5. Next, select Full Dropbox to access all files and folders or App folder to access specific folder's files and folders option
   6. Give your app a name
   7. Click create app
   8. Once a new page opens, click Scoped App in Permission type line to select application scopes.
   9. Select all Individual Scopes and Team Scopes if you want to manage team data. Click Submit button.
   10. Select Settings tab, scroll down to App key and App secret and copy paste them into Notepad.
   11. Then in OAuth 2 section add a URL as Redirect URI. If you don't have a working Redirect URI, you may add https://zappysys.com/oauth as Redirect URI

   Use App key and App secret and Redirect URI for use in Connection String when connecting or in UI.

   NOTE: If you are planning to use your current data connection/token for automated processes, we recommend that you use a generic account for token generation when the login box appears (e.g. sales_automation@mycompany.com instead of bob_smith@mycompany.com). When you use a personal account which is tied to a specific employee profile and that employee leaves the company, the token may become invalid and any automated processes using that token will fail. Another potentially unwanted effect of using a personal token is incorrect logging; the API calls (e.g. Read, Edit, Delete, Upload) made with that token will record the specific user as performing the calls instead of an automated process.

   DropBox

   User Account [OAuth]

   https://api.dropboxapi.com/2/

   Required Parameters
   UseCustomApp	Fill in the parameter...
   ReturnUrl	Fill in the parameter...
   Optional Parameters
   ClientId	Fill in the parameter...
   ClientSecret	Fill in the parameter...
   Scope	Fill in the parameter...
   RetryMode	Fill in the parameter...
   RetryStatusCodeList	Fill in the parameter...
   RetryCountMax	Fill in the parameter...
   RetryMultiplyWaitTime	Fill in the parameter...

   

6. Select the desired endpoint, change/pass the properties values, and go to the Mappings tab to map the columns.

   API Destination - DropBox

   Read / write DropBox data inside your app; perform many DropBox operations without coding, just use easy to use high performance API Connector for DropBox

   

7. Finally, map the desired columns:

   API Destination - DropBox

   Read / write DropBox data inside your app; perform many DropBox operations without coding, just use easy to use high performance API Connector for DropBox

   

8. That's it; we successfully configured the POST API Call. In a few clicks we configured the DropBox API call using ZappySys DropBox Connector