Six Stars

Sending number to http and get response

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 

1 ACCEPTED SOLUTION

Accepted Solutions
Nine Stars

Re: Sending number to http and get response

Hi,

 

please try below :

xmlDerive1.PNGxmlDerive2.PNG

Regards,

Veeru Boppudi
7 REPLIES
Nine Stars

Re: Sending number to http and get response

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,

Veeru Boppudi
Six Stars

Re: Sending number to http and get response

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>

 

 

Nine Stars

Re: Sending number to http and get response

Hi,

 

please try below :

xmlDerive1.PNGxmlDerive2.PNG

Regards,

Veeru Boppudi
Six Stars

Re: Sending number to http and get response

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

Nine Stars

Re: Sending number to http and get response

Sent you message please check.

 

Regards,

Veeru Boppudi
Six Stars

Re: Sending number to http and get response

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 

 

1.PNG

Nine Stars

Re: Sending number to http and get response

Why you are using tFlowtoiterate ? 

Please try without this component.

 

Regards,

Veeru Boppudi