Sending number to http and get response

[Karuetl]

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

<getnumber>

     <numberinfo>

                  <col1>      </col1>

                  <col2>     </col2>

     </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 

[vboppudi]

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,

[Karuetl]

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>

[vboppudi · Accepted solution]

Hi,

please try below :

Regards,

[Karuetl]

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

[vboppudi]

Sent you message please check.

Regards,

[Karuetl]

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 

[vboppudi]

Why you are using tFlowtoiterate ? 

Please try without this component.

Regards,