topic Re: Join & Store trestclient response to database in Talend Studio

Join & Store trestclient response to database

Anonymous — Tue, 22 May 2018 08:04:39 GMT

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

Re: Join & Store trestclient response to database

manodwhb — Tue, 22 May 2018 08:14:21 GMT

@Rathimittha,you can do in the below way.

Re: Join & Store trestclient response to database

Anonymous — Tue, 22 May 2018 08:23:58 GMT

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

Re: Join & Store trestclient response to database

manodwhb — Tue, 22 May 2018 08:26:33 GMT

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

Re: Join & Store trestclient response to database

Anonymous — Tue, 22 May 2018 08:32:16 GMT

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

Re: Join & Store trestclient response to database

manodwhb — Tue, 22 May 2018 08:35:34 GMT

@Rathimittha,please use in the below way.

Re: Join & Store trestclient response to database

Anonymous — Tue, 22 May 2018 08:48:57 GMT

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

Re: Join & Store trestclient response to database

manodwhb — Tue, 22 May 2018 08:53:39 GMT

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

Re: Join & Store trestclient response to database

Anonymous — Tue, 22 May 2018 09:06:34 GMT

THanks Manohar

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