Forum Discussion
Dynamically expanding all the columns containing lists/records received in a JSON response from APIs
I am new to Power Query and working on Power BI. There are multiple Web APIs that return a nested JSON response having multiple lists and records. I need to write a single generic code to dyn...
ImkeF
Community Champion
Community ChampionHi Arif1033 ,
instead of null you need to pass in the (reference to the) JSON that you want to analyze/expand.
I apologise i did not quite get it - am new to power query and API's - am using the below rest API - can you give me some examples of what refrence i should be using it