json

[richard]

I tested the json implementation in the beta. Following the example on your website (worldbank data) works fine. However, streaming data from

https://opendata.ecdc.europa.eu/covid19/casedistribution/json/

does not work, even though the data is already in the json format. No response when clicking “check response”.

Downloading the json file and using it “from disk” allows to read the data in the “definitions” block and see the data clicking “set converter…”, but it is not appended in the table. Thus, I can’t use the data.

I know it is just a beta feature at the moment, but maybe the info here helps to improve this interesting feature.

[dgteam]

Thanks for reporting!

This looks like a good use case for this functionality.  It is odd that the check response it not showing anything.  We will see what’s going on.

[dgteam]

The latest Beta should work with this JSON call.  I tested it out and here is file using only the JSON call and plotting the data.

It would be great if you could try it out again and see if it works now.

For anyone interested, the JSON call allows you to have the data refreshed every time you open the file, or click the refresh button on the object.  The data is not saved in the file at all.

If you want a saved version of the data, you will need to make a copy (For example, use Edit/Copy as Text) to have the data itself saved in the file.

This is only in the beta for now but anyone with a licenses can download and use the beta version.

[richard]

It works like a charm! Thank you.

Now I tried a different repository:

https://covidtracking.com/api/v1/states/daily.json

where the json file is nested (or more nested). The data received from the server gives an array of dictionaries and not a dictionary of arrays (as in case of ECDC data). This array of dictionaries or nested json file does not work. I guess the json object in dgraph needs an option to flatten a json table.

[dgteam]

Thanks again for testing this out!

That format is actually fine — in fact the program was correctly importing the data if you copy and pasted the JSON data.  We found the bug that was the problem in the group link and this has been corrected.

Download the latest beta to get this fix!

https://www.visualdatatools.com/DataGraph/Versions/Beta/