topic Re: tWriteJson field output not working in Talend Studio

tWriteJson field output not working

root — Thu, 31 Aug 2017 14:13:31 GMT

I have some input data which I need to get converted to a json object. I am half-way there, but, cannot pin-point what to do to get it fully working. Any help is appreciated.

Original OP:

abc;pqr;123
def;ghj;876

Expected JSON Object:

{
   "test_op":[
      {
         "lname":"abc",
         "fname":"pqr",
         "score":"123"
      },
      {
         "lname":"def",
         "fname":"ghj",
         "score":"876"
      }
   ]
}

Re: tWriteJson field output not working

root — Tue, 05 Sep 2017 13:27:30 GMT

Shameless bump. I am unable to find a way to get the expected JSON output using tWriteJsonField. Any suggestion on how to mark an item as "Group"? Any other alternatives to creating a json object?

Thanks.

Re: tWriteJson field output not working

Anonymous — Wed, 06 Sep 2017 04:51:14 GMT

Hello,

Sorry for delay.

We will check your attachment test_json.zip file and then come back to you as soon as we can.

Thanks for your time.

Best regards

Sabrina

Re: tWriteJson field output not working

fab_74 — Wed, 06 Sep 2017 08:16:41 GMT

hi,

what is your expected JSON output? (Structure).

Have an input and output example?

Re: tWriteJson field output not working

fab_74 — Wed, 06 Sep 2017 08:58:35 GMT

hello,

can you look that corresponds to your expectation?(example3)

twritejsonfile.zip

Re: tWriteJson field output not working

root — Wed, 06 Sep 2017 20:47:43 GMT

Thank you so much. Example 3 worked for me. I am still baffled on why we need that "field1" value to be included in the grouping option (input and output). Other than that, it worked flawlessly. Thank you so much.