MS系のライセンス数をSlackに通知させる

function getAccesstoken() {

 const clientID ="xxx";
 const clientSecret="xxx";
 const tenantID="xxx";
 const tokenUrl=`https://login.microsoftonline.com/${tenantID}/oauth2/v2.0/token`;

 const payload={
  "client_id":clientID,
  "client_secret":clientSecret,
  "grant_type":"client_credentials",
  "scope":"https://graph.microsoft.com/.default"
 };

 const options={
  "method":"POST",
  "contentType":"application/x-www-form-urlencoded",
  "payload":payload
 };

 const response = UrlFetchApp.fetch(tokenUrl, options);
 const tokenData = JSON.parse(response.getContentText());
 const accessToken = tokenData.access_token;

 return accessToken;
}

function getApiResponse(apiURL){
 const accessToken = getAccesstoken();
 const url = `https://graph.microsoft.com/v1.0/${apiURL}`;

 const options={
  "method":"GET",
  "headers":{
  "Authorization": `Bearer ${accessToken}`
  }
 };

 const response = UrlFetchApp.fetch(url, options);
 const apiResponse = JSON.parse(response.getContentText());
 return apiResponse
}

function getUseSku(){
 const data = getApiResponse("subscribedSkus");
 let values = [];

 for(let i of data.value){
  if(i.skuPartNumber=="EMS" || i.skuPartNumber=="MDATP_XPLAT" || i.skuPartNumber=="OFFICESUBSCRIPTION"||
  i.skuPartNumber=="O365_BUSINESS"){
   let value = [];
   value.push(i.skuPartNumber);
   value.push(i.prepaidUnits.enabled);
   value.push(i.consumedUnits);
   value.push(i.prepaidUnits.enabled - i.consumedUnits);
   values.push(value);
  };
 }

 return values;
}

function writeMs() {
 const ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

 const msData = getUseSku();
 msData.unshift(["ライセンス名","購入数","使用数","残り"]);

 ss.getRange(1, 1, msData.length, 4).setValues(msData);
}

function webhookSlack(url,message) {
 const webhookUrl = url;

 const payload = {
  "text": message,
 };

 const options = {
  "method" : "post",
  "contentType" : "application/json",
  "payload" : JSON.stringify(payload)
 };

 UrlFetchApp.fetch(url, options);
}

function main(){
 writeMs();
 const ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
 const data = ss.getRange(2,1,ss.getLastRow()-1,4).getValues();
 const webhookUrl = "xxx"

 let messages = "";
 for(let i of data){
  const message = `${i[0]}の残りライセンス数は${i[3]}です\n`;
  messages = messages+message;
 }

 webhookSlack(webhookUrl,messages);
}