CSV to JSON V2

Learn how users can utilize CSV to JSON V2 in order to transform a CSV into a JSON object. The Documentation Portal provides configuration parameters of this component.

CSV to JSON V2 transforms a CSV into a JSON object.

Parameters

Take a look at the configuration options for the component. Parameters supported by Double Braces expressions are marked with (DB).

Parameter	Description	Default value	Data type
CSV as File	If the option is enabled, the component waits for a file to generate the output JSON; otherwise, it is necessary to stop a CSV as an array or string.	False	Boolean
Charset	If the CSV As File option is enabled, this field will be shown, and the name of the character code for the file reading (standard UTF-8) should be specified.	UTF-8	String
File Name	When the CSV As File option is enabled, this field will be shown, and it should get the name of the CSV file.	N/A	String
CSV	When the CSV As File option is disabled, this field will be shown, and a CSV in JSON format (array or string) must be provided.	N/A	String or array of strings
CSV Has Header	Keep this option enabled if the CSV to be transformed has headers at the beginning of the array, string, or file.	True	Boolean
Headers	List of CSV headers to be read – each CSV header will be converted to a JSON property. It is displayed only if the CSV Has Reader option is deactivated.	N/A	Array of strings
Delimiter	Delimiter in which the CSV is configured.	, (comma)	String
Fail On Error	If the option is enabled, the pipeline execution will be interrupted in case of an error. Otherwise, the pipeline execution proceeds, but the result will show a false value for the "success" property.	True	Boolean

Messages flow

Input

The component waits for a message with the property. You can provide the CSV data as an array of strings:

{    
    "data": ["HEADER1,HEADER2,HEADER3", "LINE1,LINE1,LINE1", ...]
}

as an unique string:

{    
    "data": "HEADER1,HEADER2,HEADER3\nLINE1,LINE1,LINE1\nLINE2,LINE2,LINE2"
}

or as a file:

File Name: arquivo.csv

Output

{
    "data": [{"HEADER1": "LINE1",
        "HEADER2": "LINE1",
        "HEADER3": "LINE1"
        },
        {"HEADER1": "LINE2",
        "HEADER2": "LINE2",
        "HEADER3": "LINE2"
        }, ....]
}

If you receive an unique string:

{       
    "data": [{"HEADER1": "LINE1",
        "HEADER2": "LINE1",
        "HEADER3": "LINE1"
    },
{"HEADER1": "LINE2",
        "HEADER2": "LINE2",
        "HEADER3": "LINE2"
    }]         
}