Join & Store trestclient response to database

Five Stars

Join & Store trestclient response to database

Hi,

 

I am using a trestclient to get the output from a service. Now, the XML returned looks this way, 200 |<?xml version="1.0" encoding="UTF-8"?>
<root><status>1</status><data>110.0</data></root>|null |

 

I want to join the  value in the <data> field with the 2 more fields (user id and captured data) that comes from a database. How do I achieve this? I want to store the userid, captured date and <data> in the database

 

Any help on this please

 

Thanks

Rathi

Thirteen Stars

Re: Join & Store trestclient response to database

@Rathimittha,you can do in the below way.

Untitled.pngUntitled.png

Manohar B
Five Stars

Re: Join & Store trestclient response to database

Hi, thank you for the quick response

 

My job looks like this . I want the out2 in tMap_1 to be a lookup too tXMLMap, but it does not allow me to link it 

 

p1.pngp2.png

Thirteen Stars

Re: Join & Store trestclient response to database

@Rathimittha,since you need to split the flow as i showned in my previous  replay.

 

Bytheway what are you giving input to tRestclient from tMap1?

Manohar B
Five Stars

Re: Join & Store trestclient response to database

I am using origin , destination and waypoints as inputs to trestclient

Thirteen Stars

Re: Join & Store trestclient response to database

@Rathimittha,please use in the below way.

Untitled.png

Manohar B
Five Stars

Re: Join & Store trestclient response to database

Hi Manohar,

 

I am my job, I need to get the output from the trestclient for a particular user and his date. Now , if I use 2 inputs then I will have no way to join them

 

That is th reason I have 2 outputs in my tMap, so that I can link userid, date and the trestresponse.

 

I will have many users and dates coming in and for each combination I must hit the trestclient

Thirteen Stars

Re: Join & Store trestclient response to database

@Rathimittha,sinc you cannot join the two outputs ,which are having same orgin.

 

You need to either  load to files/Hasoutput and read those files/hashInput and join them in another flow.

Manohar B
Five Stars

Re: Join & Store trestclient response to database

THanks Manohar

 

But I don't get it as how to link the fields?