topic Re: Merging data getting from different api calls in Talend Studio

Merging data getting from different api calls

sbhadra — Sat, 16 Nov 2024 03:21:14 GMT

Hi Team,

I have an api mentioned below

https://api.xyz.com/1111/details.json (where 1111 is the id and being iterated) which is giving me three columns after extracting the data using textractjsonfields. In the same flow I am calling another api like https://api.xyz.com/1111/comments.json which after parsing is giving me one column. Hence, I need to merge all this columns into an CSV file and then email it.

As part of the solution I have used a treplicate component so that i can replicate the previously generated columns and merge it into a tMap but that is not happening. Please suggest a way for the same. Please have a look on the flow

Re: Merging data getting from different api calls

Anonymous — Wed, 05 Feb 2020 13:12:06 GMT

Read the data from your first API call into a tHashOuput. Do the same with your second API call (a different tHashOutput). Then use two tHashInput components to join the data using a tMap.

Re: Merging data getting from different api calls

sbhadra — Thu, 06 Feb 2020 06:09:02 GMT

Hi,

I am unable to understand. Will you be able to show me the flow. I have already shared the job flow

Re: Merging data getting from different api calls

sbhadra — Thu, 06 Feb 2020 09:32:19 GMT

Hi Team,

I tried to separate the two flows and cache the data using thashoutput but still I am unable to figure out why the data from two different api calls are not getting merged. please have a look on the screen shot.

Re: Merging data getting from different api calls

Anonymous — Thu, 06 Feb 2020 09:45:52 GMT

Use onSubjobOK instead of onComponentOK,
tRestClient1...tHashOutput1
|onsubjobok
tRestClient2...tHashOutput2
|onsubjobok
tHashInput.....

Re: Merging data getting from different api calls

sbhadra — Thu, 06 Feb 2020 10:14:40 GMT

Hi Shong,

The requirement is I need to combine 4 columns in one csv file. Out of which three columns are coming from one response. The data is getting referenced from tJavaRow_1 and the last one is coming from another response which is getting referenced from tjavarow_2. Now the csv file should be like this mentioned below

RollNo|Name|Age|Educational Qualification

10|Ajit|24|B.Tech

Now from this the 1st three columns are coming from 1st API call and the last one is coming from 2nd API call. I have divided the flow into two sections but still I am unable to merge the result. I am uploading my job design. Please suggest on the same.

It will be helpful if you can provide a screen shot of the resolution

Capture.JPG