I have ReportList which contains the Name text property and AddressList property.

I am getting the data in the clipboard:

ReportList(1)

    Name:ABC

    AddressList

        AddressList(1).Number: 1

        AddressList(2).Number: 2

        AddressList(3).Number: 3        

ReportList(2)

    Name:DEF

    AddressList

        AddressList(1).Number: 4

        AddressList(2).Number: 5

I Have to map the above clipboard mapping to the JSON structure format through data transform (FYI, we are not using JSON data transforms).

My Json expected mapping is below format:

Reports

{

"reportingName": "ABC" ,

"reportingAddress": {1,2,3}

}

{

"reportingName": "DEF" ,

"reportingAddress": {4,5}

}

Note: reportingAddress is a value list Array

**Can you please suggest what logic can be used to achieve the above JSON.