csv to json transformer

CSV to JSON Converter

Version: 17.07

Supported Since: 17.07

What is CSV to JSON Converter Processor?

CSV to JSON Converter processing element can be used to convert CSV message payload to a JSON payload in a message context.

The CSV payload is expected to be in the RFC 4180 standard format and it is mandatory to have a header row.

In order to use this processing element, you must first select the CSV Message dependency from the processor list when you are creating an empty Ultra project. If you have already created a project, you can add this dependency via Component Registry. From Tools menu, select Ultra Studio → Component Registry and from the Processors list, select the CSV Message dependency.

csv json outports

Out Ports

Next

The message will be sent to this outport if the payload transformation is completed successfully

On Exception

The message will be sent to this outport if the processing element failed to convert the payload due to some reason

Sample Use Case

In the following use case, the requirement is to read a message with a CSV payload from a SFTP server, convert the message payload to JSON and then deliver it to another SFTP endpoint.

csv to json flow

In this flow, the "Processor" outport of SFTP ingress connector is connected to the inport of the CSV to JSON Processor so that the SFTP message received by the connector is handed over to the processing element next. If the processing element is able to convert the payload from CSV to JSON successfully, the message with the converted payload is handed over to the SFTP egress connector, as the "Next" outport of the CSV to JSON Processor is connected to it.

In the case of conversion failure, a log will be generated and then the message flow will be completed in an exceptional state, as the "On Exception" outport of the CSV to JSON Connector is connected to a Logger processing element, followed by an Exceptional Flow End element.

In this topic
In this topic
Contact Us