houjinn - 経済統計練習帳

var v=new Array();
var t=new Array();
 
function myFunction() {
 
 
  var size="26"; 
    var bus="107";
    var credit="086";
 
 var urlx="http://api.e-stat.go.jp/rest/1.0/app/getStatsData?";
 urlx=urlx+"appId=aeec3b02995623cad42b80c80f73d176b7c77970&statsDataId=0003060191";
 urlx=urlx+"&cdCat01="+credit;
 urlx=urlx+"&cdCat02="+bus;
 urlx= urlx+"&cdCat03="+size;   
 
 
  var response = UrlFetchApp.fetch(urlx);
 str=response.getContentText();
 
 
   id="1EnsS8XGMAeNDXYv-A3yCW3PfB8c7zOl9QLH1Crmymow";
 
 var ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data");
 
  var x=str.split("</VALUE>");
 
  sx=0;
 for(s=0;s<x.length;s++){
 if(x[s].indexOf("<VALUE")>-1)sx=sx+1;
 if(x[s].indexOf("<VALUE")>-1)v[sx]=x[s];
}
 
 
  number=sx;
  for(s=1;s<number+1;s++){
 
 p1=v[s].indexOf("<VALUE");
 p1=v[s].indexOf("time=",p1); 
 p1=v[s].indexOf("\"",p1);
 p2=v[s].indexOf("\"",p1+1);
 
    t[s]=v[s].substring(p1+1,p2);  
 
 
 p1=v[s].indexOf("<VALUE");
  p1=v[s].indexOf(">",p1); 
  p2=v[s].length; 
  v[s]=v[s].substring(p1+1,p2);    
     sheet.getRange(s,1).setValue(t[s]);
    sheet.getRange(s,2).setValue(v[s]);
  }
 
 
 
 
 
 
 
 
 
 
}