topic Re: Sending number to http and get response in Talend Studio

Sending number to http and get response

Karuetl — Wed, 02 May 2018 19:38:51 GMT

Need help

I have an url which is like below where xyz is the input value(there will multiple values from the db) to be passed for every number and output is in the form of xml

http://company.net/abc/getnumber/xyz

</numberinfo>

</getnumber>

I need to get output of col2 only and use it to filter out those not required

please help me what components i have to use it

Re: Sending number to http and get response

vboppudi — Wed, 02 May 2018 20:13:42 GMT

Hi,

Follow the below steps.

Read xyz values from source

Pass xyz and url to httpRequest component and get xml file.

Use tExtractXMLField component to respective required fields form xml

Use tFilterRow/tMap to filter unwanted records and load data to target.

Regards,

Re: Sending number to http and get response

Karuetl — Thu, 03 May 2018 14:27:47 GMT

Thanks

i have done steps you mentioned

source-->thttprequest (here for testing i checked the "write content to file" and was able to see xml file)

but i dont know how to configure the tExtractXML component

<?xml version="1.0" encoding="UTF-8"?>
<getABC>
<abcInfo>
<in>99999999999999</in>
<is>1111</is>
<cc>33</cc>
<cn>INDIA</cn>
<osi1>GB</osi1>
<osi2>GBR</osi2>
</abcInfo>
</getABC>

Re: Sending number to http and get response

vboppudi — Thu, 03 May 2018 15:11:25 GMT

Hi,

please try below :

Regards,

Re: Sending number to http and get response

Karuetl — Thu, 03 May 2018 15:42:24 GMT

Can I have your email please i cannot share screenshot via public

Re: Sending number to http and get response

vboppudi — Thu, 03 May 2018 15:54:49 GMT

Sent you message please check.

Regards,

Re: Sending number to http and get response

Karuetl — Thu, 03 May 2018 15:55:20 GMT

I am reading multiple rows from the source but it extracts only one row .. basically i need to get all those rows that matches the filter condition

Re: Sending number to http and get response

vboppudi — Thu, 03 May 2018 15:59:29 GMT

Why you are using tFlowtoiterate ?

Please try without this component.

Regards,