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

[Anonymous]

As a test, could you please setup the column 'transactions' Type to 'String' in tWriteJSONField output schema?

[TRandy]

Hi @Aiming Chen​ , thanks for your feeldback

by filling in as type string it works.

But it doesn't solve my problem as the transaction field must be of type Array/List

[Anonymous]

You can add another component tJavaRow to read the json fields and convert it to type Array/List after the tWriteJSONField component

[TRandy]

@Aiming Chen​ 

How can i do that ??

Is there a precise code to write ??

[Anonymous]

Maybe you can do it like:

1. create a routine code JsonUtil -> add routine libraries to add json-lib jar and add one method to convert the json string to List as the below
2. in the tJavaRow component, invoke the routine code method to get the List of the input json string as the output_row column(List type) like

[TRandy]

Hi @Aiming Chen​ 

thanks for your feeldback.

I have this error

[Anonymous]

@Tim Randy​  could you please right click on the routine JsonUtil ->Edit Routine Libraries -> make sure you select the json-lib-2.4.6-talend.jar?

[TRandy]

OK Thank you @Aiming Chen​ 

I have just imported this librairy

Here is the error I get the following

It seems to be related to the Student routine .....

[Anonymous]

@Tim Randy​  did you setup the property 'Amount' in the routines.Student?

the properties in the routines.Student should be the same as that in the json string, here is an example in my side: