piu - 経済統計練習帳

var sta=new Array();
var codex=new Array();
var title=new Array();
var point=new Array();
 
function myFunction() {
 
 var code="00200522";    
 
   var urlx="http://api.e-stat.go.jp/rest/2.1/app/getStatsList?appId=aeec3b02995623cad42b80c80f73d176b7c77970";
   urlx=urlx+"&statsCode="+code; 
 
 
      str="";
      try {
 
 var res = UrlFetchApp.fetch(urlx);
        str=res.getContentText();
 
    } catch (e) { Logger.log("Fail");}
 
 var tan="</TABLE_INF>";
 
  var x=str.split(tan);
 
    Logger.log(x[1]);
 
 
 for(s=1;s<x.length-1;s++){ 
 p1=x[s].indexOf("<STATISTICS_NAME>");
 p2=x[s].indexOf("</STATISTICS_NAME>",p1);
 sta[s]=x[s].substring(p1,p2);  
 p1=x[s].indexOf("<TITLE no=");
 p2=x[s].indexOf("</TITLE>",p1);
 title[s]=x[s].substring(p1,p2);   
 
 p1=x[s].indexOf("<TABLE_INF");
 p2=x[s].indexOf(">",p1);
 codex[s]=x[s].substring(p1,p2);   
}
 
number=x.length-2;  
 
   Logger.log(number);
 
  for(s=0;s<number+1;s++){
  point[s]=new Array();
  }
 
 point[0][0]="A";
 point[0][1]="B";
  point[0][2]="C";
 
  for(s=1;s<number+1;s++){
 sta[s]=sta[s].replace("<STATISTICS_NAME>","");
   p1=title[s].indexOf("<TITLE",p1);
  p1=title[s].indexOf(">",p1);
  p2=title[s].indexOf("<",p1);
 if(p2<0) p2=title[s].length;
  title[s]=title[s].substring(p1+1,p2);
  p1=codex[s].indexOf("\"");
  p2=codex[s].indexOf("\"",p1+1);
  codex[s]=codex[s].substring(p1+1,p2);
  }
 
 
  for(s=1;s<number+1;s++){
  point[s][0]=sta[s];
  point[s][1]=title[s];
  point[s][2]=codex[s];
  }
 
    var id="1o00qv6Q2XTuTfB56FdV84NLQjYuDuspnbJdp869YQaA"; 
 ex = SpreadsheetApp.openById(id);
 var sheet = ex.getSheetByName("data"); 
 
 sheet.getRange(1,1,number+1,3).setValues(point);  
 
 
}