Solved: How to remove an XML with a SOAP Enveloppe

Former Member · ‎10-19-2012

Hi all,

I have the following message that PI received from an external application called Flexnet:

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

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<soap:Body>

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

<FlexNet.BusinessFacade.Common.OrderRestatuser.OrderRestatuser xmlns="http://www.Apriso.com/FlexNet.BusinessFacade.Common.OrderRestatuser.OrderRestatuser.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<EmployeeNo>schrodere</EmployeeNo>

<Facility>FIGUE</Facility>

<FunctionName>GenMessageClotureLE</FunctionName>

<OperationCode>ODY_FLUX_Reception_ConfirmationSAP</OperationCode>

<SNDPRN>FLEXNET</SNDPRN>

<RCVPRN>CIMSAPLOG</RCVPRN>

</PartnerInfo>

</ValueList>

</Item>

</ValueList>

</Item>

</ValueList>

</Item>

</ValueList>

</Item>

</ValueList>

</Item>

</ValueList>

</Item>

</PropertyBagV2>

</SessionContext>

<FlexNet.BusinessRules.Common.Orders.OrderRestatuser.RestatusOrder xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

</FlexNet.BusinessRules.Common.Orders.OrderRestatuser.RestatusOrder>

<FlexNet.BusinessRules.Common.Orders.OrderRestatuser.RestatusOrderLine xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

</FlexNet.BusinessRules.Common.Orders.OrderRestatuser.RestatusOrderLine>

</FlexNet.BusinessFacade.Common.OrderRestatuser.OrderRestatuser>

</xmlMessage>

<applicationName>FlexNet.BusinessFacade.Common.OrderRestatuser.OrderRestatuser</applicationName>

</ProcessMessage>

</soap:Body>

</soap:Envelope>

I have to remove the SOAP Enveloppe for a mapping to an IDoc.

I have tried the SOAP adapter with the following URL provided to Flexnet to send date to PI:

http://host:port/XISOAPAdapter/MessageServlet?QOS=EO&interface=MI_FLE_PI_GLOBAL&...

PI did not receive any message.

I have tried the following URL from Flexnet

http://host:port/sap/xi/adapter_plain?QOS=EO&interface=MI_FLE_PI_GLOBAL&namespac...

PI receives the message in error in sxmb_moni with the above xml with a SOAP enveloppe.

I also tried an XSLT Mapping, but it's not working.

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

<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<xsl:template match="xmlMessage">

<xsl:copy-of select="child::node()"/>

</xsl:template>

</xsl:stylesheet>

Could you please advise on the URL to use? Also, would a XSLT/Java Mapping remove the SOAP Enveloppe because we have

<?xml version="1.0" encoding="utf-8"?> occuring two times.

Thanks in advance!

Vincent

Former Member · ‎01-07-2013

Thanks Anupam, Michal and Iñaki.

Your answers were very helpful.

However, I investigated on Flexnet's side and they have a BizTalk adapter that, when configured with username and password and the URL to PI's interface, sends XML over HTTP to the integration engine.

However, only one BizTalk adapter in Flexnet can be configured to send data to PI and thus the need for a single entry point in PI (Especially when you have several inbound interfaces from Flexnet).

Best regards,

Vincent

iaki_vila · ‎10-23-2012

Hi Vicent,

At first i'd like to comment that the second <?xml version="1.0" encoding="utf-8"?> is incorrect in XML definition, at least you are using a CDATA.

Incorrect XML validation:

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
   <soap:Body>
      <ProcessMessage xmlns="http://tempuri.org/">
         <xmlMessage>
            <?xml version="1.0" encoding="utf-8"?>
            <FlexNet.BusinessFacade.Common.OrderRestatuser.OrderRestatuser xmlns="http://www.Apriso.com/FlexNet.BusinessFacade.Common.OrderRestatuser.OrderRestatuser.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
....

Correct XML Validation:

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
   <soap:Body>
      <ProcessMessage xmlns="http://tempuri.org/">
         <xmlMessage><![CDATA[
            <?xml version="1.0" encoding="utf-8"?>
            <FlexNet.BusinessFacade.Common.OrderRestatuser.OrderRestatuser xmlns="http://www.Apriso.com/FlexNet.BusinessFacade.Common.OrderRestatuser.OrderRestatuser.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
...
]]>

If you can remove this second XML header tag, this XSL can do the transformation required:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" exclude-result-prefixes="soap">
    <xsl:output method="xml" indent="yes"/>
    <xsl:template match="/">
        <xsl:copy-of select="/soap:Envelope/soap:Body/child::*/child::*"/>
    </xsl:template>
