topic Re: Combine multiple json objects into one before sending response in Talend Studio

Combine multiple json objects into one before sending response

root — Sat, 16 Nov 2024 10:14:31 GMT

My job has three different inputs (which I am reading from MSSQL). I am creating three separate json objects from them...
Like this:

In each of the tJavaRow, I am saving the created json objects in a context variable.
I want to create a "single" json object combining all three together. How can I achieve the same so I can send it back?
Thanks.

Re: Combine multiple json objects into one before sending response

vapukov — Mon, 21 Nov 2016 21:34:12 GMT

variant#1 - save it not to variables, but to csv files (without tJSONWrite), than read all 3 and make 1 JSON
variant#2 - concat 3 variables into result JSON string, this variant need more understanding of saved JSON formats - may be need cut-off leading and trailing {} and etc
variant#3 - use Java function - example1 example 2

Re: Combine multiple json objects into one before sending response

root — Mon, 21 Nov 2016 21:56:30 GMT

variant#1 - save it not to variables, but to csv files (without tJSONWrite), than read all 3 and make 1 JSON
variant#2 - concat 3 variables into result JSON string, this variant need more understanding of saved JSON formats - may be need cut-off leading and trailing {} and etc
variant#3 - use Java function - example1 example 2

I forgot to mention, I am actually using Variant#2 as a temporary workaround till I find a cleaner solution... I am not comfortable with manipulating the data... it could get messy in the longrun.
So for Variant#1, you are suggesting I write the json object to csv files? Then, how can I combine them to make a single json.
I will check Variant#3..
Thanks again.

Re: Combine multiple json objects into one before sending response

vapukov — Mon, 21 Nov 2016 23:37:05 GMT

variant#1 - may be wrong for JSON, need to test - it work with XML, but look like not work with JSON