Dropbox

Using the Dropbox Connector in DBSync Cloud Workflow

Overview

The Dropbox Connector in DBSync Cloud Workflow allows users to seamlessly integrate Dropbox operations such as reading and writing files into their automated workflows. This guide provides detailed steps to configure and use the Dropbox Connector effectively.

Steps to Use the Dropbox Connector

Select Connector

1. In the DBSync Cloud Workflow interface, locate the option to select a connector.

2. Choose Dropbox from the list of available connectors or click 'Add New' to configure a new Dropbox connection.

Operation

3. Select the desired operation:

• Read: To retrieve files from Dropbox.

• Write: To upload/write files to Dropbox.

Read From (File/Folder Path)

4. If you selected the 'Read' operation, specify the file path or folder path:

5. File Path: Enter a hardcoded file path.

   • Data Stream Variable: Click the 'Fx' icon to select a data stream variable that contains the file path dynamically from previous actions (e.g., a query from Salesforce).

   • Regular Expression: Enter a regular expression to query a pattern of files (e.g., r'.*\.txt$').

6. The downloaded files will be stored in an auto-generated variable, which can be changed if needed. This variable will be added to the data stream for further processing.

Write To (File/Folder Path)

7. If you selected the 'Write' operation, specify the file path or folder path:

• File Path: Enter a hardcoded file path.

• Data Stream Variable: Click the 'Fx' icon to select a data stream variable that contains the file path dynamically from previous actions.

• Regular Expression: Enter a regular expression to query a pattern of files (e.g., r'.*\.txt$').

8. In the 'File Content' field, specify the variable from the data stream that contains the file name to be uploaded. The default variable is $file-name, which retains the filename from the source. You can edit the name if needed.

9. Select the variable from the 'Fx' dropdown that contains the file content to be uploaded.

Properties

10. If the 'Write' operation is selected, additional properties can be configured:

• If File Name Exists: Choose the action to take if the file name already exists in the target folder (Skip, Override).

• Batch Size: Select the batch size for file uploads (10, 50, 100, 1000).

• Shared Link Settings: Configure the settings for creating shared links (if applicable).

PRO TIP

To optimize file handling and avoid conflicts, use dynamic variables for file paths and names. This ensures that each operation is unique and reduces the risk of overwriting important files.

Frequently Asked Questions (FAQ)

1. Can I use the Dropbox Connector for both reading and writing files?

Yes, the Dropbox Connector supports both reading and writing operations. You can configure it to retrieve files from Dropbox or upload files to Dropbox.

2. How do I handle file name conflicts when uploading files?

You can set the "If File Name Exists" property to either Skip or Override. This allows you to choose whether to skip uploading a file if it already exists or to override the existing file.

3. What is the maximum batch size for file uploads?

The maximum batch size for file uploads is 1000. You can select the batch size based on your needs, such as 10, 50, 100, or 1000.

4. Can I use regular expressions for file paths?

Yes, you can use regular expressions to query a pattern of files in Dropbox. This is useful for dynamically selecting files based on specific patterns.