How to build JSON using tWriteJSONField component

himanshup — Tue, 15 Oct 2024 15:48:24 GMT

Hello,

I have build a JSON string using tWriteJSONField.

with resulting JSON as:
{
"PrimaryAddress": "1",
"AddressID": "E8BBEB79-7566-4731-BE57-E37F3A2593EA",
"Phone": "(705) 5551212",
"Email": "test_Knock@john.net"
}

However, since I am new to this, I am not sure how to build the following (example) JSON using tWriteJSONField:

{

"Appointments": [

{

"AppointmentBands": [

{

"AppointmentBandID": "E91E4849-5617-4C9C-BCB0-96F72EA169F4",

"Amount": 120.40,

"EffectiveDate": "2024-07-02T00:00:00",

"EndDate": "2025-06-30T00:00:00",

"AppointmentTypeCodeID": "P_MONTH_TYPE_5",

"FringeBenefitAmount": null,

"FringeBenefitSchemeID": null,

"PrimaryAppointment": "Y",

"Unique_ID": "D8FF7B12-71A2-476F-B",

"AppointmentID": "D55E54E3-FF72-4ACA-86A9-7F784076CC78"

}

"AppointmentID": "D55E54E3-FF72-4ACA-86A9-7F784076CC78",

"CompensationPackageID": "0FB6ED82-65AC-4B98-BFB6-0E49BF2B1281",

"AssociatedOrgUnitCode": 14418,

"AppointmentTitle": "Data Analyst"

}

"CompensationPackageID": "0FB6ED82-65AC-4B98-BFB6-0E49BF2B1281",

"Unique_ID": "D8FF7B12-71A2-476F-B",

"StartDate": "2024-07-02T00:00:00",

"EndDate": "2025-06-30T00:00:00"

}

Any guidance will be highly appreciated.

Thank you.

Re: How to build JSON using tWriteJSONField component

Dave_Simo — Tue, 15 Oct 2024 20:32:54 GMT

Hello,

you can use this way to configure below component to build the json you want to get

https://help.qlik.com/talend/fr-FR/components/8.0/processing/configuring-a-json-tree

Best Regards,

topic Re: How to build JSON using tWriteJSONField component in Talend Studio

How to build JSON using tWriteJSONField component

Re: How to build JSON using tWriteJSONField component