I've been trying to get a readable database of a JSON file from a URL.
I've used fastfedora's script on Github, https://github.com/fastfedora/google-docs/blob/master/scripts/ImportJSON/Code.gs, to import JSON from the URL to Sheets. I'm using the basic:
If the data is structured and every object will always have the same structure you can use a simple offset to do this:
=OFFSET($B$2, (ROW($B2) - 2) * 7 + COLUMN(D$1) - 4, 0)
Put that in D2 and drag to the right and down. It is possible to immediately return the data in this fashion but for that you need to meddle with the script.