# ConvertToJSON Required Frends version: 5.5+ Required .NET version: 6.0 Compatible Agents: Crossplatform Source code: {% tabs %} {% tab title="Parameter: Input" %} | Name | Description | | ---------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | 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 } ]

| | {% endtab %} | | {% tab title="Parameter: Options" %} | Name | Description | | | -------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------- | | 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:

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

| | | {% endtab %} | | | {% tab title="Result: Result" %} | Name | Description | | ------------------- | ----------------------------------------------------------------------------------------------------- | | Success : `Boolean` |

Operation complete without errors.
Example: true

| | Json : `Object` |

Result as JToken.
Example: {\[ {"value": "1", "foos": "foo", "bars": "bar"} ]}

| | {% endtab %} | | {% tab title="Changelog" %} ## Changelog ### \[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 {% endtab %} {% endtabs %}