Read data of all repeating tags and put in one text field
If you are working with Dell Boomi in order to integrate SAP data you must find a need for this, as this is SAP standard behavior that when it creates an XML or IDoc of text data it start reapeating tags till the number of enter in that field.
E.g:
In SAP you enter following text:
This is my first blog
I am writing this blog about Dell Boomi
and SAP general behaviors
When an IDoc/XML file will be created it will look like this:
<IDOC BEGIN="1">
<Notes>This is my first blog</Notes>
<Notes> I am writing this blog about Dell Boomi </Notes>
<Notes> and SAP general behaviors </Notes>
</IDOC BEGIN="1">
Problem
Now issue is that your destination system need this complete text in one field along with enters. If you directly map this tag in your map component only Dell Boomi will only read first ever line and all the other text will be gone.
Solution
In order to solve this issue you can use groovy in data process to read all these kind of repeating tags and then create a new node in your process and map that node with your destination text field.
Groovy Code:
import java.util.Properties;
import java.io.InputStream;
import org.jdom.input.SAXBuilder;
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.xpath.XPath;
import org.jdom.output.XMLOutputter;
import com.boomi.execution.ExecutionUtil;
Integer Count = 0;
for( int i = 0; i < dataContext.getDataCount(); i++ ) {
InputStream is = dataContext.getStream(i);
Properties props = dataContext.getProperties(i);
// Build XML Document
SAXBuilder builder = new SAXBuilder();
Document doc = builder.build(is);
XPath Approved_Pricing;
Approved_Pricing = XPath.newInstance("//ZDEBMAS/IDOC/E1KNVVH[TDID='Z002']/E1KNVVL/TDLINE");
MSGFN = Approved_Pricing.selectNodes(doc);
Desc='';
result = new StringBuffer();
for(int ak=0;ak<MSGFN.size();ak++){
if (Count < 10){
result.append(MSGFN[ak].getText()+System.getProperty('line.separator'));
Count = Count + 1;
}
}
Desc = result.toString();
Notes = new Element("Pricing_Notes_Description").addContent(Desc);
x = XPath.newInstance("//ZDEBMAS/IDOC");
eleParentElement = x.selectSingleNode(doc);
if(eleParentElement !=null){
eleParentElement.addContent(Notes);
}
XMLOutputter outputter = new XMLOutputter();
is = new ByteArrayInputStream(outputter.outputString(doc).getBytes("UTF-8"));
dataContext.storeStream(is, props);
}
You are adding a new element Notes in the root IDoc which you can then map to your destination field.you also have to provide complete and accurate path of that repeating tag.
Hope this helps you. Happy Coding !!!
