Profiles: Project Creator
This connector does not work with Dropbox for Teams accounts. If you have a Dropbox for Teams account you’d like to connect, contact Squirro Support for assistance.
This page describes how to set up and configure the Squirro 1-click connector for Dropbox.
This connector allows project creators to connect to a Dropbox account and select which data they’d like to index into Squirro.
When using the Dropbox Connector, all document types including sheets are converted to PDF before ingesting into a Squirro project.
To use this connector, you’ll need the following:
An existing Dropbox account with data.
OAuth set up for 1-click connectors enabled within Squirro.
Setting Up a Connector#
To connect Dropbox to Squirro, follow the steps below:
Open your Squirro project.
Navigate to the Setup space.
Click the Data tab. By default, you will be on the Data Sources page, as shown in the example screenshot below:
Click the orange plus sign (+) in the top-right corner of the page to add new data.
Click the Enterprise tab, then the Dropbox icon.
When prompted to authenticate your Dropbox account, click Authenticate.
Once you click on the Authenticate button, you will be re-directed to the Dropbox sign-in page. The screen shown below (or similar) then asks you to provide consent for your Dropbox data to Squirro:
Note: Squirro will never ask you for your Dropbox password. This is requested by Dropbox itself.
After signing in or selecting your Dropbox account (if you are signed into multiple accounts), you will be brought back to Squirro’s Source Configuration screen. The screen shown below indicates which Dropbox account Squirro has connected to:
Click Save for Squirro to automatically configure the mapping of item fields and labels, as well as any other required source configuration. Alternatively, you can define those settings manually by clicking Next and going through the full source setup process.
If you are specifying a folder path manually, you must include the leading slash (
/) in the path. For example,
Now, your data will begin indexing into Squirro.
To allow Squirro to connect to the Dropbox accounts of end users, you must register an OAuth2 app on the Dropbox portal.
Follow the steps below to configure 0Auth on the Dropbox website:
The exact process on the Dropbox platform may change. If you encounter any issues, contact Squirro Support for assistance.
Open the Dropbox App Console, located at https://www.dropbox.com/developers/apps.
Click Create App.
Select the options as shown in the screenshot below and then click Create App:
<Insert Your Choice of Name>. This name will be shown to project creators when connecting to the source but does not otherwise appear in the indexed data.
Select the following options under the Settings tab:
- Configure OAuth 2 Redirect URIs. This is the URL Dropbox will redirect the user to after successful authorization. This needs to be set to
https://<your-server-url>>/dataloader/dropbox_plugin/pl/dropbox/authorizedon your server.For example:
Access token expiration:
Leave all the other options untouched.
Click the Permissions tab and ensure the following permissions are enabled:
Apply for Production#
To avoid that, you must apply for Production status of the Dropbox app.
To start that process you first have to configure the Branding. This will require a logo icon, portal URL, and a description of the application.
After creating the OAuth2 app on the Dropbox portal, you must configure the App Key and the App Secret on your Squirro instance.
To do so, follow the steps below:
Obtain the Dropbox App key and the Dropbox app secret from the Settings screen of the app.
/etc/squirro/common.inion your Squirro cluster and add the following lines:
[dataloader] dropbox_app_key=dummy4appk3y123 dropbox_app_secret=dummys3c3t12345
[dataloader]header is already present in this file, add the two lines to the existing section. The section header can not appear more than once in the configuration file.
Restart the frontend & datasource service to apply the settings:
sudo systemctl restart sqfrontendd sudo systemctl restart sqdatasourced
You are now ready to connect your Squirro instance to Dropbox accounts!