Using XPath with non-standard XML

Here is the outline of the XML data that we are getting from an external source. I would like to use XPath in an xslt to get to the elements that I need. Right now I am only able to get to "/soap:Envelope/soap:Body/n1:ProcessMessage". Anything after that, I'm not able to get it to recognized as a valid path. Is there a proper way to get into the "ns1:CreditDecision" element using XPath rather than using for-each loops with "child::*"?

Thanks for your help!

Expand|Select|Wrap|Line Numbers

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

    <soap:Body>

        <ProcessMessage xmlns="http://localhost/site/ProcessCreditDecision">

            <sPayload>

                <ns1:ProcessCreditDecision xmlns:ns1="http://www.starstandards.org/STAR">

                    <ns1:ApplicationData></ns1:ApplicationData>

                    <ns1:DataArea>

                        <ns2:Process xmlns:ns2="http://www.openapplications.org/oagis"></ns2:Process>

                        <ns1:CreditDecision>

                            <ns1:Header></ns1:Header>

                            <ns1:Detail>

                                <ns1:Field1>field 1</ns1:Field1>

                                <ns1:Field2>field 2</ns1:Field2>

                                <ns1:Field3>field 3</ns1:Field3>

                                <ns1:Field4>field 4</ns1:Field4>

                                <ns1:Field5>field 5</ns1:Field5>

                                <ns1:Field6>field 6</ns1:Field6>

                            </ns1:Detail>

                        </ns1:CreditDecision>

                    </ns1:DataArea>

                </ns1:ProcessCreditDecision>

            </sPayload>

        </ProcessMessage>

    </soap:Body>

</soap:Envelope>

Oct 23 '08 #1

Subscribe Post Reply

2596

Dormilich

8,658

Expert Mod 8TB

usually with "//ns1:CreditDecision". does it give you an error if you try that?

regards

Oct 24 '08 #2

ianoble

I've supplied more detailed xml below, because when I use "//ns1:CreditDecision" for the match property of my template, I get all of the data in the ApplicationData section outputted before the data in my template. Do I need to create another template to account for anything outside of the data I am trying to match?

XML:

Expand|Select|Wrap|Line Numbers

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

    <soap:Body>

        <ProcessMessage xmlns="http://localhost/site/ProcessCreditDecision">

            <sPayload>

                <ns1:ProcessCreditDecision xmlns:ns1="http://www.starstandards.org/STAR">

                    <ns1:ApplicationData>

                        <ns1:Sender>

                            <ns1:Component>LoanCenter</ns1:Component> 

                            <ns1:Task>CreditDecision</ns1:Task> 

                            <ns1:ReferenceId>00000094022</ns1:ReferenceId> 

                            <ns1:CreatorNameCode>APPRO</ns1:CreatorNameCode> 

                            <ns1:SenderNameCode>XX</ns1:SenderNameCode> 

                        </ns1:Sender>

                        <ns1:CreationDateTime>2008-05-15T14:30:33Z</ns1:CreationDateTime> 

                        <ns1:BODId>40008351</ns1:BODId> 

                        <ns1:Destination>

                            <ns1:DestinationNameCode>XX</ns1:DestinationNameCode> 

                        </ns1:Destination>

                    </ns1:ApplicationData>

                    <ns1:DataArea>

                        <ns2:Process xmlns:ns2="http://www.openapplications.org/oagis"></ns2:Process>

                        <ns1:CreditDecision>

                            <ns1:Header></ns1:Header>

                            <ns1:Detail>

                                <ns1:Field1>field 1</ns1:Field1>

                                <ns1:Field2>field 2</ns1:Field2>

                                <ns1:Field3>field 3</ns1:Field3>

                                <ns1:Field4>field 4</ns1:Field4>

                                <ns1:Field5>field 5</ns1:Field5>

                                <ns1:Field6>field 6</ns1:Field6>

                            </ns1:Detail>

                        </ns1:CreditDecision>

                    </ns1:DataArea>

                </ns1:ProcessCreditDecision>

            </sPayload>

        </ProcessMessage>

    </soap:Body>

</soap:Envelope>

XSLT:

Expand|Select|Wrap|Line Numbers

 
    <xsl:template name="CreditDecision" match="//ns1:CreditDecision" >

        <html>

            <head>

                <title>test xml</title>

            </head>

            <body style="font-family:arial;font-size:10pt;">

                <div>

                    <xsl:for-each select="child::*"><!--CreditDecision//-->

                        <xsl:if test="name()='ns1:Detail'">

                            <xsl:for-each select="child::*">

                                <h2><xsl:value-of select="replace(name(),'ns1:','')" /></h2>

                                <div style="padding-left:30px;">

                                <xsl:if test="*[not(*)]">

                                    <xsl:for-each select="child::*">

                                        <xsl:choose>

                                            <xsl:when test="*[not(*)]"><!--If the element has children//-->

                                                <div>

                                                <h4><xsl:value-of select="replace(name(),'ns1:','')" /></h4>

                                                <xsl:for-each select="child::*">

                                                    <xsl:choose>

                                                        <xsl:when test="*[not(*)]"><!--If the element has children//-->

                                                            <div>

                                                            <h4><xsl:value-of select="replace(name(),'ns1:','')" /></h4>

                                                            <xsl:for-each select="child::*">

                                                                <xsl:call-template name="main" />

                                                            </xsl:for-each>

                                                            </div>

                                                        </xsl:when>

                                                        <xsl:otherwise>

                                                            <xsl:call-template name="main" />

                                                        </xsl:otherwise>

                                                    </xsl:choose>

                                                </xsl:for-each>

                                                </div>

                                            </xsl:when>

                                            <xsl:otherwise>

                                                <xsl:call-template name="main" />

                                            </xsl:otherwise>

                                        </xsl:choose>

                                    </xsl:for-each>

                                </xsl:if>

                                </div>

                            </xsl:for-each>

                        </xsl:if>

                    </xsl:for-each>

                </div>

            </body>

        </html>

    </xsl:template>

    <xsl:template name="main">

        <div>

            <span style="font-weight:bold;width:175px;text-align:right;padding-right:5px;">

                <xsl:value-of select="name()"/>

            </span>

            <span>

                <xsl:value-of select="."/>

            </span>

        </div>

    </xsl:template>

