Google Spreadsheet Script for manipulating JSON

The following URL "http://shanghai.anjuke.com/ajax/pricetrend/comm?cid=10052", has the JSON data:

Now to fetch this data in Google Spreadsheet, use the following script:

/////////////////////////////////////////////////

function extract(url){

  var response = UrlFetchApp.fetch(url);

  var data = JSON.parse(response.getContentText());

  var comm = data.comm;

  

  var keyVal = function(o) {

    var key = Object.keys(o)[0];

    return [parseInt(key),parseInt(o[key])];

  } ;

  

  var result = new Array();

  var count=0;

  for (i in comm){

    result[count] = new Array();

    result[count] = keyVal(comm[count]);

    count++;

  }

  return result;

};

/////////////////////////////////////////////////

save the above script code in the script editor of your Spreadsheet and then you can call the custom function "extract" directly from your spreadsheet.

Have a look at the following screenshot:

I have the URL in cell A1, and the following formula in cell B1:
=transpose(extract(A1))