How to read this json link?

Welcome to our Forums Technical Support Support Desk How to read this json link?

Tagged: 

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #4544
    petercreate
    Participant

      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

      #4549
      dgteam
      Moderator

        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.

         

        JSON-GIS01

         

        #4551
        petercreate
        Participant

          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?

          #4558
          dgteam
          Moderator

            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.

            JSON-DecodeSmall

            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.

             

          Viewing 4 posts - 1 through 4 (of 4 total)
          • You must be logged in to reply to this topic.

          Welcome to our Forums Technical Support Support Desk How to read this json link?