Hi, I am getting below resultset from stored procedure in logic apps from Execute stored procedure V2. I want to transform it to JSON format.
{
"ResultSets": {
"Table1": [
{
"Number": "546546547",
"Fname": "Mick",
"Sname": "Tait",
"Test": "Only"
}
],
"Table2": [
{
"PID": 9797879,
"Randomdate": " 2020/1989",
"Random2": "TTTTT",
"Random": "Y7686786",
"EngineName": "V3",
"Vehicle": "Car",
"Emisssion": "BS4",
"Group": "test",
"Route": "ZigZag",
},
{
"PID": 6576556,
"Randomdate": " 2020/1988",
"Random2": "YYYYY",
"Random": "Z343544",
"EngineName": "V4",
"Vehicle": "Truck",
"Emisssion": "BS3",
"Group": "test2",
"Route": "Straight",
},
{
"PID": 465465465,
"Randomdate": " 2020/1987",
"Random2": "ZZZZZZ",
"Random": "R75747",
"EngineName": "V1",
"Vehicle": "SUV",
"Emisssion": "BS2",
"Group": "test3",
"Route": "Straight",
}
]
},
"ReturnCode": 0,
"OutputParameters": {}
}
Below is the Desired JSON format:
{
"NumberDetails": {
"Number": "string",
"Fname": "string",
"Sname": "string",
"FullName": "string",
"RandomDetails": {
"Random2": "string",
"Random": false,
"Products": {
"PID": "string",
"EngineName": "string",
"Vehicle": 0,
"Emisssion": 0,
"Group": "string",
"Route": "string"
}
}
}
}