?json=URL parameter for loading JSON data

[simonw]

Support both a JSON file that's a list of objects and a JSON file which is an object but where one of the keys is a list of objects (pick the key with the most objects in it).

[simonw]

Documentation: https://github.com/simonw/datasette-lite/tree/bea40570fdb76a65327182d80f192236c2ee4f26#loading-json-data

Demo: https://lite.datasette.io/?json=https://github.com/simonw/scrape-san-mateo-fire-dispatch/blob/main/incidents.json#/data/incidents

[simonw]

This first implementation only handles [{...}, {...}] documents - I've not yet implemented the idea where {"items": [{...}]} could work too.

[simonw]

I'm just going to implement it such that it searches for the first key of the dictionary that's a list with at least one object in it.

[simonw]

Got it working such that if the data has NO lists of objects in it you get this error:

For this example: https://github.com/simonw/datasette/blob/main/package.json

But if the data DOES have a list of objects it works - e.g. for https://github.com/simonw/usgs-scraper/blob/main/usgs.json

[simonw]

Updated documentation: https://github.com/simonw/datasette-lite/blob/dba4f20e2261d2838a1e3896ca8a7bc9eb9f83a7/README.md#loading-json-data