AnsweredAssumed Answered

Xpath 1.0 or 2.0 in "Get input from XML"?

Question asked by Rolf Kleef on May 3, 2018
Latest reply on Jun 8, 2018 by Rolf Kleef

I'm trying to work with the "Get data from XML" step, specifically with the Xpaths to select data:

 

My data is roughly in the form:

 

<activity default-currency="EUR">
  <value currency="USD">10000</value>
  <value>10000</value>
</activity>

 

I am doing a loop over activity/value.

In Xpath, I can use the expression

 

(@currency, ../@default-currency)[1]

 

to get either the currency attribute if it exists, or the default-currency attribute of the parent, otherwise. (And then use the string value of it.)

It seems Kettle is able to do some types of Xpath expressions, but not sequences like this?

I can't find which version of Xpath is supported, it seems like Xpath 1.0? Is there a way to upgrade it to Xpath 2.0?

Outcomes