Solved: Removing CDATA around XML Adds Unwanted Escaping

Former Member · ‎02-24-2016

I've tried to follow examples in other posts but they have issues. This seems like something that should have a straight forward solution. I use a web service that returns a <DATA> node that contains CDATA that interns contains the XML payload I need. I've managed to write the java mapping to strip out the <DATA> and the CDATA and it looks fine when I test it in the OM test tab. But when I run this through PI the XML inside the CDATA is all escaped and everything I do to use it throws errors. I seriously need to get this working and could use any help. Here is a sample of the XML...

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_ExportPayload xmlns:ns0="http://isbdcapp86/Enablon7.8Train/rpc_literal.wsdl">

<FirstName>Nansun</FirstName>

</Record>

</Document>]]>

</Data>

</ns0:MT_ExportPayload>

OM Test Tab using my java map (code below) gives me this...

<Data>

<FirstName>Nansun</FirstName>

</Record>

</Document>

</Data>

But when I look at logs (soap message logs), I see this note the XML preamble in the <DATA> and even my needed xml is escaped...

<enab:ExportDataResponse xmlns:enab="enablon"> <Data><?xml version="1.0" encoding="UTF-16" standalone="yes" ?>

<FirstName>Nansun</FirstName>

</Record>

</Document></Data>

</enab:ExportDataResponse>

The Java map based on what I have found in other, somewhat old posts...

import org.w3c.*;

import org.w3c.dom.Document;

import org.w3c.dom.Node;

import org.w3c.dom.NodeList;

import com.sap.aii.mapping.api.*;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.InputStream;

import java.io.OutputStream;

