Hi , I have a nested indexed json that I want to flatten using Azure Data Flow, could you help me out with a plausible solution.

Question

Source Json coming from Azure Blob as an entry in a single column.
{
"1": {
"startDay": ["Monday", "Tuesday", "Wednesday", "Thursday"],
"startTime": "9:00AM",
"endTime": "10:00AM",
"appointmentType": "104",
"repeatFreq": "1",
"endBy": "infinite"
},
"2": {
"startDay": ["Monday", "Tuesday", "Wednesday", "Thursday"],
"startTime": "10:00AM",
"endTime": "11:00AM",
"appointmentType": "104",
"repeatFreq": "1",
"endBy": "infinite"
}
}

this needs to be flattened to :
{
"Column_ID":"1",
"startDay": ["Monday", "Tuesday", "Wednesday", "Thursday"],
"startTime": "9:00AM",
"endTime": "10:00AM",
"appointmentType": "104",
"repeatFreq": "1",
"endBy": "infinite"
}
{
"Column_ID":"2",
"startDay": ["Monday", "Tuesday", "Wednesday", "Thursday"],
"startTime": "10:00AM",
"endTime": "11:00AM",
"appointmentType": "104",
"repeatFreq": "1",
"endBy": "infinite"
}

Answer 1

Hi @Abheek Bhowmik , this has come up quite a few times here, please go through

below threads:

https://learn.microsoft.com/en-us/answers/questions/715216/index.html

https://learn.microsoft.com/en-us/answers/questions/813462/how-to-flatten-complex-nested-json-structure-in-ad.html

https://learn.microsoft.com/en-us/answers/questions/766985/dataflow-flatten-json-file-data.html

https://learn.microsoft.com/en-us/answers/questions/922174/flattening-nested-json-document-in-data-factory-da.html