topic [resolved] TXMLMap : how to loop on XML Content ? in Talend Studio

[resolved] TXMLMap : how to loop on XML Content ?

Loko — Sat, 16 Nov 2024 10:21:29 GMT

Hi

I have a tXMLMap that gets an Webservice response thru ESBConsumer. The WS is made with Talend and its reponse is :

<?xml version="1.0" encoding="UTF-8"?>
<tns:getChatsByNomResponse xmlns:tns=""><chats><chat id_chat=""><nom_chat>Garfield</nom_chat><age_chat>5</age_chat><pelage_chat>Tigré</pelage_chat></chat><chat id_chat=""><nom_chat>Tom</nom_chat><age_chat>3</age_chat><pelage_chat>Brun</pelage_chat></chat></chats></tns:getChatsByNomResponse>

Then , whatever the output I choose for tXMLMap (tLogRow, tFileOutPutExcel ...) I only get the first row of data. Here is my map

I also tried to output a document with a loop like this map

but in this case I just get the entire raw document as output, not parsed into columns.

What do I miss to loop on rows ?

Thank you
Loko

Re: [resolved] TXMLMap : how to loop on XML Content ?

Anonymous — Thu, 06 Oct 2016 02:08:40 GMT

Hi
What's the result you are getting now? Is tXMLMap2 a component in web service provider job or in the consumer job?

Regards
Shong

Re: [resolved] TXMLMap : how to loop on XML Content ?

Anonymous — Fri, 07 Oct 2016 14:19:08 GMT

Hi Loko,
The Loop must be in "chat" and not in "chats"

Lachmiter

Re: [resolved] TXMLMap : how to loop on XML Content ?

Loko — Mon, 10 Oct 2016 10:04:00 GMT

Hi

You're right Lachmiter, I didn't notice the loop was not on the right level. It's a bit surprising as this input schema was directly recovered from the Webservice WSDL.

Thanks for your help !
Loko