ekkk - 経済統計練習帳

function myFunction() {
 
city="01202";
 
c1="4"+city.substring(0,2);
p1=c1/1-400;
 
 
urlx="https://opendata.resas-portal.go.jp/api/v1/municipality/sales/perYear?cityCode="+city+"&dispType=1&simcCode=-&prefCode="+p1+"&sicCode=-";
 
 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");}
 
 
 
var x=str.split("},");
 
var y=new Array();
sx=0;
for(s=0;s<x.length;s++){
if(x[s].indexOf("year")>-1)sx=sx+1;
if(x[s].indexOf("year")>-1)y[sx]=x[s];
}
 
var year=new Array();
var v=new Array();
number=sx;
for(s=1;s<number+1;s++){
p1=y[s].indexOf("year");
p1=y[s].indexOf(":",p1);
p2=y[s].indexOf(",",p1);
p3=y[s].indexOf("value");
p3=y[s].indexOf(":",p3);
p4=y[s].indexOf("}",p3);
if(p4<0)p4=y[s].length;
year[s]=y[s].substring(p1+1,p2);
v[s]=y[s].substring(p3+1,p4);
}
 
 
var point=new Array();
 
 for(s=0;s<number+1;s++){
  point[s]=new Array();
  }
  point[0][0]="a";
  point[0][1]="b";
  for(s=1;s<number+1;s++){
  point[s][0]=year[s];
  point[s][1]=v[s];
  } 
 
 
    var id="1cBck9Mzg4fTnNO5W8m5Uac14cwceSuHMgSquPKHZrTU"; 
 ex = SpreadsheetApp.openById(id);
 var sheet = ex.getSheetByName("data"); 
 
 sheet.getRange(1,1,number+1,2).setValues(point);  
 
 
 
 
}