topic Re: Json Array with twriteJsonField in Data Quality

Json Array with twriteJsonField

TRandy — Fri, 15 Nov 2024 22:21:50 GMT

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

Re: Json Array with twriteJsonField

Anonymous — Tue, 15 Nov 2022 00:53:13 GMT

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

Re: Json Array with twriteJsonField

TRandy — Tue, 15 Nov 2022 07:47:02 GMT

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

Re: Json Array with twriteJsonField

Anonymous — Wed, 16 Nov 2022 02:09:53 GMT

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

Re: Json Array with twriteJsonField

TRandy — Wed, 16 Nov 2022 07:59:29 GMT

@Aiming Chen

How can i do that ??

Is there a precise code to write ??

Re: Json Array with twriteJsonField

Anonymous — Wed, 16 Nov 2022 09:38:39 GMT

Maybe you can do it like:

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
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

Re: Json Array with twriteJsonField

TRandy — Fri, 18 Nov 2022 10:13:00 GMT

Hi @Aiming Chen

thanks for your feeldback.

I have this error

Re: Json Array with twriteJsonField

Anonymous — Mon, 21 Nov 2022 01:30:43 GMT

@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?

Re: Json Array with twriteJsonField

TRandy — Mon, 21 Nov 2022 07:56:30 GMT

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 .....

Re: Json Array with twriteJsonField

Anonymous — Wed, 23 Nov 2022 01:36:53 GMT

@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:

Re: Json Array with twriteJsonField

TRandy — Fri, 25 Nov 2022 08:10:34 GMT

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 ???.

Re: Json Array with twriteJsonField

TRandy — Fri, 25 Nov 2022 11:30:16 GMT

Hi @Aiming Chen

it works but .....

the result is not what is desired

.....

@Shicong Hong

Re: Json Array with twriteJsonField

TRandy — Wed, 30 Nov 2022 14:27:12 GMT

Hi @Aiming Chen

Re: Json Array with twriteJsonField

Anonymous — Thu, 01 Dec 2022 04:43:30 GMT

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