Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • kinra 2 posts 82 karma points
    Dec 16, 2015 @ 03:17
    kinra
    0

    XML Transformation using XSLT -get value-of select and to delete a element

    Hello there,

    Need Help...

    I am converting source xml to target xml using xslt . I have below two questions :

    1. How to the get a value of element <ns0:SID>4567</ns0:SID> from source XML to Target XML element <urn:sessionId /> using XSLT
    2. How to delete element <ns0:SID>4567</ns0:SID> when source XML transforms to Target XML

    Below are the source XML, XSLT Transform and Target XML

    Source XML :

    <?xml version="1.0" encoding="UTF-8"?>
<ns0:Submit_Input
xmlns:ns0="http://soap.sforce.com/schemas/class/test">
<ns0:ListOfInboundResponse>
<ns0:TransactionHeader>
<ns0:ListOfTransactionDetailItems>
<ns0:ErrorDesc>123</ns0:ErrorDesc>
<ns0:ErrorNum />
<ns0:ErrorSeverity />
<ns0:LineNumber />
<ns0:Status />
</ns0:ListOfTransactionDetailItems>
<ns0:PONumber />
<ns0:SID>4567</ns0:SID> 
<ns0:TransactionId />
<ns0:TransactionMode />
<ns0:TransactionNumber />
<ns0:TransactionRowId />
<ns0:TransactionStatus />
<ns0:TransactionType />
</ns0:TransactionHeader>
<ns0:TransactionHeader>
<ns0:ListOfTransactionDetailItems>
<ns0:ErrorDesc />
<ns0:ErrorNum />
<ns0:ErrorSeverity />
<ns0:LineNumber />
<ns0:Status />
</ns0:ListOfTransactionDetailItems>
<ns0:PONumber />
<ns0:TransactionId />
<ns0:TransactionMode />
<ns0:TransactionNumber />
<ns0:TransactionRowId />
<ns0:TransactionStatus />
<ns0:TransactionType />
</ns0:TransactionHeader>
</ns0:ListOfInboundResponse>
</ns0:Submit_Input>

    XSLT Transform

    <?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:urn="urn:partner.soap.sforce.com">
<soapenv:Header>
<urn:SessionHeader>
<urn:sessionId>
<xsl:value-of select="SID" />
</urn:sessionId>
</urn:SessionHeader>
</soapenv:Header>
<soapenv:Body>
<xsl:copy-of select="." />
</soapenv:Body>
</soapenv:Envelope>
</xsl:template>
</xsl:stylesheet>

    Target XML

    <?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:urn="urn:partner.soap.sforce.com">
<soapenv:Header>
<urn:SessionHeader>
<urn:sessionId />
</urn:SessionHeader>
</soapenv:Header>
<soapenv:Body>
<ns0:Submit_Input xmlns:ns0="http://soap.sforce.com/schemas/class/test">
<ns0:ListOfInboundResponse>
<ns0:TransactionHeader>
<ns0:ListOfTransactionDetailItems>
<ns0:ErrorDesc>123</ns0:ErrorDesc>
<ns0:ErrorNum />
<ns0:ErrorSeverity />
<ns0:LineNumber />
<ns0:Status />
</ns0:ListOfTransactionDetailItems>
<ns0:PONumber />
<ns0:SID>4567</ns0:SID>
<ns0:TransactionId />
<ns0:TransactionMode />
<ns0:TransactionNumber />
<ns0:TransactionRowId />
<ns0:TransactionStatus />
<ns0:TransactionType />
</ns0:TransactionHeader>
<ns0:TransactionHeader>
<ns0:ListOfTransactionDetailItems>
<ns0:ErrorDesc />
<ns0:ErrorNum />
<ns0:ErrorSeverity />
<ns0:LineNumber />
<ns0:Status />
</ns0:ListOfTransactionDetailItems>
<ns0:PONumber />
<ns0:TransactionId />
<ns0:TransactionMode />
<ns0:TransactionNumber />
<ns0:TransactionRowId />
<ns0:TransactionStatus />
<ns0:TransactionType />
</ns0:TransactionHeader>
</ns0:ListOfInboundResponse>
</ns0:Submit_Input>
</soapenv:Body>
</soapenv:Envelope>

    Thanks Kiran

    (Edited to display the code snippets)

    Copy Link
  • Chriztian Steinmeier 2800 posts 8790 karma points MVP 8x admin c-trib
    Dec 16, 2015 @ 13:32
    Chriztian Steinmeier
    100

    Hi Kiran,

    (Note: I've edited the question to show the code snippets, which were hidden - hope that's alright with everyone)

    Here's a transform XSLT that does the trick - it looks a bit scary because of the namespaces, when in reality, it's pretty straightforward, e.g.:

    • Output the soap Envelope header-stuff, handpicking the session ID from further down.
    • Process the document using the identity template which will automatically use the specific template for the SID element we don't want to output.

    EDIT: Looks like code snippets are broken again, sigh...

    I've posted a Gist with the code here

    Hope that helps,

    /Chriztian

    Copy Link
  • kinra 2 posts 82 karma points
    Dec 16, 2015 @ 15:32
    kinra
    0

    Thank you Chriztian. That works !!!!

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft