Version: 17.07
Supported Since: 17.07
CSV Rows Extractor processing element can be used to extract the rows in the CSV payload. This processing element provides the functionality to skip the first row assuming it could be a header.
The CSV payload is expected to be in the RFC 4180 standard format.
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 |
Skip First Row |
Basic |
If selected first row will be ignored during extraction.
|
||
Variable Name |
Basic |
Name of the variable which is used to store the extracted rows |
In the following use case, the requirement is to read a CSV file from a NIO File Ingress Connector extract all the rows from the CSV message payload and pass it to a custom processing element, perform some custom processing using the extracted rows and finally deliver the message to a backend service via NIO HTTP Egress Connector