topic Re: tWriteJsonField: create 1 JSON object with Array in Talend Studio

tWriteJsonField: create 1 JSON object with Array

JayQueue — Fri, 15 Nov 2024 21:50:56 GMT

Hello,

I want to create a JSON object like this:

{

"eboxType": "CITIZEN",

"eboxIdType": "SsinNumber",

"eboxIdValueList": [

"ddd",

"47040242545",

"60070753282",

]

}

But I only get them seperated

{

"eboxType": "CITIZEN",

"eboxIdType": "SsinNumber",

"eboxIdValueList": [

"ddd"

]

}

{

"eboxType": "CITIZEN",

"eboxIdType": "SsinNumber",

"eboxIdValueList": [

"47040242545"

]

}

Am I missing a parameter in tWriteJsonField or is not that simple?

TIA

-J

Re: tWriteJsonField: create 1 JSON object with Array

Anonymous — Thu, 04 May 2023 08:12:33 GMT

Take a look at this KB article, add an attribute '@class' to element eboxIdValueList and set the value as 'array'. Please try and let me know if it works.

Regards

Shong

Re: tWriteJsonField: create 1 JSON object with Array

JayQueue — Thu, 04 May 2023 08:52:04 GMT

Hello @Shicong Hong

I'm getting an error on your link.

I already tried with the '@class" Array but nothing

Then I found https://help.talend.com/r/en-US/8.0/processing/twritejsonfield-tmap-trowgenerator-trowgenerator-configuring-and-running-job-create

And then I got

{"eboxType":"CITITZEN","eboxIdType":"SsInNumber","eboxIdValueList":["ddd",["47040242545"],["60070753282"]]}

then I set rrnr as loop element I got the correct output!

Thanks for the help

Re: tWriteJsonField: create 1 JSON object with Array

Anonymous — Thu, 04 May 2023 12:47:12 GMT

yes, rrnr should be the loop element here. Thanks for your feedback!