How to extract a single value from JSON response

Question

First off  I will freely concede to being little more than a clumsy liberal arts guy who is completely self taught in this scripting thing  That said  I am attempting to get values from a the USGS Water Data Service using the code below   def main gaugeId          import modules     import urllib2  json        create string     url    http   waterservices usgs gov nwis iv  format json amp sites     gaugeId     amp parameterCd 00060 00065         open connection to url     urlFile   urllib2 urlopen url         load into local JSON list     jsonList   json load urlFile         extract and return       how to get cfs  ft  and zulu time      return  cfs  ft  time    Although I have found some tutorials regarding how to extract the desired values from a JSON response  most are fairly simple  The difficulty I am having is extracting from what looks like a very complicated response this service is returning  Looking through the response  I can see what I want is the value from two different sections and a time value  Hence  I can look at the response and see what I need  I just cannot  for the life of me  figure out how to get these values extracted

User · Accepted Answer

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

User · Answer

Only suggestion is to access your resp dict via  get   for a more graceful approach that will degrade well if the data isn t as expected   resp dict   json loads resp str  resp dict get  name     will return None if  name  doesn t exist   You could also add some logic to test for the key if you want as well   if  name  in resp dict      resp dict  name   else        do something else here

User · Answer

Extract single value from JSON response Python  Try this  import json import sys   load the data into an element data   test1     1    test2     2    test3     3     dumps the json object into an element json str   json dumps data    load the json to a string resp   json loads json str    print the resp print  resp    extract an element in the response print  resp  test1

[python] How to extract a single value from JSON response?

Examples related to python

Examples related to json