title: Search JSON returned from API by value in Python
body: <p>I'm accessing an API using Python 2.7.12 which gives a JSON response. The JSON looks something like this:</p>
  
  <pre><code>{
      "Header": {
          "GeneratedAt": "2016-07-31T13:42:33", 
          "PeriodA": {
              "startDate": "20160718", 
              "type": "WEEKLY", 
              "endDate": "20160724"
          }
      }, 
      "Data": [
          {
              "Metrics": [
                  {
                      "name": "Sales", 
                      "values": {
                          "A": "823456.32", 
                          "B": ""
                      }, 
                      "id": "TL_TOTAL_SALES"
                  },
                  {
                      "name": "Orders",
                      "values": {
                          "A": "1230",
                          "B": ""
                      },
                      "id": "TL_TOTAL_ORDERS"
                  },
              ], 
              "label": "Commerce Metrics"
          },
       ]
  } 
  </code></pre>
  
  <p>I'm parsing the JSON as a string using Python and then I need to search the JSON string and extract the values of a particular metric, so in this case I want the values of the metric "Sales".</p>
  
  <p>My code so far:</p>
  
  <pre><code>import json, requests
  
  url = "https://something.com/blah-blah-blah/"
  r = requests.get(url)
  data = json.loads(r.text)
  print json.dumps(data, indent=4)
  </code></pre>
  
  <p>What I want to go on to do is store the value "A" from "Sales" in a variable called totalSales but need to know the best practices on querying and extracting individual data values from a JSON response like this, this is a very stripped down version of what actually gets returned from the API.</p>