Skip to main content

Quantela platform user manual

CSVToJSON

Description

Convert data from tabular CSV format to JSON format

Input

String or JSON

Output

JSON

Cell Delimiters

The character used to delimit values within each row of data. This is typically a comma. 

Row delimiters

The character or sequence of characters used to delimit rows. This is typically a new-line character denoted as ‘\n’ and/or a carriage-return character denoted as ‘\r’. The default is ‘\r\n’.

Format

The JSON output format can be one of the following:

  • Array of dictionaries, e.g. [ {"Name":"A", "Age":"43", "State":"CA"}, {"Name":"B", "Age":"23", "State":"VA"}, {"Name":"C", "Age":"24", "State":"NY"} ]

  • Array of arrays, e.g. [ ["Name", "Age", "State"], ["A", "43", "CA"], ["B", "23", "VA"], ["C", "24", "NY"] ]

IsCollection

If True then the input parameter is a JSON collection, otherwise it is simply a string.

IteratorKey

If the input parameter is a JSON collection, then this parameter indicates the specific attributes in the collection that the function is to operate on.

In this section: