Remove xml-stylesheet

[Former Member]

Hi All,

We are using PI7.0.

We have extracted xml  a exchange rate URL and it has the reference to a xsl in it as below

<?xml version="1.0" encoding="ISO-8859-9"?><?xml-stylesheet type="text/xsl" href="ABC.xsl"?>.

So XML is not getting displayed in sxmb_moni. Please let me know if it Is possible to remove this refrence from xml in PI.

[iaki_vila]

Hi Pavi,

May be i misunderstood your real problem, but if you only want to omit the tag "<?xml-stylesheet type="text/xsl" href="ABC.xsl"?", you can do the next XSL-mapping,

Source XML:

<?xml version="1.0" encoding="ISO-8859-9"?>
<?xml-stylesheet type="text/xsl" href="ABC.xsl"?>
<a>
    <b>2</b>
</a>

XSL to skip the tag:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="xml"/>
    <xsl:template match="/">
        <xsl:copy-of select="/a"/>
    </xsl:template>
</xsl:stylesheet>

Target XML:

<?xml version="1.0" encoding="UTF-8"?>
<a>
    <b>2</b>
</a>

Hope this helps.

Regards.

[Former Member]

Thanks a lot Inaki Vila...

This solved my problem.

[nikhil_bose]

To display the XML either change "text/xsl" to "text/xml" or remove the entire line <?xml-stylesheet type="text/xsl" href="ABC.xsl"?>

[Former Member]

Thanks Nikhil.....problem solved

[nikhil_bose]

Pavi, is http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/01/05/michals-pi-tips-exchange-rates-fr... your use case?

[Former Member]

Yes Nikhil. Our requirement is the same as in Michal's link. But we have not used axis adapter due to version problem. We used UDF to extract the XML. But we having reference to xsl file.