Dropbox Input Tool
Use the Dropbox Input tool to read the data stored in your Dropbox workspace.
Configure the Tool
To install the Dropbox Input tool, in Designer open the Dropbox Input YXI file you have downloaded from Gallery.
Note
To install the Dropbox Input tool for all users, open the Designer app with administrator credentials.
- To add the Dropbox Input tool into the workflow, go to the Connectors tab, select Dropbox Input and drag and drop the tool to the canvas.
- Select the Dropbox Input tool to navigate to the configuration panel.
- Enter your credential details in the left side panel. You can choose from following authentication methods:
- Sign in via Internet Browser: A pop up window appears to grant the access to Dropbox. You can also choose to Connect through your own Dropbox application with the client ID and secret.
- Provide Access Token: Authentication with an access token generated to call for your account without going through the authorization flow. With this authentication method you also decide whether to log in to a Personal or Business account.
You can also choose to Connect through your own Dropbox application with the client ID and secret.
- Select the Connect button.
- You can now choose Site and Document Library. To select your file, you can then browse through the folders (you can also use Search to find your Site, Library, and File). Note that File Path for the selected file is modified according to the selection made.
- In the Options tab, you can check File Format, Max Field Length, Field Delimiter (Comma by default). Also, you can Quote Characters (None by default), Attach Metadata, and check page coding. For unsupported file format (other than CSV, XLSX, and YXDB) you will get an error message.
- The tree view is populated according to the site selected. Based on the selected file format there is multiple options present in the Options tab.
- For the XLSX file format, in the Data tab you can select Data range options: All Sheets, Sheet Names, Sheet Numbers along with a particular range, Named Range, or to Import only the list of sheet names.
Note
You can also choose a folder with all subfolders (a file format is set manually), or you can define the file path using a wildcards. For example “.../*2020.xlsx” for all .xlsx files ending with '2020'.
- Select Run to execute the workflow.