How can I extract a single value from a nested data structure (such as from parsing JSON)?

by

For reference, let’s see what the original JSON would look like, with pretty formatting:

>>> print(json.dumps(my_json, indent=4))
{
    "name": "ns1:timeSeriesResponseType",
    "declaredType": "org.cuahsi.waterml.TimeSeriesResponseType",
    "scope": "javax.xml.bind.JAXBElement$GlobalScope",
    "value": {
        "queryInfo": {
            "creationTime": 1349724919000,
            "queryURL": "http://waterservices.usgs.gov/nwis/iv/",
            "criteria": {
                "locationParam": "[ALL:103232434]",
                "variableParam": "[00060, 00065]"
            },
            "note": [
                {
                    "value": "[ALL:103232434]",
                    "title": "filter:sites"
                },
                {
                    "value": "[mode=LATEST, modifiedSince=null]",
                    "title": "filter:timeRange"
                },
                {
                    "value": "sdas01",
                    "title": "server"
                }
            ]
        }
    },
    "nil": false,
    "globalScope": true,
    "typeSubstituted": false
}

That lets us see the structure of the data more clearly.

In the specific case, first we want to look at the corresponding value under the 'value' key in our parsed data. That is another dict; we can access the value of its 'queryInfo' key in the same way, and similarly the 'creationTime' from there.

To get the desired value, we simply put those accesses one after another:

my_json['value']['queryInfo']['creationTime'] # 1349724919000

More Related Contents:

  1. How can I extract a single value from a JSON response?
  2. How to make JSON flattening memory efficient?
  3. Convert Json File to data Frame
  4. How do I sort a list of dictionaries by a value of the dictionary?
  5. How to return a dict as a JSON response from a Flask view?
  6. How to get POSTed JSON in Flask?
  7. How to parse data in JSON format?
  8. Saving utf-8 texts with json.dumps as UTF8, not as \u escape sequence
  9. What’s the best way to parse a JSON response from the requests library?
  10. How do I automatically fix an invalid JSON string?
  11. Django JSONField inside ArrayField
  12. How to flatten a pandas dataframe with some columns as json?
  13. Difference between data and json parameters in python requests package
  14. Deserialize a json string to an object in python
  15. pandas groupby to nested json
  16. TypeError: the JSON object must be str, not ‘bytes’
  17. JSON serialize a dictionary with tuples as key
  18. pandas read_json: “If using all scalar values, you must pass an index”
  19. How can I loop over entries in JSON?
  20. How convert a jpeg image into json file in Google machine learning
  21. Pyspark: Parse a column of json strings
  22. FastAPI is very slow in returning a large amount of JSON data
  23. JSON object must be str, bytes or bytearray, not dict
  24. Python urllib2: Receive JSON response from url
  25. How to append to a JSON file in Python?
  26. List of objects to JSON with Python
  27. Adding counters deletes keys
  28. How can I serialize a numpy array while preserving matrix dimensions?
  29. How to sort a list of dictionaries by a value of the dictionary in Python?
  30. urllib2 and json

Leave a Comment