Transform to json format
Please help to transform below input json to mentioned output format.
Noteworthy: Input JSON start as an object and there is another object 2 within it. Output JSON expectation is to merge into 1 object.
Input JSON:
[
{
“Key 1” : “12345”,
“Key 2” : “6789”,
“Key 3” : “abc-123”
},
[
{
“object 2” : " "
},
{
“Key 4” : “00002”,
“Key 5” : “N/A”,
“Key 6” : “Success”
},
{
“Key 7” : “00001”,
“Key 8” : “Column Datatype check failed”,
“Key 9” : “Fail”
},
{
“Key 10” : “00003”,
“Key 11” : “Sheet Validation check failed”,
“Key 12” : “Fail”
}
]
]
Output JSON:
{ “Key 1”:“12345” ,
“Key 2”: “6789”,
“Key 3”: “abc-123”,
"object 1": [
{
"Key 4": "00002",
"Key 5" : "N/A",
"Key 6": "Success"
},
{
"Key 7": "00001",
"Key 8" : "Column Datatype check failed",
"Key 9": "Fail"
},
{
"Key 10": "00003",
"Key 11" : "Sheet Validation check failed",
"Key 12": "Fail"
}
]}