</xsl:stylesheet>

If you can't remove that tag, the unique solution is the solution that Anupam suggested or to study if the flexnet can send the XML inside a CDATA.

Regards

anupam_ghosh2 · ‎10-21-2012

Hi Vincent,

you are receiving a response using the 2nd URL then you can use a java mapping code to obtain only the part of the message important for you. That is the xml within tags <FlexNet.BusinessFacade.Common.OrderRestatuser.OrderRestatuser> and </FlexNet.BusinessFacade.Common.OrderRestatuser.OrderRestatuser>. I assume you are working in PI 7.1 or above versions. You can use following java mapping code to obtain desired XML.

import java.io.BufferedReader;
import java.io.ByteArrayInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStream;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;
import org.w3c.dom.Document;
import org.w3c.dom.Node;
import com.sap.aii.mapping.api.AbstractTransformation;
import com.sap.aii.mapping.api.StreamTransformationException;
import com.sap.aii.mapping.api.TransformationInput;
import com.sap.aii.mapping.api.TransformationOutput;
public class DOMParser extends AbstractTransformation{
          /**
           * @param args
           */
          static String payload="";
          public  void extractXMLPayload(InputStream in)
           {
            String s="";
            try
            {
             BufferedReader br= new BufferedReader(new InputStreamReader(in));
             int startIndex=0,endIndex=0;
             String line="",str="";
             while((line=br.readLine())!=null)
             {
              str+=line;
             }
             startIndex=str.indexOf("<FlexNet.BusinessFacade.Common.OrderRestatuser.OrderRestatuser");
             endIndex=str.indexOf("</FlexNet.BusinessFacade.Common.OrderRestatuser.OrderRestatuser>");
             if(endIndex>startIndex)
             {
               s="<?xml version=\"1.0\" encoding=\"UTF-8\" ?>";   
               s=s+str.substring(startIndex,endIndex+ ("</FlexNet.BusinessFacade.Common.OrderRestatuser.OrderRestatuser>".length()));
             }  
            }
            catch(Exception e)
            {
             e.printStackTrace();
            }
            payload=s;
           }
          public void execute(InputStream in, OutputStream out)throws Exception
          {
                    Document document;
                    DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
                    DocumentBuilder builder = factory.newDocumentBuilder();
                    extractXMLPayload(in);
                    InputStream is=null;
                    is= new ByteArrayInputStream(payload.getBytes("UTF-8"));
                    document = builder.parse(is);
                    Document docOut=builder.newDocument(); 
                    Node root=docOut.importNode(document.getDocumentElement(),true);
                    docOut.appendChild(root);
                    TransformerFactory tf = TransformerFactory.newInstance();
                    Transformer transform = tf.newTransformer();
                    transform.transform(new DOMSource(docOut), new StreamResult(out));
          }
          public static void main(String[] args) {
                    // TODO Auto-generated method stub
                     try
                        {
                                              FileInputStream inFile = new FileInputStream(new File("c:\\apps\\scn\\input.xml"));
                         FileOutputStream outFile = new FileOutputStream(new File("c:\\apps\\scn\\output.xml"));
                         new DOMParser().execute(inFile,outFile);
                        }catch(Exception e){e.printStackTrace();}
          }
          @Override
          public void transform(TransformationInput arg0, TransformationOutput arg1)
                              throws StreamTransformationException {
                    // TODO Auto-generated method stub
                    try {
                              this.execute(arg0.getInputPayload().getInputStream(), arg1.getOutputPayload().getOutputStream());
                    } catch (Exception e) {
                              // TODO Auto-generated catch block
                              e.printStackTrace();
                    }  
          }
}

Hope this resolves the problem.

Regards

Anupam

MichalKrawczyk · ‎10-20-2012

Hi,

for this option:

>>>>>I have tried the SOAP adapter with the following URL provided to Flexnet to send date to PI:

http://host:port/XISOAPAdapter/MessageServlet?QOS=EO&interface=MI_FLE_PI_GLOBAL&...

PI did not receive any message.

did you get the WSDL from this app and is it imported to ESR ?

if so try investigating why the message did not reach PI as PI would remove the envelope itself

if properly sent

Regards,

Michal Krawczyk

How to remove an XML with a SOAP Enveloppe

Accepted Solutions (1)

Accepted Solutions (1)

Answers (3)

Answers (3)

Re: Trigger Basic Idoc from scratch

Re: ABAP2XLSX in an old Abap version

Re: CIG transaction tracker handling

Re: CIG transaction tracker handling

Re: The data action couldn't run because of a prob...