AnsweredAssumed Answered

Map DB Profile to Nested JSON Profile

Question asked by boomi1281704 on Aug 30, 2018
Latest reply on Aug 31, 2018 by leif_jacobsen

Hi Team,

 

Please suggest how to map the DB profile to nested JSON profile

 

DB Data:

 

DBSTART|15c7a48d-5330-4c8f-86e3-6628cfa8c444|2|@|BEGIN|2|@|OUT_START|3|@|24284|^|none@none.com|^|1|^|ab|^|12|^|1|^|24006.82|#|24284|^|none@none.com|^|2|^|cd|^|12|^|2|^|24006.82|#|24284|^|none@none.com|^|1|^|xx|^|13|^|1|^|24006|#|24284|^|none@none.com|^|2|^|yy|^|13|^|2|^|24006|#||#|OUT_END|3|@|END|2|@|DBEND|15c7a48d-5330-4c8f-86e3-6628cfa8c444|2|@|

 

 

Output Profile should look like below:

 

{
"contactEmailAddress":"none@none.com",
"clientID":"24284",
"quotesDetails":[
{
"quoteID":"12",
"vehicleCostExcel":"24006.82",
"accessories":[
{
"name":"ab",
"source":"1",
"costExcl":"1"
},
{
"name":"cd",
"source":"2",
"costExcl":"2"
}
]
},
{
"quoteID":"13",
"vehicleCostExcel":"24006",
"accessories":[
{
"name":"xx",
"source":"1",
"costExcl":"1"
},
{
"name":"yy",
"source":"2",
"costExcl":"2"
}
]
}
]
}

Outcomes