How to extract a single value from JSON response?

by

using json.loads will turn your data into a python dictionary.

Dictionaries values are accessed using ['key']

resp_str = {
  "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
}

would translate into a python diction

resp_dict = json.loads(resp_str)

resp_dict['name'] # "ns1:timeSeriesResponseType"

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

More Related Contents:

  1. Convert Json File to data Frame
  2. How to return a dict as a JSON response from a Flask view?
  3. How to get POSTed JSON in Flask?
  4. How to parse data in JSON format?
  5. Saving utf-8 texts with json.dumps as UTF8, not as \u escape sequence
  6. How to serialize SqlAlchemy result to JSON?
  7. NumPy array is not JSON serializable
  8. Converting XML to JSON using Python?
  9. Where’s my JSON data in my incoming Django request?
  10. String to Dictionary in Python [duplicate]
  11. How can I extract a single value from a JSON response?
  12. is not JSON serializable
  13. How to load all entries in an infinite scroll at once to parse the HTML in python
  14. How to normalize json correctly by Python Pandas
  15. How to remove whitespaces and newlines from every value in a JSON file?
  16. How to json_normalize a column with NaNs
  17. How can I loop over entries in JSON?
  18. JSON dumps custom formatting
  19. How can I parse (read) and use JSON?
  20. JSON object must be str, bytes or bytearray, not dict
  21. How to append to a JSON file in Python?
  22. OpenAI GPT-3 API error: “Cannot specify both model and engine”
  23. List of objects to JSON with Python
  24. What is the difference between json.dumps and json.load? [closed]
  25. How to merge two json string in Python?
  26. json.decoder.JSONDecodeError: Extra data: line 2 column 1 (char 190) [duplicate]
  27. Issue with merging multiple JSON files in Python
  28. How to Fix JSON Key Values without double-quotes?
  29. Handle JSON Decode Error when nothing returned
  30. Convert nested JSON to CSV file in Python

Leave a Comment