Introduction
This guide will walk you through connecting Microsoft Excel to the Dropbox API using the ZappySys ODBC API Driver, enabling seamless data integration and retrieval. The ZappySys ODBC Dropbox Connector provides a robust solution for integrating Dropbox data into Excel for reporting and analysis.
Prerequisites
- ODBC PowerPack: Download and install the ZappySys ODBC PowerPack from the Customer Download Area or the trial version.
- Dropbox account: Ensure you have a Dropbox account to access Dropbox data.
Steps
Step 1: Create/Select an App from the Dropbox Developers Page
-
Log into your Dropbox account.
-
Go to Dropbox Developers and click the Create app button to create a new app.
-
Select the Scoped access option when prompted.
-
Choose Full Dropbox to access all files and folders, or App folder to access files in specific folders.
-
Provide a name for your App and click Create App.
-
Under the Permission type section, click Scoped App to select application scopes.
-
Choose all Individual Scopes and Team Scopes if you need to manage team data, then click Submit.
-
Navigate to the Settings tab and copy the App key and App secret to Notepad.
Step 2: Create a New Driver
-
Open the ODBC Data Source by typing “ODBC” in the search box and launching the ODBC Data Source.
-
Go to the User DSN or System DSN tab to access the data source for yourself or other users. Add a new System DSN for SQL Server Integration by clicking the “Add” button.
-
Select ZappySys API Driverfrom the driver list, then choose Dropbox in the connector list and press Continue.
Step 3: Dropbox Connector Configuration
- Fill in the connector fields, including Client ID, Client Secret, and Scopes (separated by spaces). Example scopes:
account_info.read account_info.write files.metadata.write files.metadata.read files.content.write files.content.read - Generate the token and test the connection.
- Go to the Preview Tab, select any table, and preview the result. Press OK to save the configuration.
Step 4: Read data in Excel from the DSN
-
In Excel click Data, then select Get Data, proceed with From Other Sources and choose From ODBC item. This will get data from the ODBC data source we created:
-
A small window opens, then select the data source you created in previous steps:
-
You will most likely be asked to authenticate to a newly created DSN. Just select the Windows authentication option together with the Use my current credentials option:
-
You will be asked to select a table or view to get data. Select one and load the data!
-
Finally, use data extracted from REST API API in an Excel worksheet:
Video Tutorial
Conclusion
.
The article provides steps to guide users through connecting Excel with Dropbox services using our ODBC API driver. If you encounter any issues or need further assistance, feel free to contact our support team via chat on our website