gistfile1.txt

def algo(env)
    data_raw = open('http://spreadsheets.google.com/tq?key=0AsTunpthKrMxdEp5R1loYjBBcVhNQWVEc1BUZmZ1QUE&pub=1')
    data = data_raw.read
    
    data = data.split('(')[1].split(")")[0]
    data = data.gsub("'", '"')
    data = data.gsub(/([a-z]+):/, '"\1":')
    result = JSON.parse(data)
    

    puts "\n\n\n"
    puts "\n\n\n"

    puts"\n\n\n\n"
    puts result["table"]["rows"][0]["c"].inspect
    puts "\n\n\nchao"    

    
   [200, {"Content-Type" => "text/plain"}, "alohaaa"]
  end