GetBodySection XPath not working

Replies to This Discussion

Permalink Reply by Mark Tucker on March 25, 2015 at 11:32am

Please provide more information about what you are trying to do. What version of Neuron ESB are you running? Is your XPath part of a Workflow, Business Process or custom code?

• ▶ Reply

Permalink Reply by David Cottle on March 27, 2015 at 12:12pm

I am doing this in a business process C# code block.

Each one of my services return a result in the form of:

 

<SomeServiceResponse>

    <SomeServiceResult>

        <actualResult>123456</actualResult>

...

 

 

I need to generically strip the first to parents from that XML and just return <actualResult> (I won't know what the parents names are).  Using the pattern I indicated in my forum question with GetBodySection doesn't work.  It gives me 123456.  What I need is <actualResult>123456</actualResult>

I am not sure why a namespace in the top level element would matter...the pattern above does not pull anything out by name...only by position.

Every other online XPath validator that I have tried gives me the expected result using the same starting message.

 

David

• ▶ Reply

Permalink Reply by John Petersen on March 28, 2015 at 9:10am

In that case, the following will work regardless of whether there is or isn't a namespace in the xml:

context.Data.SetProperty("ati","correlationId",context.Data.GetBodySection("/*/*/*/text()"));

I tested this with your posted XML  - with and without a namespace. See attached config. 

Attachments:

• xpathProcess.esb, 12 KB

• ▶ Reply

Permalink Reply by David Cottle on March 30, 2015 at 7:00am

John,

This is pretty close.  However I am not looking for a text value.  I am looking for the element and all of its children that fall below that "/*/*/*".  (This is not related to the correlation ID..we figured that together when you were onsite.  I am trying to extract other response information from an XML wrapper being returned from service calls)

So in the following XML:

<Parent>

   <Child>

      <GrandChild>

        <SomeData>data1</SomeData

        <SomeData2>data2</SomeData2>

      </GrandChild>

...

I am lookng for:

     <GrandChild>

        <SomeData>data1</SomeData

        <SomeData2>data2</SomeData2>

      </GrandChild>

Is there a way to extract this information using GetBodySection?  

If not, I can always use XElement and LinqToXML...

• ▶ Reply

Permalink Reply by John Petersen on March 27, 2015 at 12:06pm

If a namespace is involved in the returned XML, the pattern you posted will not work.  Assuming the name of the tag you are interested is called requestId and assuming it's the text within that tag you are interested, the following pattern will always work regardless of whether there is a namespace or not"

@"//*[local-name() = 'requestId']/text()";

• ▶ Reply