CSV/TXT to JSON

Convert CSV or TXT file to JSON attribute. You can download this system service from Grexx Marketplace.

Input

Use a casetype activity to add inputs to the Start Systemservice CSV/TXT to JSON form.

Attribute	Data type	Mandatory?	Description
Column prefix	String	No	If headerRow==0 (see below), columns are provided with a header. This header consists of a prefix and a sequence number (for example: column_1, column_2, ...). Default: column_
CSV	String	Yes	CSV/TXT file with content to be converted to JSON.
Field delimiter	String	No	The character used to split columns. Default: ,
Header row	Integer	No	Line number on which the column headers can be found. 0 means there are no header rows. Default: 0
Skip bottom rows	Integer	No	Number of lines (from bottom) to ignore when reading. Default: 0
Skip top rows	Integer	No	Number of lines (from top) to ignore when reading. Default: 0
Text delimiter	String	No	The character used to denote text fields. This is required if the field delimiter character can appear in a text field. Default: "

Output

Outputs are added to the Result Systemservice CSV/TXT to JSON form when the Systemservice CSV/TXT to JSON case is closed.

Attribute	Data type	Mandatory?	Description
JSON	JSON (multivalue)	No	The converted content.