How to build JSON using tWriteJSONField component

[himanshup]

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.

[Dave_Simo]

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,