Forum Discussion
Using GetData on JSON file only gives two columns without data
Hello, I'm using Excel 2016. I tried to use the Data ribbon to Get Data\From File\From JSON and imported a file that looks like this: { "categories": [ { "name": "Cheap & Cool Gadgets"...
Hi Tony,
JSON connector doesn't do all transformations for you, you need to add them manually. See, for example, this conversation https://techcommunity.microsoft.com/t5/Get-and-Transform-Data/parse-two-level-JSON-data/m-p/186947#M683
Hi, have you tried to analysed your json? you can use this tool to do that. https://jsonformatter.org
Jimmi, Power Query is enough for me