WriteCSV

This activity allows the user to write an input DataTable value to the specified CSV file. It is widely used to export the tabular data into CSV format for data storage and interchange.

Properties

INPUT

Delimiter: This parameter refers to a character used to separate values in a CSV file. Select the delimiter from the drop-down menu:

Comma (,): Use this when the data in the input sheet is separated by commas.
Tab: Use this when the data in the input sheet is separated by tabs.
Semicolon (;): Use this when the data in the input sheet is separated by semicolons.
Pipe (|): Use this when the data in the input sheet is separated by pipes.
Caret (^): Use this when the data in the input sheet is separated by carets.

Filepath:* This parameter requires you to provide the path of the CSV file to execute the activities.

Datatype: This parameter accepts input values in the “String” datatype.
Browse Option: You can browse and select the file using the “Browse” option in the activity.
Manual Entry: Alternatively, you can either hardcode the input value in “String” format or manually provide the values in “String” datatype.

Hasheader: If this option is enabled, the first row in the specified CSV file will be treated as the header. If it is not enabled, the first row will not be considered a header. 

IgnoreQuotes: If this option is enabled, the quotes in the data will be ignored during the reading process. 

WriteData:* This parameter specifies the input DataTable value that needs to be written to the CSV file. It accepts the values in the “Datatable” datatype.

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”

True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

OUTPUT

Result: It provides the ability to view the execution status of the activity. It returns values in “Boolean.”

True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

WriteStatus: It provides the ability to view the status of the data written in the CSV file. It returns values in “Boolean.”

True: Indicates that the activity has been executed successfully without any errors.

False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

*Represents mandatory fields to execute the workflow

Click here to view how the activity is used in the workflow.