I am getting data in CPI in the following format. My requirement is to convert the data in XML and sort out the records with unique value (in color) and post to target API.
For the following file I have to create 3 messages.
First message - 2 records
2nd message - 1 records
3rd message - 5 records
Could you please advise how can we do it ?
it's a csv with delimiter | pipe,
just create and xsd with fields you need (you can begin with xml and transform it in xsd) next use CPI CSV to XML conversion.
I don't understand second passage, you want to split records in order of first field and call an API to with values and another structure?
send me an example of body of your api call.