topic JSON Attributes Insert Or Update in Talend Studio

JSON Attributes Insert Or Update

TJ1598223511 — Wed, 21 Sep 2022 21:19:48 GMT

I am writing data from RDBMS to Target DB, there is a column in Target which holds JSON attributes/objects, for the first time i am able to insert the data in below format, but how can how can i perform delta processing. For example if i want to update the Value of CUSTOMER_NAME, how this can be achieved using Talend ? I know there are JSON components but using tExtractJSONField, unable to extract this the correct data because of Name & Value. Is there any solution for this kind of delta processing ???

{

"attributeValue"

: [

{

"Name"

"CUSTOMER_ID"

"Value"

"12345"

{

"Name"

"CUSTOMER_NAME"

"Value"

"JACK"

}

]

}

Help is greatly appreciated....

Re: JSON Attributes Insert Or Update

TJ1598223511 — Thu, 22 Sep 2022 03:24:46 GMT

Can someone from Talend Professionals provide some solutioning....

Re: JSON Attributes Insert Or Update

Anonymous — Thu, 22 Sep 2022 08:55:01 GMT

Hello,

Here is a tWriteJSONField which can be used to generate an array format json output.

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

Re: JSON Attributes Insert Or Update

TJ1598223511 — Thu, 22 Sep 2022 15:20:54 GMT

@Xiaodi Shi, My question is i have the data in the above mentioned format in one of my Target fields, lets say my Target field is attribute_json which is holding the above mentioned JSON format. For this attribute_json field I have to perform UPDATE on existing json data, i cannot replace json data in attribute_json since this field is holding other teams data too, so only option i need to update the data. For suppose if i get an update on this JSON value alone {"Name":"CUSTOMER_NAME", "Value":"JACK"} like i need to update from JACK to RACK in Target how can we achieve this through Talend.

First thing i am unable to read the Name and Value data using tExtractJSONField component.

For me i feel like Talend can only do insert or update on relational data fields but not on JSON data fields, for json data I have I see only to use java code.

Hope this helps.

Thanks,

Thiru.