JSON to CSV Transformer (Deprecated)
Discover more about the JSON to CSV Transformer component and how to use it on the Digibee Integration Platform.
Last updated
Discover more about the JSON to CSV Transformer component and how to use it on the Digibee Integration Platform.
Last updated
The JSON to CSV Transformer is deprecated and no longer updated. Please refer to the document with the most recent version of the feature: JSON to CSV V2.
JSON to CSV Transformer has the function of receiving a JSON object and, from it, generating an array with the data for the CSV already formatted.
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 |
---|---|---|---|
The component waits for a message with the property "data" in the JSON. The value of this property can be an array or an object. See next a simple example that shows the functionality of JSON to CSV Transformer:
You must configure an input JSON in a pipeline with the JSON to CSV Transformer component. After adding it to the pipeline, it's necessary to configure the headers as product,price or the example won't work.
With the configurations done according to the specifications above, the result will be:
See below how the component responds to a situation and its specific configuration.
With the pointed configurations, the JSON won't be processed and the result will be an error message with the property success: false
With the pointed configurations, the JSON will be processed and the result will be a csv with the object correctly treated.
With the pointed configurations, the JSON won't be processed and the deployment will be immediately interrupted.
Headers
Configures the headers the component will use to process the text. The items are separated by comma and can have more than one input. It's a mandatory parameter and must be configured according to what you want to process.
N/A
String (CSV)
Delimiter
Delimiting symbol to be used in the text processing. By standard, this option is configured as a comma (","). It's a mandatory parameter that can use many symbols as a separator.
","
String
Print Headers
If activated, the option inserts in the result the previously configured headers as the first element of the resulting array.
False
Boolean
Coalesce
If activated, and an input message value corresponds to some object/array, the input will be processed and the deployment will happen normally; otherwise, when receiving a value as object/array, an error will be presented as result and "false" will be assigned to the property “success”.
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