By running the request below, you can get the data of the percentage of people aged over 65.

http://api.e-stat.go.jp/rest/2.0/app/getStatsData?appId=<application ID>&statsDataId=C0020050213000&cdCat01=%23A03503

// XML
http://api.e-stat.go.jp/rest/<version>/app/getStatsData?<parameters>

// JSON
http://api.e-stat.go.jp/rest/<version>/app/json/getStatsData?<parameters>

The example request above, which is the percentage of people aged over 65, gets XML.

Please refer the page below in regard to the data types of Obtain Statistical Data API.

e-Stat API specifications/2. How to use API/2.3. Obtain Statistical Data API

(in Japanese)

Data are exported text format such as XML or JSON.

The sample below is to get XML data by "simplexml_load_file" of PHP,

and to anylyse required data by XPath.

Refer to the page below in regard to the contents of response from Obtain Statistical Data API.

e-Stat API specifications/4. Data exported from API/4.4. Obtain Statistical Data API

(in Japanese)

// Obtain XML data
$xmlData =  simplexml_load_file( $GET_URL );

// Obtain result status from array
$apiResult = get_object_vars($xmlData->RESULT);
$apiStatus = $apiResult["STATUS"];
$apiErrMsg = $apiResult["ERROR_MSG"];

// Define variable
$aryGraph = array();

// Area（Prefecture code + "000"）
$areaCode = "13000";  // 13000 is the code of Tokyo

// Data acquisition succeeded
if ($apiStatus == "0") {
  // Obtain table name from meta info
  $statisticsNameList=$xmlData->xpath('/GET_STATS_DATA/STATISTICAL_DATA/TABLE_INF/STATISTICS_NAME');
  $statisticsName=$statisticsNameList[0];

  // Obtain prefecture name from meta info
  $areaNameList=$xmlData->xpath('/GET_STATS_DATA/STATISTICAL_DATA/CLASS_INF/CLASS_OBJ[@id="area"]/CLASS[@code="'.$areaCode.'"]/@name');
  $areaName=(string)$areaNameList[0];

  // Obtain classification from meta info
  $cat01List=$xmlData->xpath('/GET_STATS_DATA/STATISTICAL_DATA/CLASS_INF/CLASS_OBJ[@id="cat01"]/CLASS[@code="'.$cdCat01.'"]/@name');
  $cat01=$cat01List[0];

  // Obtain unit
  $UnitList=$xmlData->xpath('/GET_STATS_DATA/STATISTICAL_DATA/CLASS_INF/CLASS_OBJ[@id="cat01"]/CLASS[@code="'.$cdCat01.'"]/@unit');
  $Unit=$UnitList[0];

  // The array for storing horizontal axis of meta info
  $apiMetaYokoList = array();

  // Obtain horizontal axis from meta info
  foreach($xmlData->xpath('/GET_STATS_DATA/STATISTICAL_DATA/CLASS_INF/CLASS_OBJ[@id="time"]/CLASS') as $key1 => $val1) {
    // store
    $apiMetaYokoList[(string)$val1['code']] = (string)$val1['name'];
  }

  // Modify obtained data for displaying
  foreach ($xmlData->xpath('/GET_STATS_DATA/STATISTICAL_DATA/DATA_INF/VALUE') as $key2 => $val2) {
  // Loop with data

    // Loop with obtained horizontal axis
    foreach ($apiMetaYokoList as $yokoKey => $yokoVal) {

      if ((($cdCat01!=""&&(string)$val2['cat01']==$cdCat01)||$cdCat01=="") &&    // Classification 01
        (string)$val2['area'] == $areaCode &&                                    // Prefectures
        (string)$val2['time'] == $yokoKey                                        // horizontal axis
      ) {
        //
        $name = $apiMetaYokoList[$yokoKey];

        // Convert obtained value to number
        $value = (float)$val2;

        // Store data for graph in the array
        $aryGraph[] = array(  "name"  => $name
                            , "value" => $value
        );
      }
    }
  }
}

The sample below is to analyse the data obtained by getJSON of Javascript(JQuery).

$.getJSON(url, function(jsonData){})
.success(function(jsonData) {
  var statusCode = jsonData['GET_STATS_DATA']['RESULT']['STATUS'];

  // Extract numerical information of statistical data
  // Extract data from json data by filter of Javascript
  var valueData = jsonData['GET_STATS_DATA']['STATISTICAL_DATA']['DATA_INF']['VALUE'].filter(function(item, index){
    return true;
  });

  // Obtain horizontal axis from meta info
  var apiMetaYokoList = jsonData['GET_STATS_DATA']['STATISTICAL_DATA']['CLASS_INF']['CLASS_OBJ'].filter(function(item, index){
    if (item['@id'] == 'time'){
      return true;
    }
  });

  // Obtain unit
  var apiMetaCat01List = jsonData['GET_STATS_DATA']['STATISTICAL_DATA']['CLASS_INF']['CLASS_OBJ'].filter(function(item, index){
    if (item['@id'] == 'cat01'){
      return true;
    }
  });
  var Unit = apiMetaCat01List[0]['CLASS']['@unit'];

  // The array to store the data to draw on a graph
  var graphData = new Array();
  for (var key in valueData) {
    // Meta info
    var apiYokoName = apiMetaYokoList[0]['CLASS'].filter(function(item, index){
      if (item['@code'] == valueData[key]['@time']){
        return true;
      }
    });
    graphData.push({
      name : apiYokoName[0]['@name'],
      value: valueData[key]['$']
    });
  }
});

Based on the analysed data, API draws graphs by using Javascript library.

Morris is used in the sample below.

It is useful to choose JSON format when passing data from PHP to Javascript.

The graph is drawn in the DIV tag which ID is "mygraph" in this sample.

<script>
  // Draw graph
  new Morris.Bar({
      element: 'mygraph'
      , data: JSON.parse('<?php echo json_encode($aryGraph);?>')
      , xkey: 'name'
      , ykeys: ['value']
      , xLabels: "Year"
      , labels: ['value']
      , postUnits: '<?php echo $Unit;?>'
      , gridLineColor: '#000000'
      , hideHover: 'auto'
  });
</script>
<div id="mygraph"></div>

Pass the data as is for Javascript.

<script>
  // Draw graph
  new Morris.Bar({
      element: 'mygraph'
    , data: graphData
    , xkey: 'name'
    , ykeys: ['value']
    , xLabels: "Year"
    , labels: ['value']
    , postUnits: Unit
    , gridLineColor: '#000000'
    , hideHover: 'auto'
  });
</script>
<div id="mygraph"></div>