Join & Store trestclient response to database

[Anonymous]

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

[manodwhb]

@Rathimittha,you can do in the below way.

[Anonymous]

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 

[manodwhb]

@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?

[Anonymous]

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

[manodwhb]

@Rathimittha,please use in the below way.

[Anonymous]

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

[manodwhb]

@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.

[Anonymous]

THanks Manohar

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