topic Problem with XPath query (pick value based on attribute in multi element) in Talend Studio

Problem with XPath query (pick value based on attribute in multi element)

Anonymous — Thu, 17 May 2018 09:23:55 GMT

Hi All;

I'm facing problem with XPath query in tFileInputXML, when I'm using query with element number defined:

/Tracks/SegmentTrack[1]/Value

It is working but when I use conditional:

/Tracks/SegmentTrack[Value/@type='magnetic']/Value

It returns null, I've tried with \" instead of ', but still same result. I've tested query online and it is working correctly, site used:

https://www.freeformatter.com/xpath-tester.html#ad-output

Am I doing something wrong or this kind of queries are not supported?

If not supported, do you have any suggestion without heavy string parsing?

All suggestions really appreciated.

Thank you very much

BR/Artur

Re: Problem with XPath query (pick value based on attribute in multi element)

manodwhb — Thu, 17 May 2018 09:52:45 GMT

@GnuS,try with below one should reslove.

"/Tracks/SegmentTrack[Value/@type='magnetic']"

Re: Problem with XPath query (pick value based on attribute in multi element)

Anonymous — Thu, 17 May 2018 10:00:31 GMT

Hi;

@manodwhb It is same, NULL, besides the fact that I need Value not whole element.

BR/Artur

Re: Problem with XPath query (pick value based on attribute in multi element)

manodwhb — Thu, 17 May 2018 12:28:16 GMT

@GnuS,check the txmlinput settings,since i was able to get wth below.

Re: Problem with XPath query (pick value based on attribute in multi element)

Anonymous — Thu, 17 May 2018 13:04:48 GMT

Hi;

I have to dig a bit more but you are correct it is working (real XML is bigger and cannot share it).

Thank you very much for your time and help.

BR/Artur

Re: Problem with XPath query (pick value based on attribute in multi element)

Anonymous — Fri, 18 May 2018 08:25:46 GMT

Hi All;

I hope it will be helpful for somebody, I've found the reason of my problem, XML which I'm parsing is actually double loop (example was a cut), my loop is on LEVEL_A because I want to have records per it, and searching on SegmentTrack will not work, it will simply pickup first one, that's it and will not iterate through others to find needed record. What is confusing is that online parsers does work on second loop searches. Below XML with representation of my XML.

<LEVEL_As>

<LEVEL_A seq=1>

</LEVEL_A>

<LEVEL_A seq=2>

</LEVEL_A>

...

<LEVEL_A seq=N>

</LEVEL_A>

</LEVEL_As>

Re: Problem with XPath query (pick value based on attribute in multi element)

Ashwin_Ramdass_007 — Wed, 17 Aug 2022 03:45:55 GMT

Hello Sir,

I am new to XML and I can't actually, I also got the same error(Xpath query lost).

I am attaching the XML file in this message.