cancel
Showing results for 
Search instead for 
Did you mean: 

Help needed to sorting records

das_sappo
Participant
0 Kudos

Dear Experts,

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 ?

2392014585|001|20230904|055225|CL1|601

2392014585|001|20230907|055225|FB1|311

238V005857|001|20230905|055225|KB1|311

238V005886|002|20230905|155225|CO1|101

238V005886|002|20230905|155225|CO1|261

238V005886|003|20230905|155225|CO1|261

238V005886|004|20230905|155225|CO1|261

238V005886|005|20230905|155225|CO1|261

Regards,

Arvik

Accepted Solutions (0)

Answers (1)

Answers (1)

Bais
Participant
0 Kudos

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.