Forum Discussion

skodali's avatar
skodali
New Contributor III
6 years ago
Solved

Transform JSON Data

Hello All,

I’m trying to transform the JSON data but not able to achieve it. Please find the below JSON data and the expected output.
Can anyone suggest how can I achieve this?
[
{
“BillAmt”: 32.50,
“DocumentNumber”: 33395496,
“Permalink”: “Test-company”,
“NSID”: “1865041”,
“OpportunityID”: “006C000000g0uNB”,
“BillStatus”: [
“paidInFull”,
“NotpaidInFull”
],
“ApplyingTransAmount”: [
“-82.5”,
“-32.5”
],
“ApplyingTransDocNum”: [
“1200093-2462019-11341”,
“US_3d11e440 UCP_141”
],
“ApplyingTransType”: [
“_vendorPayment”,
“_vendorCredit”
]
},
{
“BillAmt”: 50.00,
“DocumentNumber”: 33396586,
“Permalink”: “Chase”,
“NSID”: “1865043”,
“OpportunityID”: “006C000000g0uNB”,
“BillStatus”: [
“paidInFull”,
“Fail”,
“partiallypaid”
],
“ApplyingTransAmount”: [
“-82.5”,
“-20.0”,
“-62.5”
],
“ApplyingTransDocNum”: [
“1200093-2462019-11341”,
“US_3d11e440 UCP_140”,
“US_3d11e440 UCP_139”
],
“ApplyingTransType”: [
“_vendorPayment”,
“_vendorCredit”,
“_vendorCredit”
]
}
]

Thanks