Create CSV file as byte array
Creates a CSV file from a DataReader or DataTable and returns the result as a byte array.
Example 
This flow example shows a process that reads data from a database, splits records into multiple chunks, converts each chunk into CSV format, and appends it to a blob storage.
Actions used in the flow are: SQL Server Get DataReader, DataReader chunker, Create CSV file as byte array and Append to Blob.
Returns
Returns the Excel file serialized as a byte array
Properties
| Name | Type | Description |
|---|---|---|
| Title | ||
| Source | Required | Specifies the source of the data, which can either be a DataTable or DataReader. |
| Header row | Default | If true, the first row in the generated CSV file is a header row, containing column names. Default is true. |
| Column delimiter | Default | The delimiter that separates the fields on each row. The default value is , (comma). |
| Row delimiter | Default | The character or characters that separate rows in the data file. Default is \r\n (carriage return and line feed). This is commonly used to separate lines in Windows environments. Other options might include \n (newline), used in Unix/Linux environments, or \r, used in older Mac OS formats. |
| Quote character | Default | The character used to quote fields. The default value is " (double quote). |
| Quote all fields | Default | Default is false. If true, all fields in the data set will be enclosed within the quote character, regardless of whether they contain special characters. If false, only fields with special characters (like delimiters or newline characters) will be quoted. |
| Date format | Default | The format used for any date values in the data set. The default value is MM/dd/yyyy (e.g., 01/31/2024 for January 31, 2024). The format follows standard date formatting conventions where MM is the two-digit month, dd is the two-digit day, and yyyy is the four-digit year. You can customize this to other formats like yyyy-MM-dd based on your region or requirements. |
| Number decimal separator | Default | Defines the character used to separate the integer part from the fractional part of a decimal number. The default is . (period), commonly used in US English. Other locales might use , (comma) as the decimal separator, especially in European countries (e.g., 123,45). |
| Result variable name | Optional | The name of the variable you can use to reference the byte array in other actions. |
| Description | Optional | Additional notes or comments about the action or configuration. |