How to split the message and receive element into WSO2 ESB 4.7.0

Question

Hi i am receiving the file from remote server which in .csv format into wso2 ESB proxy service and i am getting the response as

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><text xmlns="http://ws.apache.org/commons/ns/payload">firstname,lastname
a,John
b,Scott
c,Tiger
d,Manager
</text></soapenv:Body></soapenv:Envelope>

but how can i split this message element by element and receive each element into ESB Proxy service.

Guide me how can i receive the split message into ESB and store into database.

Answer 1

I guess, you can use smooks mediator and convert CSV data to XML. Then data can be retrieved using XPath. There is a Stackoverflow question on this, Please go through it. Also you can use db report mediator to persist data in to preferred database. You find doc from here. One you convert data to XML, then you can use XPath to define the data that must be persisted in to database. However, you can even write a custom medaitor for ESB, if you want to do some more things than that. Here it explains how to write a custom mediator