topic How create JSON Document of this format using tJSONDoc? in Talend Studio

How create JSON Document of this format using tJSONDoc?

Anonymous — Sat, 16 Nov 2024 06:11:53 GMT

I have a single row/record with few fields:

someFlag: boolean

fieldString1: String

fieldString2: String

fieldString3: String

and I need to create a json document formatted like this:

{
  "document" : [ {    
    "settings" : [ {
      "someFlag" : true
    }, {
      "fieldString2" : "someText"
    }, {
      "fieldString3" : "SomeMoreText"
    }],
    "fieldString1" : "3068@myemail.mydomain.com"    
  } ]
}

I am using tJSONDoc (tJSONDocOutput) by JLolling to create the rest of the document, but this section has proven to be too hard.

Ideas or suggestions very welcome.

Re: How create JSON Document of this format using tJSONDoc?

Anonymous — Mon, 01 Apr 2019 09:12:31 GMT

Hi,

I have a small doubt in your requirement here. The output data for String2 and String3 are in list at different level compared to boolean value and field1. So could you please advise how you are arranging them in input side in column fashion?

Could you please advise the reason for String 2 and String 3 at different level in JSON compared to String 1?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: How create JSON Document of this format using tJSONDoc?

Anonymous — Tue, 02 Apr 2019 02:10:26 GMT

Hi Nikhil,
This is our requirements. Data source is a single database table row, which needs to be arranged as a relatively complex json document as per external party requirements, problematic snippet of which I described in the OP.

Re: How create JSON Document of this format using tJSONDoc?

Anonymous — Tue, 02 Apr 2019 10:17:28 GMT

Hi,

Could you please try to create JSON conversion using the metadata area of JSON?

https://help.talend.com/reader/lqV2ftgSbYSEBU9Bwsd61w/hCTD2DEpip2q~4n1MxWEMg

If you are facing any issues, could you please share the component screen shots so that we will know the exact issue while doing the conversion?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: How create JSON Document of this format using tJSONDoc?

akumar2301 — Tue, 02 Apr 2019 10:53:52 GMT

try this

Output

{"document": [ {"setting":[

{"flag":"true"},

{"str1":"abc"},

{"str2":"def"}

"str3":"xxxxx@gmail.com"

}

]

}

Re: How create JSON Document of this format using tJSONDoc?

Anonymous — Wed, 03 Apr 2019 01:47:58 GMT

Thanks Abhishek and Nikhil,
However, using Talend delivered JSON components is not an option as our current solution uses those and it doesn't meet all requirements (in particular, empty fields do not get suppressed, which breaks everything), hence Talend Customer Solutions suggested trying this component from JLolling.