Is it possible to load nested json into data lake using dataflow in ADF

Question

I am trying load a nested Json object into azure Data lake using Data flow

Nested JSON object will look like

[
{
"EmployeeID" : "1",
"EmployeeName" : "name",
"JobID" : "12",
"JobTitle" : "title",
"JobCreatedDate" : "20211201",
"CompanyID" : "234",
"CompanyName" : "cName",
"Shortlist" : {
"count" : 56,
"data" : [
{
"CandidateID" : "836597",
"CandidateSalesforceId": "0054J000002tmulQAA",
"CandidateName" : "John Smith",
"ActivityDate" : "20220101"
},
{
}, ...
]
},
"Cv Sent" : {
"count" : 3,
"data" : [
{
"CandidateID" : "836597",
"CandidateSalesforceId": "0054J000002tmulQAA",
"CandidateName" : "John Smith",
"ActivityDate" : "20220101"
},
{
}, ...
]
}
},
{
}, ...
]

inner objects data will be populated by left joining views

Answer 1

Hi @Anonymous , similar use-case has been discussed below:

https://learn.microsoft.com/en-us/answers/questions/479036/azure-data-flow-access-nested-json-data.html Thanks