Create
Create a CSV string from a List, JSON string or XML string.
Task version: 1.11.0
Required Frends version: 5.5+
Required .NET version: 6.0
Compatible Agents: Crossplatform
Task Parameters
InputType : CreateInputType
Select input type to show correct editor for input
Possible values:
List: Select input type to show correct editor for inputJson: Select input type to show correct editor for inputXml: Select input type to show correct editor for input
Default: 0
Example: CreateInputType.List
Delimiter : String
Delimiter.
Default: ";"
Example: ;
Json : String
Json string to write to CSV.
Must be an array of objects.
Default: -
Example: [{"Column1": "row1Val1","Column2": "row1Val2"},{"Column1": "row2Val1","Column2": "row2Val2"}]
SpecifyColumnsManually : Boolean
If set true, allows the user to manually specify an array of columns which to generate.
Default: false
Example: false
Columns : List<String>
Custom columns for the data.
Default: -
Example: { "Column1", "Column2", "Column3" }
Xml : String
Xml string to write to CSV.
Default: -
Example: Veijo FrendsStr 2018-05-27T00:00:00 Hodor HodorsStr 2018-01-01T00:00:00
XmlNodeElementName : String
Name of the node from which the data is to be queried.
Default: -
Example: book
Headers : List<String>
Headers for the data.
Need to be in the same order as the underlying data
Default: -
Example: { Values, Foos, Bars, Dates }
Data : List<List`1>
Data to write to the CSV string.
Needs to be of type List<List>.The order of the nested list objects need to be in the same order as the header list.
Default: -
Example: { 1, "foo", "bar", 2023-02-08 }
CultureInfo : String
The culture info to read/write the entries with, e.g. for decimal separators.
InvariantCulture will be used by default.
See list of cultures here: https://learn.microsoft.com/en-us/dotnet/api/system.globalization.cultureinfo.name?view=net-7.0
NOTE: Due to an issue with the CsvHelpers library, all CSV tasks will use the culture info setting of the first CSV task in the process; you cannot use different cultures for reading and parsing CSV files in the same process.
IncludeHeaderRow : Boolean
This flag tells the writer if the header row should be written.
Default: true
Example: true
NeverAddQuotesAroundValues : Boolean
If set true, CSV's fields are never put in quotes
Default: false
Example: false
ReplaceNullsWith : String
Input's NULL values will be replaced with this value.
Default: -
Example: foo
BooleanFormat : BooleanFormat
Specifies the string representation format for boolean values in the CSV output.
Possible values:
Lowercase: Specifies the string representation format for boolean values in the CSV output.PascalCase: Specifies the string representation format for boolean values in the CSV output.Numeric: Specifies the string representation format for boolean values in the CSV output.
Default: 0
Example: BooleanFormat.Lowercase
Task Result
Success : Boolean
Operation complete without errors.
Example: true
CSV : String
CSV string.
Example: First;Second;"foo";"bar"
Task Changelog
Changelog for Task Frends.CSV.Create.
[1.11.0] - 2026-01-27
Added
Added BooleanFormat option to customize boolean output format in CSV (lowercase, PascalCase, or numeric).
[1.10.0] - 2026-01-23
Fixed
Empty JSON input now returns empty string instead of throwing exception
[1.9.0] - 2025-12-05
Changed
Update package CsvHelper to version 33.1.0.
[1.8.0] - 2025-11-12
Changed
Updated CsvHelper to version 33.0.1.
[1.7.0] - 2025-10-29
Fixed
Improve the memory efficiency of parsing Json.
[1.6.0] - 2025-10-06
Changed
Updated Repository link in the metadata.
[1.5.0] - 2024-10-11
Fixed
Fixed issue with JSON properties having spaces in property names.
[1.4.0] - 2024-08-20
Added
Updated NewtonSoft.Json to the latest version 13.0.3.
[1.3.0] - 2024-08-12
Added
Added option to specify headers manually when creating a CSV from Json.
[1.2.0] - 2024-05-06
Added
Input Json can be Array or Object
Json can have nested properties
Json can handle array properties
[1.1.0] - 2023-07-27
Added
Added option to create csv from xml input.
Added new Input parameters: Xml and XmlNodeElementName which are part of the new implementation.
[1.0.0] - 2023-02-09
Added
Initial implementation
Last updated
Was this helpful?