How to handle dynamic json content in azure logic app

[MM77777]

I have a JSON input with varying properties Example 1 -

{
"test1": {
"A" : {
Value : "1"
},
"B" : {
Value : "2"
}

}
}

Example 2 -
{
"test2": {
"C" : {
Value : "3"
}
}


I need to store these in SQL database in Name and Value columns as Name Value A 1 B 2 C 3`

The JSON could have different type of parent attributes like test1/Test2/test3. And, I need to store these in name value pairs. How do I achieve this in logic app?

Continue reading...