Dynamically Flatten JSON Data Where Data is nested in Body

Whiteford, Alder (Boston) 6 Reputation points
2022-10-26T21:16:25.007+00:00

Current Endpoint JSON Projection:
My goal is to flatten the JSON source using the complex "data" array which you can see in the image above. Because the data inside of the "data" array can change, though, I am unable to use projections.

In an ideal world in which the schema does not drift, the subsequent flatten activity would use "[] body.data" for both the "unroll by" and "unroll root".

How can I mimic this flatten using dynamic content?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,933 questions
{count} vote