how to extract value from tsoap

hiba1 — Sat, 16 Nov 2024 05:05:59 GMT

Hi ,

i want to extract "countryCode" from tsoap and load it into sql server .

i try with this job but i got the value null in the sql table .

Any help please !

Re: how to extract value from tsoap

Anonymous — Wed, 31 Jul 2019 23:25:10 GMT

You are looking at this the wrong way I think. The tSoap component will return XML. You need to know the format of the return message before you think about this. Remove all components (deactivate them, don't delete them) and add a tLogRow directly after the tSoap component. This will print the XML to the output window. Show us what is returned and we can help you extract it.

Re: how to extract value from tsoap

hiba1 — Thu, 01 Aug 2019 11:47:09 GMT

Hi ,

in fact I have already extracted all the data of xml returned by tsoap and I insert them into the table sql .... as you notice I have a dynamic variable in the message soap "countryCode" ... this variable will be recovering with each iteration of the coup I can have all the xml in the response of tsoap (in short the xml are cities each identified by the countryCode) what I want is to insert these countryCode with its cities. I can not do this join.

exemple: whene the "countrycode" = A

the xml be like this :

<?xml version="1.0" encoding="UTF-8"?>
<envelope>
<header>
<version port="4002" host="ns001tow.netstorming.net">1.6.1</version>
<timestamp>20190731102936</timestamp>
</header>
<response type="cities" product="hotel">
<cities timestamp="20030423170100">
<city>
<code value="GRZ"/>
<city_tax value="true"/>
<names>
<name language="ru" value="GRAZ"/>
<name language="fr" value="GRAZ"/>
<name language="en" value="GRAZ"/>
<name language="hr" value="GRAZ"/>
<name language="ca" value="GRAZ"/>
<name language="de" value="GRAZ"/>
<name language="it" value="GRAZ"/>
<name language="pt-br" value="GRAZ"/>
<name language="sl" value="GRAZ"/>
<name language="es" value="GRAZ"/>
</names>
</city>
<city>
<code value="TLLN"/>
<city_tax value="false"/>
<names>
<name language="ru" value="TULLN AN DER DONAU"/>
<name language="fr" value="TULLN AN DER DONAU"/>
<name language="en" value="TULLN AN DER DONAU"/>
<name language="zh" value="TULLN AN DER DONAU"/>
<name language="hr" value="TULLN AN DER DONAU"/>
<name language="ca" value="TULLN AN DER DONAU"/>
<name language="de" value="TULLN AN DER DONAU"/>
<name language="it" value="TULLN AN DER DONAU"/>
<name language="pt-br" value="TULLN AN DER DONAU"/>
<name language="es" value="TULLN AN DER DONAU"/>
<name language="sl" value="TULLN AN DER DONAU"/>
<name language="ja" value="TULLN AN DER DONAU"/>
<name language="pl" value="TULLN AN DER DONAU"/>
</names>
</city>
<city>
<code value="VIE"/>
<city_tax value="true"/>
<names>
<name language="ru" value="ВЕНА"/>
<name language="fr" value="VIENNE"/>
<name language="en" value="VIENNA"/>
<name language="nl" value="VIENNA"/>
<name language="hr" value="BEC"/>
<name language="ca" value="VIENA"/>
<name language="de" value="WIEN"/>
<name language="it" value="VIENNA"/>
<name language="pt-br" value="VIENNA"/>
<name language="sl" value="DUNAJ"/>
<name language="es" value="VIENA"/>
</names>
</city>
</cities>
</response>
</envelope>

Re: how to extract value from tsoap

Anonymous — Thu, 01 Aug 2019 18:37:49 GMT

Oh, sorry I misunderstood. All you need to do then is to add a tMap after your tSoap. This will be used to pass through your XML data and to add an extra column for the country code. Just set the globalMap expression you showed in your first post, in the extra output column.

Re: how to extract value from tsoap

hiba1 — Fri, 02 Aug 2019 10:09:40 GMT

Hello,

Thanks, your solution worked

topic Re: how to extract value from tsoap in Talend Studio

how to extract value from tsoap

Re: how to extract value from tsoap

Re: how to extract value from tsoap

Re: how to extract value from tsoap

Re: how to extract value from tsoap