title: How to get a value from a JSON in Python?
body: <p>I want to get the value of timestamp and value from the following JSON</p>
  
  <pre><code>[{'name': 'temperature', 'resolution': 900, 'location': 'Takahuhdin koulu', 'room-id': '1', 'data': {'timestamp': '2018-09-05T07:59:03.429Z', 'value': 21.400000000000002}}]
  </code></pre>
  
  <p>After json.loads I got this JSON. How can I assign a variable of the value of timestamp and convert it to mysql yyyy-mm-dd HH:MM:SS format </p>
  
  <p>I tried </p>
  
  <pre><code>dataJSON = json.loads(result) // dataJSON have the JSON
  dataJSON['data']['timestamp']
  </code></pre>