Hi Team,
I have a the following Json in one of the blob column of my table and would like to parse and source into table.
Sample Json: (It can be dynamic and nodes can be added at any parent)
{
"SampleDescription": " sample description Sample. ",
"SampleType": "Sample",
"SampleStrm": "Test",
"SampleMat": {
"Child (s)": {
"Info": 3,
"Context": 1
},
"Node (s)": {
"Detail": 3,
"Complex": 1
}
},
"Sample Voltage": [
"1000 MW/min (s)",
"3000 MW/min (s)"
]
}
Now I have to parse them and store them in the below format
Can someone please assist?