Read XML file with attributes

[Anonymous]

Hi, 

i have to map a xml-file, my problem is that this file contain attributes. Thie file look like this:

 <DeliveryItem>
<LineNo> 40.00</LineNo>
<PartId>
<IdentNo Domain="ET-NUMMER">961860800</IdentNo>
<IdentNo Domain="LIEFERANTENARTIKEL">4102-230V.O.61</IdentNo>
<IdentNo Domain="EAN">7611386037073</IdentNo>
</PartId>

How can i extract the values for ET-NUMMER, LIEFERANTENARTIKEL,EAN ? 

Second problem in the second line in the XML make reference to the .dtd file:

<!DOCTYPE BDD SYSTEM "ABB BDD.dtd">

But when i leave this line in i get no rows from talend.

Thanks for help

[sushantk19]

I didnt understand completely. Are you saying XML Field value should not be "Body"?? I just have Error_code as another option in drop down; Also the ouput generated in .csv file is coming as NULL with just two headers.

[philippert]

Doesn't it work with :
Loop : /gesmes/Cube/Cube
Mapping :
- currency : @currency
- rate : @rate

[vapukov]

sorry, I'm use tRESTClient,

in tRESTClient default output schema:

- statuscode

- body

- string

btw, I miss leading / in my answer

it works with "/gesmes:Envelope/Cube/Cube/Cube"

[philippert]

In fact, it work with the loop as /gesmes:Envelope/Cube/Cube

[sushantk19]

yes, It is working fine now. Excellent!

Thanks a lot for your help!

[vapukov]

strange, must not work

the simplest way - if work with XML/JSON - use the proper tools for them, it helps a lot to debug: