Json Array with twriteJsonField

[TRandy]

hello I would like to build an array of objects using the twritejsonFields as above.

but when I define the list type as my transaction field type and run the job.

I get an error that states <<cannot convert from string to list>> .

Please, can you help me

[TRandy]

Hello @Aiming Chen​ 

@Xiaodi Shi​ 

@Shicong Hong​ 

Let's suppose that my tWriteJsonField produces a json array of type string of this structure for example :

data: "[{

"Amount: 2000,

"startDate": "R-1100",

"endDate":

"startDate":

"notes" : {

    "name" : "evans",

   "middleName" : "",

   "lastName" : "Hans"

   },

"id" : [ {

     "0" : "E-123",

    "1" : "E-124"

     }],

"CA" : { 

  "id" : "1234-452-567"

 }

}]

"

I would have to define a routine in the structure you have written for each field in my data output ???

and as I have made several jobs with even more complex structures than the ones I used as an example, I should also do this ???.

[TRandy]

Hi @Aiming Chen​ 

it works but .....

the result is not what is desired

..... 

@Shicong Hong​ 

[TRandy]

Hi @Aiming Chen​ 

[Anonymous]

Hello,

Here is a reply from your another topic:

https://community.talend.com/s/feed/0D55b000086q8ysCAA

Could you please take a look at it?

Best regards

Sabrina