> For the complete documentation index, see [llms.txt](https://docs.frends.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.frends.com/tasks/tasks/csv/converttojson.md). # ConvertToJSON Task version: 1.2.0 Required Frends version: 5.5+ Required .NET version: 6.0 Compatible Agents: Crossplatform Source code: ## Task Parameters {% tabs %} {% tab title="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="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 %} | | | | {% endtabs %} | | | ## Task Result | Name | Description | | ------------------- | ----------------------------------------------------------------------------------------------------- | | 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 --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.frends.com/tasks/tasks/csv/converttojson.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.