Dynamically Flatten JSON Data Where Data is nested in Body
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?
Hi @Whiteford, Alder (Boston) ,
Welcome to Microsoft Q&A forum and thanks for reaching out here.
To better assist on this query, could you please help provide us with a sample/dummy JSON file (please change the file extension from .json to .txt to attach here) which fits your requirement?
Also please confirm if your requirement is to pass the
Unroll rootvalues using
Add dynamic contentfeature?
Just to confirm, your unroll by and unroll root always would be same but your input columns would differ and you want to make it dynamic based on some parameters or lookup?
Hello @Whiteford, Alder (Boston) ,
We still have not heard back from you. Just wanted to check if you still need assistance in this query. If so, could you please clarify on the above comments? In case if you have already found a solution, would you please share it here with the community as it will be helpful for others reading this thread.
Sign in to comment