Oct 24 '08 #3

jkmyoung

2,057

Expert 2GB

Can we see where you declare namespace ns1?

Be careful of using generic namespace names like ns1, ns2 etc... It doesn't really give you any other information.

xmlns:ns1="http://www.starstandards.org/STAR"

Oct 24 '08 #4

ianoble

Can we see where you declare namespace ns1?

Be careful of using generic namespace names like ns1, ns2 etc... It doesn't really give you any other information.

xmlns:ns1="http://www.starstandards.org/STAR"

Sure:

Expand|Select|Wrap|Line Numbers

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

    xmlns:ns1="http://www.starstandards.org/STAR" xmlns:ns2="http://www.openapplications.org/oagis" xmlns:n1="http://www.approsystems.com/CUDL/ProcessCreditDecision">

Oct 24 '08 #5

Dormilich

8,658

Expert Mod 8TB

instead of using replace(name(),'ns1:','') you can use the much more comfortable local-name().
I have no idea why the ApplicationData are printed, but it occurs only when a template (//ns1:*) is called. worked around it with <xsl:for-each> (assuming you want the field element names)

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" encoding="iso-8859-1" ?>

<xsl:stylesheet version="1.0" 

    xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 

    xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" 

    xmlns:ns1="http://www.starstandards.org/STAR" 

    xmlns:ns2="http://www.openapplications.org/oagis" 

    xmlns:n1="http://www.approsystems.com/CUDL/ProcessCreditDecision">
 
    <xsl:template match="/" >

        <html>

            <head>

                <title>test xml</title>

            </head>

            <body>

                <div>

                    <xsl:for-each select="//ns1:Detail/*">

                        <xsl:value-of select="local-name(.)"/>

                    </xsl:for-each>

                </div>

            </body>

        </html>

    </xsl:template>
 
</xsl:stylesheet>

regards

Oct 25 '08 #6

by: bdinmstig | last post by:

I refined my attempt a little further, and the following code does seem to work, however it has 2 major problems: 1. Very limited support for XPath features Basic paths are supported for...

Java

regex xpath expressions

by: Timo Nentwig | last post by:

Hi! Seems that * cannot stand for non-existing nodes, i.e. /html/*/title will not match <html> <title>won't match</title>

.NET Framework

Can xsl throw an exception when value-of xpath does not exist?

by: inquirydog | last post by:

Hi- One frusterating thing for me with xsl is that I don't know how to make xslt throw some sort of exception when a value-of path does not exist. For instance, suppose I have the following...

.NET Framework

upper-casing parts of xpath

by: Johannes Koch | last post by:

Hi there, I'd like to apply an xpath to both HTML and XHTML documents. First I create a DOM document with a Java DOM parser, then apply the xpath with Xalan's XPathAPI class. The problem is that...

.NET Framework

Possible Bug: ArgumentOutOfRangeException when using xsl:sort and xsl:strip-space has been declared

by: Mark Miller | last post by:

I have a scheduled job that uses different XSL templates to transform XML and save it to disk. I am having problems with the code below. The problem shows up on both my development machine (Windows...

.NET Framework

XPath and namespace problem

by: Andreas Håkansson | last post by:

I have a price of XML that looks like this <Root> <SomeNode> ..... </SomeNode> <Signature xmlns="http://www.w3.org/2000/09/xmldsig#"> ... </Signature> </Root>

.NET Framework

What does a "//" mean in an xpath expressin?

by: eric.goforth | last post by:

In an xsl stylesheet, I have <xsl:when test="string-length(//mystuff) > 0"> <xsl:attribute name="someattribute">blahblahblah</xsl:attribute> </xsl:when> In the xml that mystuff is several...

.NET Framework

Using XPath Against A Node

by: Derek Hart | last post by:

I bring in an xml file into vb.net by using xmlDoc.LoadXml(XMLString) - I run xpath statements against the xml file to grab data from it, so I use, as an example, //Vehicles/Vehicles/@make to get...

Visual Basic .NET

XPath generation question

by: =?Utf-8?B?RGF2aWQgVGhpZWxlbg==?= | last post by:

Hi; We have a TreeView that represents an xml file (or it's schema is a more accurate statement). We want to have a double click on a node in the tree generate the XPath to get to that node. ...

.NET Framework

XPath Validation using xsd Schema

by: syed.akhlaq | last post by:

Hi, Does anyone know how can I validate XPath expressions using xsd schema? Thanks

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Using XPath with non-standard XML

Similar topics