How to read this json link?

[petercreateParticipant]

Hi,

When I tried to read updated Covid-19 data with a json link, I can’t get correct columns’ title.

Here is the link. Would you please have a try?

https://services1.arcgis.com/vHnIGBHHqDR6y0CR/arcgis/rest/services/COVID19_Time_Series/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json

[dgteamModerator]

Because the JSON format can be setup very differently, it will not work for all cases.  What is happening with this link is that it is importing the section of the data with the most entries per dictionary.

A couple of things that might help …

Notice here that options beyond the ? in the query statement can be entered as individual criteria.  This can be helpful for limiting the data you are trying to get.

Click the gear menu to the check response to see what part of the data is being imported.

If you have particular data you are trying to extract and a format that you were expecting that would be helpful to know.

 

 

[petercreateParticipant]

Thanks. I tried the same thing as you showed. But I don’t understand the syntax in .json file, e.g., where 1=1, OutFields *, … Could you please show me more knowledge on that, please?

[dgteamModerator]

The URL you sent is encoded to remove certain characters in the query statement that are not allowed (such as the ‘=’) to be passed using a URL.

(More on encoding: https://en.wikipedia.org/wiki/Percent-encoding)

We ‘decoded’ the URL using https://www.urldecoder.org.

The part underlined in blue is what we entered.  The part underlines in red is decoded to see the query statement more clearly.

This syntax of 1=1 and * is a way to return everything.

If you have the API documentation for this site that might provide more detail on what the options are for the query statements.

 

[Author]

Posts