问题陈述:我们面临着处理复杂对象数组的任务，其中每个对象都包含嵌套子对象.我们的目标是解开这种 struct 并创建一个新的数组，该数组由这些嵌套 struct 中的单个元素组成.这种转换对于简化数据处理和实现更有效的数据分析和操作是必要的.
Input.json
{
"link": [],
"record": 1,
"pageSize": 10,
"matchedEntities": [
{
"busEntity": {
"ContactView": {
"idObject": "6940205 ",
"ApplicationId": "CNT01",
"clnsdNm": "Jhon cena",
"certifiedContact": {
"id": "2",
"CertifiedContactDesc": "Uncertified"
},
"PtPostalAdd": {
"item": [
{
"id": "3149850 ",
"label": " Postal Address",
"mainAddrCd": {
"id": "3 ",
"label": "Lookup Postal Address Type",
"addrTypDesc": "Primary",
"addrTyp": "P"
},
"mdmOpsAddrInd": {
"rowidObject": "2",
"label": "Lookup Postal Address Type",
"addrTypDesc": "Not Appliacble",
"addrTyp": "N"
},
"PostalAddress_rowidObject": "3209850",
"PostalAddress": {
"rowidObject": "237",
"srcAddrln1": "BERNARDELLI",
"srcCity": "PORTO",
"srcState": "RJ",
"srcPstlCd": "5600re",
"srcCountryCd": {
"rowidObject": "32 ",
"label": "Lookup Source Country",
"cntryCd": "BR",
"cntryDesc": "Brazil"
},
"addrLn1": "2000 RUA FERNANDO BERNARDELLI",
"city": "PORTO REAL",
"state": "RJ",
"pstlCd": "27570000",
"countryCd": {
"cntryDesc": "Brazil",
"cntryCd": "BR"
}
}
},
{
"id": "43",
"label": " Postal Address 2",
"mainAddrCd": {
"id": "3 ",
"label": "Lookup Postal Address Type",
"addrTypDesc": "Primary",
"addrTyp": "P"
},
"mdmOpsAddrInd": {
"addrTypDesc": "Not Appliacble",
"addrTyp": "N"
},
"PostalAddress_id": "23",
"PostalAddress": {
"srcAddrln1": "test",
"srcCity": "test",
"srcState": "test",
"srcPstlCd": "5600re",
"srcCountryCd": {
"rowidObject": "32 ",
"label": "Lookup Source Country",
"cntryCd": "BR",
"cntryDesc": "Brazil"
},
"addrLn1": "2000 RUA FERNANDO BERNARDELLI",
"city": "PORTO REAL",
"state": "RJ",
"pstlCd": "27570000",
"countryCd": {
"cntryDesc": "Brazil",
"cntryCd": "BR"
}
}
}
]
}
}
},
"matchRule": "MRS Contact Search Match|1",
"matchScore": "100"
},
{
"busEntity": {
"ContactView": {
"id": "6940205 ",
"ApplicationId": "CNT02",
"clnsdNm": "Alexis Vieira",
"certifiedContact": {
"CertifiedContactDesc": "Uncertified"
},
"PtPostalAdd": {
"item": [
{
"id": "3149850 ",
"label": " Postal Address",
"mainAddrCd": {
"id": "3 ",
"label": "Lookup Postal Address Type",
"addrTypDesc": "Primary",
"addrTyp": "P"
},
"mdmOpsAddrInd": {
"addrTypDesc": "Not Appliacble",
"addrTyp": "N"
},
"PostalAddress_rowidObject": "3209850",
"PostalAddress": {
"srcAddrln1": "BERNARDELLI",
"srcCity": "PORTO",
"srcState": "RJ",
"srcPstlCd": "5600re",
"srcCountryCd": {
"rowidObject": "32 ",
"label": "Lookup Source Country",
"cntryCd": "BR",
"cntryDesc": "Brazil"
},
"addrLn1": "2000 RUA FERNANDO BERNARDELLI",
"city": "PORTO REAL",
"state": "RJ",
"pstlCd": "27570000",
"countryCd": {
"cntryDesc": "Brazil",
"cntryCd": "BR"
}
}
}
]
}
}
}
}
],
"facet": []
}
100
{
"partyContact" : {
"cntId" : [ "CNT01", "CNT02" ],
"cntName" : [ "Jhon cena", "Alexis Vieira" ],
"certifiedContact" : [ "Uncertified", "Uncertified" ]
},
"postalAddress" : [ {
"mainAddrCd" : [ "Primary", "Primary" ],
"addressType" : [ "Not Appliacble", "Not Appliacble" ],
"srcAddrLn1" : [ "BERNARDELLI", "BERNARDELLI" ],
"srcCity" : [ "PORTO", "PORTO" ],
"srcState" : [ "RJ", "RJ" ],
"srcPstlCd" : [ "5600re", "5600re" ],
"addressLine1" : [ "2000 RUA FERNANDO BERNARDELLI", "2000 RUA FERNANDO BERNARDELLI" ],
"city" : [ "PORTO REAL", "PORTO REAL" ],
"state" : [ "RJ", "RJ" ],
"postal_Code" : [ "27570000", "27570000" ],
"srcCountryCd" : [ "BR", "BR" ]
}, {
"mainAddrCd" : "Primary",
"addressType" : "Not Appliacble",
"srcAddrLn1" : "test",
"srcCity" : "test",
"srcState" : "test",
"srcPstlCd" : "5600re",
"addressLine1" : "2000 RUA FERNANDO BERNARDELLI",
"city" : "PORTO REAL",
"state" : "RJ",
"postal_Code" : "27570000",
"srcCountryCd" : "BR"
} ]
}
100
[
{
"operation": "shift",
"spec": {
"matchedEntities": {
"*": {
"busEntity": {
"ContactView": {
"ApplicationId": "partyContact.cntId",
"clnsdNm": "partyContact.cntName",
"certifiedContact": {
"CertifiedContactDesc": "partyContact.certifiedContact"
},
"PartyAlternateId": {
"item": {
"*": {
"altIdType": {
"idTyp": {
"0002": {
"@(3,altIdVal)": "partyContact.partyUid"
},
"0008": {
"@(3,altIdVal)": "partyContact.metalPortalUserId"
},
"0011": {
"@(3,altIdVal)": "partyContact.ecpPortalUserId"
}
}
}
}
}
},
"PtPostalAdd": {
"item": {
"*": {
"mainAddrCd": {
"addrTypDesc": "postalAddress[&2].mainAddrCd"
},
"mdmOpsAddrInd": {
"addrTypDesc": "postalAddress[&2].addressType"
},
"PostalAddress": {
"srcAddrln1": "postalAddress[&2].srcAddrLn1",
"srcAddrln2": "postalAddress[&2].srcAddrLn2",
"srcAddrln3": "postalAddress[&2].srcAddrLn3",
"SrcAddrln4": "postalAddress[&2].srcAddrLn4",
"srcCity": "postalAddress[&2].srcCity",
"srcState": "postalAddress[&2].srcState",
"srcPstlCd": "postalAddress[&2].srcPstlCd",
"srcSystem": "postalAddress[&2][&2].srcSystem",
"srcDoNotStd": "postalAddress[&2].srcDoNotStd",
"addrId": "postalAddress[&2].addressId",
"addrLn1": "postalAddress[&2].addressLine1",
"addrLn2": "postalAddress[&2].addressLine2",
"addrLn3": "postalAddress[&2].addressLine3",
"addrLn4": "postalAddress[&2].adddressLine4",
"city": "postalAddress[&2].city",
"county": "postalAddress[&2].county",
"state": "postalAddress[&2].state",
"pstlCd": "postalAddress[&2].postal_Code",
"countryCd": {
"cntryCd": "postalAddress[&3].srcCountryCd"
},
"vldtnStsCd": "postalAddress[&2].validation_Status_Code",
"enrchdInd": "postalAddress[&2].enrichedIndicator"
}
}
}
}
}
}
}
}
}
}
]
100
[
{
"partyContact": {
"cntId": "CNT01",
"cntName": "Alexis Vieira",
"certifiedContact": "Uncertified",
"partyUid": "980",
"postalAddress": [
{
"mainAddrCd": "Primary",
"addressType": "Not Appliacble",
"srcAddrLn1": "test",
"srcCity": "test",
"srcState": "test",
"srcPstlCd": "5600re",
"addressLine1": "2000 RUA FERNANDO BERNARDELLI",
"city": "PORTO REAL",
"state": "RJ",
"postal_Code": "27570000",
"srcCountryCd": "BR"
},
{
"mainAddrCd": "Primary",
"addressType": "Not Appliacble",
"srcAddrLn1": "test",
"srcCity": "test",
"srcState": "test",
"srcPstlCd": "5600re",
"addressLine1": "2000 RUA FERNANDO BERNARDELLI",
"city": "PORTO REAL",
"state": "RJ",
"postal_Code": "27570000",
"srcCountryCd": "BR"
}
]
}
},
{
"partyContact": {
"cntId": "CNT02",
"cntName": "Alexis Vieira",
"certifiedContact": "Uncertified",
"partyUid": "980",
"postalAddress": [
{
"mainAddrCd": "Primary",
"addressType": "Not Appliacble",
"srcAddrLn1": "test",
"srcCity": "test",
"srcState": "test",
"srcPstlCd": "5600re",
"addressLine1": "2000 RUA FERNANDO BERNARDELLI",
"city": "PORTO REAL",
"state": "RJ",
"postal_Code": "27570000",
"srcCountryCd": "BR"
}
]
}
}
]