[resolved] Missing values when using tWriteJsonField

Aukema — Mon, 12 Dec 2016 10:24:31 GMT

Hi,

I want to create the following JSON file:
{
"level1": {
"level2": [{
"level3": {
"newColumn2": "level3value"
},
"newColumn1": "level2value"
}],
"newColumn": "level1value"
}
}
(note the array I use for level2)

I am using tWriteJsonField to achieve this.

Job overview:

I am using a simple sample configuration to simplify some things.

Finally I created three levels in my output JSON string and added a class attribute in order to achieve the array on the second level

But when running this job, some information is lost and I cannot find a solution to prevent this. The final result looks like this:
{
"level1": {
"level2": [{
"newColumn2": "level3value"
}, "level2value"],
"newColumn": "level1value"
}
}

The array is there, but the Level3 header is lost.

Is there any solution for this?

Re: [resolved] Missing values when using tWriteJsonField

Aukema — Mon, 12 Dec 2016 12:08:27 GMT

I figured out that you don't only need a array class, but also a element set as loop value. For the example I the OP it should look like this:

topic Re: [resolved] Missing values when using tWriteJsonField in Talend Studio

[resolved] Missing values when using tWriteJsonField

Re: [resolved] Missing values when using tWriteJsonField