# Dropbox - CSV file actions

This section will highlight the actions that you can perform on CSV files in Dropbox.

# Update CSV file

This action allows you to update the content of a selected file in Dropbox. Do note that the size of the file after appending should not exceed 150 MB.

Update CSV file action

Update CSV file action

# Input fields

Field name Description
File The CSV file that you wish to process. You can either select the specific file from the directory provided or type out the name of the file.
Column separator The delimiter separating the values.
File encoding type Default encoding type is set to UTF-8, and typically doesn't need to be changed.
Append Setting to Yes appends content to existing file, setting to No overwrites the existing file.
Obtain a direct URL to file? Whether or not to generate a public URL that is valid for 4 hours.
Column headers Enter column names, each on a new line. By default, the column names of the given CSV file will be retrieved.

# Output fields

Field name Description
Path The path the CSV file that has been updated.
Bytes File size in bytes.
Size File size in string format.
Mime type The Mime type of this file.
URL File's public URL. Can be used to download file using the Workato file connector.
URL expires Date/time the file's public URL will expire.
Rev A unique identifier for the current revision of the file.
Modified Date/time the file was last modified.
Client modified time This is the modification time set by the desktop client when the file was added to Dropbox. Since this time is not verified (the Dropbox server stores whatever the desktop client sends up), this should only be used for display purposes (such as sorting) and not, for example, to determine if a file has changed or not.

# Read CSV file

This action allows you to expose the content of a selected CSV file according to the value of each column and row.

Read CSV file action

Read CSV file action

# Input fields

Field name Description
File / File path The CSV file to process.
Column separator The delimiter separating the values.
Add column names manually Set column name from the input field below. Otherwise the first line of the selected CSV file will be taken to get column names.
Column names Input one column name per line.

# Output fields

The output fields of this trigger correspond to the values of the columns and rows of the selected CSV file.


Last updated: 7/2/2021, 10:57:57 AM