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

[Loko]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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

Lachmiter

[Loko]

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