public class GetEnablonPayload2 extends AbstractTransformation {

public void transform(TransformationInput transformationInput, TransformationOutput transformationOutput) throws StreamTransformationException {

try {

InputStream in = transformationInput.getInputPayload().getInputStream();

OutputStream out = transformationOutput.getOutputPayload().getOutputStream();

// Copy Input content to Output content

byte[] b = new byte[in.available()];

in.read(b);

DocumentBuilderFactory factory=DocumentBuilderFactory.newInstance();

DocumentBuilder builderel=factory.newDocumentBuilder();

Document docIn=builderel.parse(new ByteArrayInputStream(b));

Document docOut = null;

docOut=builderel.newDocument();

Node node;

NodeList nListRec = docIn.getElementsByTagName("Data");

node = nListRec.item(0);

Node clon = docOut.importNode(node,true);

docOut.appendChild(clon);

String sResult = null;

sResult = convertDocument_String(docOut);

sResult = sResult.replace("<![CDATA[<?xml version=\"1.0\" encoding=\"UTF-16\" standalone=\"yes\" ?>","");

sResult = sResult.replace("]]>","");

out.write(sResult.getBytes());

} catch (Exception exception) {

getTrace().addDebugMessage(exception.getMessage());

throw new StreamTransformationException(exception.toString());

}

public static String convertDocument_String(Document Doc){

String sResult ="";

StringWriter writer = new StringWriter();

try {

DOMSource domSource = new DOMSource(Doc);

StreamResult result = new StreamResult(writer);

TransformerFactory tf = TransformerFactory.newInstance();

Transformer transformer = tf.newTransformer();

transformer.setOutputProperty(OutputKeys.ENCODING, "UTF-8");

transformer.setOutputProperty(OutputKeys.OMIT_XML_DECLARATION, "yes");

transformer.transform(domSource, result);

} catch (Exception ex) {

ex.printStackTrace();

}

sResult = writer.toString();

return sResult;

}

former_member182412 · ‎03-08-2016

Hi Carlton,

The error you are getting is because of after the xml you have soap envelope tags and the namespace of envelope tags are different from your namespace that is why the XML after XSLT is not matching expected input XML of message mapping and target side the field occurrence is 1..1 that means it is mandatory element not optional that is why you are getting above error.


<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ns0="enablon">
   <xsl:output encoding="utf-8"/>
   <xsl:template match="@*|node()">
      <xsl:copy>
         <xsl:apply-templates select="@*|node()"/>
      </xsl:copy>
   </xsl:template>
   <xsl:template match="SOAP-ENV:*">
      <xsl:apply-templates select="@* | node()"/>
   </xsl:template>
   <xsl:template match="ns0:*">
      <xsl:element name="ns0:{local-name()}" namespace="http://isbdcapp86/Enablon7.8Train/rpc_literal.wsdl">
         <xsl:apply-templates select="@*|node()"/>
      </xsl:element>
   </xsl:template>
   <xsl:template match="*">
      <xsl:copy>
         <xsl:apply-templates select="*"/>
         <xsl:value-of select="substring-after(text(),&apos;?&gt;&apos;)" disable-output-escaping="yes"/>
      </xsl:copy>
   </xsl:template>
</xsl:stylesheet>

This XSLT will do below:

Remove CDATA
Remove UTF-16
Change the namespace from xmlns:ns0="enablon" to xmlns:ns0="http://isbdcapp86/Enablon7.8Train/rpc_literal.wsdl"
Remove soap envelope tags

Regards,

Praveen.

Former Member · ‎03-09-2016

Praveen & Eng, I finally have the end-to-end example working. And a lot of thanks goes to you guys. I learned so much! I do have one more question though, why is it necessary to remove the name space on the Message Types? Is this because the messages used by the web services are not using the same namespace? Because I tried to line them up. My next example will be 3rd party to SAP module.

Former Member · ‎03-08-2016

Praveen,

Thanks, I suspected there was something going on with the namespaces. I only use xsl occasionally and I'm just not that good at it yet. Unfortunatly something I've done has now broken the inbound side of this example so once I can get it working I'll try your xml. I had created one to strip out all the name spaces but still had this problem. And, it is still confuseing to me that it works in the test tab of the OM. I would think it would complain there too if the namespace did not match the target xml schema. I'll update when I can try this. Thank you!!!

RaghuVamseedhar · ‎03-02-2016

Carlton,

Please use below Java Mapping before Graphical Mapping in OM.

package com.map;

import java.io.*;

import com.sap.aii.mapping.api.*;

public class Test_JavaMapping extends AbstractTransformation {

@Override

public void transform(TransformationInput transformationInput, TransformationOutput transformationOutput) throws StreamTransformationException {

try {

InputStream inputstream = transformationInput.getInputPayload().getInputStream();

OutputStream outputstream = transformationOutput.getOutputPayload().getOutputStream();

byte[] b = new byte[inputstream.available()];

inputstream.read(b);

String input = new String(b);

input = input.replaceAll("<![CDATA[<?xml version=\"1.0\" encoding=\"UTF-16\" standalone=\"yes\" ?>","").replaceAll("]]>","")

.replaceAll(">",">").replaceAll("<","<").replaceAll("&","&"); //Remove or replace characters as required.

outputstream.write(input.getBytes());

} catch (Exception exception) {

getTrace().addDebugMessage(exception.getMessage());

throw new StreamTransformationException(exception.toString());

}

anupam_ghosh2 · ‎02-26-2016

Hi Carlton,

Joined this discussion late. I believe the java mapping code you wrote needs modification. I can suggest changes required in the code. Please can you provide the exact target XML you expect out of this source XML.


<?xml version="1.0" encoding="UTF-8"?>
<ns0:MT_ExportPayload xmlns:ns0="http://isbdcapp86/Enablon7.8Train/rpc_literal.wsdl">
<Data><![CDATA[<?xml version="1.0" encoding="UTF-16" standalone="yes" ?>
<Document>
  <Record>
    <EmployeeID>ID000006150265</EmployeeID>
    <ApplicationUser>&lt;None&gt;</ApplicationUser>
    <LastName>Shi</LastName>
    <FirstName>Nansun</FirstName>
  </Record>
</Document>]]>
</Data>
</ns0:MT_ExportPayload>

Regards

Anupam

former_member182412 · ‎02-25-2016

Hi Carlton,

Use below XSLT mapping.


<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
   <xsl:output omit-xml-declaration="yes" indent="yes" encoding="utf-8"/>
   <!--Identity template simply copies content forward -->
   <xsl:template match="@*|node()">
      <xsl:copy>
         <xsl:apply-templates select="@*|node()"/>
      </xsl:copy>
   </xsl:template>
   <xsl:template match="*">
      <xsl:copy>
         <xsl:apply-templates select="*"/>
         <xsl:value-of select="substring-after(text(),&apos;?&gt;&apos;)" disable-output-escaping="yes"/>
      </xsl:copy>
   </xsl:template>
</xsl:stylesheet>

Operation mapping test output.

Regards,

Praveen.

Former Member · ‎02-24-2016

i guess you should use value as "no" for the below line or //comment the line.

transformer.setOutputProperty(OutputKeys.OMIT_XML_DECLARATION, "yes");

Removing CDATA around XML Adds Unwanted Escaping

Accepted Solutions (1)

Accepted Solutions (1)

Answers (6)

Answers (6)

Re: SAP BUILD deployment to production

Re: How to use 2 IAS tenants in single GRC-IAG bri...

Re: Corporate Git Setup on SAP BTP versus connecti...

Re: Error: "Instantiation of calculation model fai...

Re: How to write the sum of same values into each ...