ｐ００００； - 経済統計練習帳

var sta=new Array();
var title=new Array();
var codex=new Array();
var point=new Array();


function myFunction() {

var code="00200211";    

   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="1LWWbY8RsGCBQVffrD1wx5xwexx75iZT0bcTrmptnkaA";
ex = SpreadsheetApp.openById(id);
var sheet = ex.getSheetByName("data");

sheet.getRange(1,1,number+1,3).setValues(point);  


}