ConvertToJSON
Converts CSV string content to JSON string.
Task version: 1.2.0
Required Frends version: 5.5+
Required .NET version: 6.0
Compatible Agents: Crossplatform
Task Parameters
Csv : String
Input csv string
Default: -
Example: 1;Foo;Bar
Delimiter : String
Delimiter.
Default: ";"
Example: ;
ColumnSpecifications : ColumnSpecification[]
You can map columns to specific types.
The order of the columns are used for mapping, that means that the ColumnSpecification elements need to be created in the same order as the CSV fields.
Default: -
Example: [ { foo, String } ]
ContainsHeaderRow : Boolean
This flag tells the reader if there is a header row in the CSV string.
Default: true
Example: true
TrimOutput : Boolean
This flag tells the reader to trim whitespace from the beginning and ending of the field value when reading.
Default: true
Example: true
SkipRowsFromTop : Int32
If the CSV string contains metadata before the header row you can set this value to ignore a specific amount of rows from the beginning of the csv string.
Default: 0
Example: 2
SkipEmptyRows : Boolean
A flag to let the reader know if a record should be skipped when reading if it's empty.
A record is considered empty if all fields are empty.
Default: true
Example: true
ReplaceHeaderWhitespaceWith : String
If intended header value contains whitespaces replace it(them) with this string, default action is to do nothing.
Default:
Example: " "
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.|
Default: -
Example: fi-FI
TreatMissingFieldsAsNulls : Boolean
The flag for reader to treat missing fields as nulls instead of throwing a MissingFieldException.
In case of providing column specifications manually the value of empty field defined as string will be empty instead of null
Default: true
Example: true
IgnoreQuotes : Boolean
A flag to let the reader know if quotes should be ignored.
Default: false
Example: false
Task Result
Success : Boolean
Operation complete without errors.
Example: true
Json : Object
Result as JToken.
Example: {[ {"value": "1", "foos": "foo", "bars": "bar"} ]}
Task Changelog
Changelog for Task Frends.CSV.ConvertToJSON.
[1.2.0] - 2025-05-12
Changed
Update package CsvHelper to version 33.1.0.
[1.1.0] - 2025-11-18
Added
Added IgnoreQuotes parameter to Options class. When set to true, quotes are treated as regular characters, allowing proper handling of CSV data with special characters in property names.
[1.0.0] - 2023-08-25
Changed
Initial implementation
Last updated
Was this helpful?