Dynamically Flatten JSON Data Where Data is nested in Body

Whiteford, Alder (Boston) 6

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?

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2022-10-31T02:00:16.2+00:00

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 by and Unroll root values using Add dynamic content feature?

Thank you
Nandan Hegde 29,886 Reputation points MVP

2022-10-31T07:40:58.237+00:00

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?
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2022-11-03T17:01:12.397+00:00

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.