Json Array with twriteJsonField

TRandy · ‎2022-11-14

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 · ‎2022-11-25

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 · ‎2022-11-25

Hi @Aiming Chen

it works but .....

the result is not what is desired

.....

@Shicong Hong

TRandy · ‎2022-11-30

Hi @Aiming Chen

Anonymous · ‎2022-11-30

Hello,

Here is a reply from your another topic:

Could you please take a look at it?

Best regards

Sabrina