Expected JSON:
{
"BACSDocument": {
"xsi:noNamespaceSchemaLocation": "newbacs-advices.xsd",
"Data": {
"ARUDD": {
"Header": {
"reportType": "Racv",
"adviceNumber": 989,
"currentProcessingDate": "2022-09-02"
},
"AddresseeInformation": {
"name": "XYZ"
},
"ServiceLicenseInformation": {
"userName": "XYZ",
"userNumber": 954328
},
"Advice": {
"OriginatingAccountRecords": {
"OriginatingAccountRecord": [
{
"OriginatingAccount": {
"name": ABC UK ",
"number": 12345
"sortCode": "40-63-84",
"type": 0,
"bankName": "ABC",
"branchName": "XYZ Branch"
},
"ReturnedDebitItem": [{
"ref": 100567651115023449,
"transCode": 07,
"returnCode": "0292",
"returnDescription": "REFER TO PAYER",
"originalProcessingDate": "2022-08-30",
"valueOf": "701.29",
"currency": "abc",
"PayerAccount": {
"number": "95489213",
"ref": 100567651115023449,
"name": "WOOD ",
"sortCode": "08-71-99",
"bankName": "Abc LIMITED",
"branchName": "Abc Limited"
}
},
"Totals": {
"numberOf": 1,
"valueOf": "701.29",
"currency": "xyz"
}
},
}
]
}
] }
}
}
}}
XML need to convert into jSON:
<PayerAccount number="53985520" ref="100133840005020122" name="" sortCode="20-10-03" bankName="abc" branchName="xyz"/>
</ReturnedDebitItem><OriginatingAccountRecord>
How to get array structure for OriginatingAccountRecord when it comes with single element or in list form and same for returndebitItem. How to get single element in array using XSLT. how to convert XML to JSON using XSLTto get proper valid json.