kjooo - 経済統計練習帳

var city=new Array();
var code=new Array();
 
function myFunction() {
 
  tx=0;
  for(tr=1;tr<48;tr++){
 urlx="https://opendata.resas-portal.go.jp/api/v1/cities?prefCode="+tr;
 
 var he = {
    'X-API-KEY': 'QTPchshTtS5JGmrEw0ELladqSbGwnKxh5KVqmZvU'
  };       
 
 
   var op = {
   'headers' : he
 };     
 
 
      str="";
      try {
 
 var res = UrlFetchApp.fetch(urlx,op);
        str=res.getContentText();
 
    } catch (e) { Logger.log("Fail");}
 
 
 
  p1=str.indexOf("[");
  p2=str.indexOf("]",p1);
 
  str=str.substring(p1+1,p2);
 
  de="},";
 
  for(s=1;s<100;s++){
  str=str.replace(de,"△");
}
 
  var x=str.split("△");
 
 
 
number=x.length;
 
 
  for(s=1;s<number+1;s++){
    p1=x[s-1].indexOf("cityCode");
    p1=x[s-1].indexOf(":",p1);
     p2=x[s-1].indexOf(",",p1);
   p3=x[s-1].indexOf("cityName");
    p3=x[s-1].indexOf(":",p3);
    p4=x[s-1].indexOf(",",p3);
  tx=tx+1;
  code[tx]=x[s-1].substring(p1+1,p2);
  city[tx]=x[s-1].substring(p3+1,p4);;
  } 
  }
 
  number=tx;
 
  var point=new Array();
 
  for(s=0;s<number+1;s++){
  point[s]=new Array();
  }
 
 point[0][0]="自治体名";
 point[0][1]="コード"; 
 
   for(s=1;s<number+1;s++){
 　point[s][0]=city[s];
   point[s][1]=code[s]; 
  }
 
    var id="12RsUBv6gFwaI-rnNWex9Jc06PE26eGHNNYDF6oG40RE"; 
 ex = SpreadsheetApp.openById(id);
 var sheet = ex.getSheetByName("data"); 
 
 sheet.getRange(1,1,number+1,2).setValues(point);  
 
 
}