CSV to JSON V1 (Deprecated)

Discover more about the CSV to JSON V1 component and how to use it on the Digibee Integration Platform.

The CSV to JSON V1 is deprecated and no longer updated. Please refer to the document with the most recent version of the feature: CSV to JSON V2.

CSV to JSON V1 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
Headers	List of headers to be read – each CSV header is converted into a JSON property.	N/A	Array of strings
Delimiter	Delimiter in which CSV is configured.	N/A	String
CSV Has Header	Keep the option activated if the CSV to be transformed has a header in the beginning of the array.	False	Boolean
Fail On Error	If the option is activated, the execution of the pipeline with error will be interrupted; otherwise, the pipeline execution proceeds, but the result will show a false value for the "success" property.	False	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", ...]
}

or provide the CSV data as a single string:

{    
    "data": "LINE1,LINE1,LINE1"
}

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"
    }              
}