とうよこ - 経済統計練習帳

var city=new Array();
 
var year=new Array();
var v=new Array();
 
function myFunction() {
 
 var id="1pCkSln5Zg-FrISYMGiexZsRRe2kJKLAGF19QL6N2HQo"; 
 ex = SpreadsheetApp.openById(id);
 var sheet = ex.getSheetByName("line"); 
 
 
for(s=1;s<6;s++){
city[s]= sheet.getRange(s+1,1).getValue();  
}
 
var vv=new Array();
 
for(s=1;s<11;s++){
vv[s]=0;
}
 
 
for(tr=1;tr<6;tr++){
search(city[tr]);
for(s=1;s<number+1;s++){
vv[s]=vv[s]+v[s]/1;
}
}
 
 
var point=new Array();
for(s=0;s<number+1;s++){
  point[s]=new Array();
  }
  point[0][0]="year";
  point[0][1]="sale";
  for(s=1;s<number+1;s++){
  point[s][0]=year[s];
  point[s][1]=vv[s];
  } 
 
 
 
 var shx = ex.getSheetByName("data"); 
 
 shx.getRange(1,1,number+1,2).setValues(point);  
 
 
 
 
}
 
 
function search(cc) {
 
var city=""+cc;
 
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];
}
 
 
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);
}
 
 
 
 
 
 
}