Question Re: CPI: How to map multiple fields multiple times to target node in Technology Q&A

CPI: How to map multiple fields multiple times to target node

rayd — Sat, 10 Aug 2024 10:44:14 GMT

I have a requirement to map a list of fields, and each value multiple times to target node.

Its similar like use Many as many function - compare with the standard function use one as many.

My source xml is like below:

and I want to map the each of the 'reference' node multuple times, the times equals the size of the subitem in source node.

Below are my expected target structure:

Is there a way to do it with standard mapping funcion? Or must write UDF?

Thanks a lot in advance

Re: CPI: How to map multiple fields multiple times to target node

sivaramaraju_danthuluri — Sun, 11 Aug 2024 15:21:03 GMT

HI Ryad,Can you try this code import com.sap.gateway.ip.core.customdev.util.Message; import groovy.xml.*; def Message processData(Message message) { // Get the XML body as a string def xmlBody = message.getBody(String.class); // Parse the XML using XmlParser to work with mutable XML structure def parser = new XmlParser() def xml = parser.parseText(xmlBody) // Create a new root element def newRoot = new Node(null, 'Root') new Node(newRoot, 'id', '123') // Initialize itemId for targetSubitem int targetItemId = 1 // Iterate over the original XML's items xml.items.each { item -> item.subItem.each { subItem -> // Create a new targetSubitem element def targetSubitem = new Node(newRoot, 'targetSubitem') // Add the generated itemId element new Node(targetSubitem, 'itemId', targetItemId.toString()) // Increment the itemId for the next targetSubitem targetItemId++ // Iterate over the references and add them to the targetSubitem item.references.each { ref -> def reference = new Node(targetSubitem, 'references') new Node(reference, 'code', ref.code.text()) new Node(reference, 'id', ref.id.text()) } } } // Convert the transformed XML back to a string def writer = new StringWriter() def xmlNodePrinter = new XmlNodePrinter(new PrintWriter(writer)) xmlNodePrinter.preserveWhitespace = true xmlNodePrinter.print(newRoot) def transformedXml = writer.toString() // Set the transformed XML as the new message body message.setBody(transformedXml) return message; }

Re: CPI: How to map multiple fields multiple times to target node

Ryan-Crosby — Sun, 11 Aug 2024 23:09:27 GMT

Given the source/target structures I think this would be pretty easy using IA.

Re: CPI: How to map multiple fields multiple times to target node

rayd — Mon, 12 Aug 2024 01:06:42 GMT

Hi Ryan, Could you tell me what exactally does 'IA' mean, I am somehow new to CPI, Thanks!

Re: CPI: How to map multiple fields multiple times to target node

Ryan-Crosby — Mon, 12 Aug 2024 01:12:39 GMT

Integration Advisor