xml77 - 経済統計練習帳

var sta=new Array();
var title=new Array();
var codex=new Array();
var point=new Array();
var numberx; 
 
function myFunction() {
 
 var code="0003006606";    
 
   var urlx="http://api.e-stat.go.jp/rest/2.1/app/getStatsData?appId=aeec3b02995623cad42b80c80f73d176b7c77970";
   urlx=urlx+"&statsDataId="+code;
 
 
      str="";
      try {
 
 var res = UrlFetchApp.fetch(urlx);
        str=res.getContentText();
 
    } catch (e) { Logger.log("Fail");}
 
 var a1="<CLASS_INF>";
   var a2="</CLASS_INF>";
 
  p1=str.indexOf(a1);
  p2=str.indexOf(a2,p1);
  strx=str.substring(p1,p2);
 
  for(s=1;s<100;s++){
  strx=strx.replace("<CLASS_INF>","");
}
   var x=strx.split("</CLASS_OBJ>");
 
 var memo=new Array();
 
  sx=0;
  for(s=0;s<x.length-1;s++){
  sx=sx+1;
  memo[sx]=x[s];
  }
 
 
  numberx=x.length-1;
 
  for(s=1;s<numberx+1;s++){
  str1=memo[s];
  var x2=str1.split(">");
  p1=x2[0].indexOf("id=");
  p1=x2[0].indexOf("\"",p1);
  p2=x2[0].indexOf("\"",p1+1);
  z1=x2[0].substring(p1+1,p2);
 
  p1=x2[0].indexOf("name=");
  p1=x2[0].indexOf("\"",p1);
  p2=x2[0].indexOf("\"",p1+1);
  z2=x2[0].substring(p1+1,p2);
  Logger.log(s+","+z1+","+z2);
  for(sx=1;sx<x2.length-1;sx++){
  p1=x2[sx].indexOf("code=");
  p1=x2[sx].indexOf("\"",p1);
  p2=x2[sx].indexOf("\"",p1+1);
  z1=x2[sx].substring(p1+1,p2);
  p1=x2[sx].indexOf("name=");
  p1=x2[sx].indexOf("\"",p1);
  p2=x2[sx].indexOf("\"",p1+1);
  z2=x2[sx].substring(p1+1,p2);
  Logger.log(s+","+sx+","+z1+","+z2);
  }
  }
 
 
 
 
 
}