Accessing Json data (I think I am nearly there) complete beginner

[Andrew Edwards-Adams]

On Thursday, May 23, 2013 5:40:49 PM UTC+1, Andrew Berg wrote:
> On 2013.05.23 11:09, Andrew Edwards-Adams wrote:
> 
> > I was recommended to use the following code to access the Json data directly, however I cannot get it to return anything.
> 
> Where exactly is the problem? Do you not get JSON back? Do you get the wrong values? Do you get a KeyError or IndexError trying to get
> 
> values from text1? Are there gremlins going around flipping bits in memory? It's good that you posted code, but "really cant get anything
> 
> out of this" isn't very useful.
> 
> -- 
> 
> CPython 3.3.2 | Windows NT 6.2.9200 / FreeBSD 9.1

Hi thanks for the reply Andrew, my first bit of code was heading in the right direction I was managing to pull out the usernames from the JSON, using REGEX. I was told that the second piece of code is the more efficient way to pull data from the JSON. When I say it doesnt do anything I can adjust the areas suggested. But it returns nothing, I just get the "= Restart =" line appear in the python shell. If there was a trackback/debug I might know where to look, but its not yielding errors, its simply yielding nothing. What i dont know, is if it is the code that isnt working, or what I am inputting in the " print text1['rows'][0]['id']" that isnt working.


Since this code: 

import mechanize
import urllib
import json
def getData():  
    post_url = "http://www.tweetnaps.co.uk/leaderboards/leaderboard_json/current_week"
    browser = mechanize.Browser()
    browser.set_handle_robots(False)
    browser.addheaders = [('User-agent', 'Firefox')]
 
    #These are the parameters you've got from checking with the aforementioned tools
    parameters = {'page' : '1',
                  'rp' : '50',
                  'sortname' : 'total_pl',
                  'sortorder' : 'desc'
                 }
    #Encode the parameters
    data = urllib.urlencode(parameters)
    trans_array = browser.open(post_url,data).read().decode('UTF-8')

 appears in both examples and my first attempt is definitely returning data from the JSON, I can only assume that the error is in the last two lines of his code, or as stated my imputing incorrect parameters.

:S