title: Extracting from a very complex JSON file in Python
body: <p>I'm trying to get some information out of a very complex JSON file with Python. Below is just one object from the file:</p>
  
  <pre><code>{
  "__metadata": {
  "uri": "/Students/news/_vti_bin/ListData.svc/Posts(4)", "etag": "W/\"2\"", "type": "Microsoft.SharePoint.DataService.PostsItem"
  }, "Title": "Term 2 Round 2 draws", "Body": "&lt;div class=\"ExternalClass0BC1BCA4D3EE45A4A1F34086034FE827\"&gt;&lt;p&gt;\u200bAs there is no Gonzagan this week the following Senior Sport information has been provided here.\r\n\t    &lt;/p&gt;\r\n&lt;ul&gt;&lt;li&gt;&lt;a target=\"_blank\" href=\"/Intranet/students/news_resources/2011/Term2/Knox _wet_weather.pdf\"&gt;Knox _wet_weather&lt;/a&gt; Cancellations, please see &lt;a target=\"_blank\" href=\"http://www.twitter.com/SACWetWeather\"&gt;twitter page&lt;/a&gt; for further news.&lt;/li&gt;\r\n&lt;li&gt;&lt;a target=\"_blank\" href=\"/Intranet/students/news_resources/2011/Term2/2011_Football_round_2.pdf\"&gt;2011 Football draw Round 2&lt;/a&gt;&lt;/li&gt;\r\n&lt;li&gt;&lt;a target=\"_blank\" href=\"/Intranet/students/news_resources/2011/Term2/2011_Rugby_round_2.pdf\"&gt;2011 Rugby draw Round 2&lt;/a&gt;&lt;/li&gt;&lt;/ul&gt;\r\n&lt;p&gt;&lt;/p&gt;&lt;/div&gt;", "Category": {
  "__deferred": {
  "uri": "/Students/news/_vti_bin/ListData.svc/Posts(4)/Category"
  }
  }, "Published": "\/Date(1308342960000)\/", "ContentTypeID": "0x0110001F9F7104FDD3054AAB40D8561196E09E", "ApproverComments": null, "Comments": {
  "__deferred": {
  "uri": "/_vti_bin/ListData.svc/Posts(4)/Comments"
  }
  }, "CommentsId": 0, "ApprovalStatus": "0", "Id": 4, "ContentType": "Post", "Modified": "\/Date(1309122092000)\/", "Created": "\/Date(1309120597000)\/", "CreatedBy": {
  "__deferred": {
  "uri": "/Students/news/_vti_bin/ListData.svc/Posts(4)/CreatedBy"
  }
  }, "CreatedById": 1, "ModifiedBy": {
  "__deferred": {
  "uri": "/Students/news/_vti_bin/ListData.svc/Posts(4)/ModifiedBy"
  }
  }, "ModifiedById": 1, "Owshiddenversion": 2, "Version": "1.0", "Path": "/Students/news/Lists/Posts"
  },
  </code></pre>
  
  <p>I can't wrap my head around editing this. Converting it to a python dictionary seems to jumble the order of the attributes up, making it impossible for me to find where one object starts and another begins. What's the best way for me to extract just the 'title', 'body' and 'published' keys and values, and how would I do it for multiple objects?</p>