In my case, I have JSON object that contains table and it values in array. I am trying to extract each table object from JSON and insert it features(columns) array values into postgresql table based on table name. The json structure will change every time and it is dynamic.
Input:
{
{
"table": "Table1",
"key": "2343",
"features": [
{
"status": "Finished",
"id": "1234",
"kind": "Unknown",
"project_name": "XXXXXX"
}
]
}
{
"table": "Table2",
"key": "2667190",
"features": [
{
"column1": "test",
"column2": "A",
"status": "Unknown",
}
]
},
}
Expected output:
