EN-US
Ask or search…
K
Links

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"
}
}
Last modified 1mo ago