Office365Calendar.js

function getGraphService() {
  // Create a new service with the given name. The name will be used when
  // persisting the authorized token, so ensure it is unique within the
  // scope of the property store.
  return (
    OAuth2.createService("graph")
      .setAuthorizationBaseUrl(
        "https://login.microsoftonline.com/" +
          Settings.getTenantId() +
          "/oauth2/v2.0/authorize"
      )
      .setTokenUrl(
        "https://login.microsoftonline.com/" +
          Settings.getTenantId() +
          "/oauth2/v2.0/token"
      )

      // Set the client ID and secret, from the Google Developers Console.
      .setClientId(Settings.getClientId())
      .setClientSecret(Settings.getSecret())

      // Set the name of the callback function in the script referenced
      // above that should be invoked to complete the OAuth flow.
      .setCallbackFunction("authCallback")

      // Set the property store where authorized tokens should be persisted.
      .setPropertyStore(PropertiesService.getUserProperties())
      .setScope("https://graph.microsoft.com/Calendars.ReadWrite")
  );
}

function logout() {
  var service = getGraphService();
  service.reset();
}

function authorizeIfRequired() {
  if (!Settings.getOffice365CalendarEnabled()) {
    return true;
  }

  var graphService = getGraphService();
  if (graphService.hasAccess()) {
    return true;
  }

  var authorizationUrl = graphService.getAuthorizationUrl();
  var template = HtmlService.createTemplate(
    "<style>" +
      "   .button {" +
      "   background-color: #1c87c9;" +
      "   border: none;" +
      "   color: white;" +
      "   padding: 20px 34px;" +
      "   text-align: center;" +
      "   text-decoration: none;" +
      "   display: inline-block;" +
      "   font-size: 20px;" +
      "   margin: 4px 2px;" +
      "   cursor: pointer;" +
      "   border-radius: 4px;" +
      "   }" +
      "</style>" +
      "<div>" +
      '  <a class="button" href="<?= authorizationUrl ?>" target="_blank">Authorize</a>' +
      "</div>" +
      "<div>" +
      "Reopen the sidebar when the authorization is complete." +
      "</div>"
  );
  template.authorizationUrl = authorizationUrl;
  var page = template.evaluate();
  SpreadsheetApp.getUi().showSidebar(page);
  return false;
}

function authCallback(request) {
  var graphService = getGraphService();
  var isAuthorized = graphService.handleCallback(request);
  if (isAuthorized) {
    return HtmlService.createHtmlOutput("Success! You can close this tab");
  } else {
    return HtmlService.createHtmlOutput("Denied. You can close this tab");
  }
}

function makeRequest(url, options) {
  var graphService = getGraphService();

  if (options === undefined) {
    options = {};
  }

  options.headers = {
    Authorization: "Bearer " + graphService.getAccessToken(),
  };

  var response = UrlFetchApp.fetch(
    "https://graph.microsoft.com/v1.0/me/" + url,
    options
  );
  return response;
}

function test() {
  var response = makeRequest(
    "calendarview?startDateTime=2024-12-27&endDateTime=2024-12-27&$select=Subject,Start,End,IsAllDay,ShowAs"
  );
  var x = response.getContentText();
  var y = JSON.parse(x);
  var z = 1;
}

function test2() {
  var calendar = new Office365Calendar();
  var events = calendar.getEvents(
    new Date("2024-12-27"),
    new Date("2024-12-27")
  );
  var event = events[0];
  var sd = event.getStartTime();
  var d = new Date(sd);
  var y = new Date("2020-01-01T00:00:00.0000000");
  // var eventById = calendar.getEventById(event.getId());
  var eventByMissingId = calendar.getEventById("xxx");
  var x = 1;
}

function formatDate(date) {
  return (
    date.getFullYear() + "-" + (date.getMonth() + 1) + "-" + date.getDate()
  );
}

var Office365Calendar = function () {
  this.createEvent = function (title, startTime, endTime) {
    var payload = {
      subject: title,
      showAs: "Oof",
      isAllDay: true,
      start: {
        dateTime: formatDate(startTime),
        timeZone: "GMT",
      },
      end: {
        dateTime: formatDate(endTime),
        timeZone: "GMT",
      },
    };
    var options = {
      method: "post",
      contentType: "application/json",
      payload: JSON.stringify(payload),
    };

    var response = makeRequest("events", options);
    var json = JSON.parse(response.getContentText());
    return new Office365CalendarEvent(json);
  };

  this.getEventById = function (calendarId) {
    if (calendarId === null) {
      return null;
    }

    if (calendarId === "") {
      return null;
    }

    try {
      var response = makeRequest("events/" + calendarId);
      var content = response.getContentText();
      var eventData = JSON.parse(content);
      return new Office365CalendarEvent(eventData);
    } catch (error) {
      return null;
    }
  };

  this.getEvents = function (startTime, endTime) {
    var response = makeRequest(
      "calendarview?startDateTime=" +
        formatDate(startTime) +
        "&endDateTime=" +
        formatDate(endTime) +
        "&$select=Subject,Start,End,IsAllDay,ShowAs"
    );
    var content = response.getContentText();
    var eventData = JSON.parse(content).value;
    var events = [];
    for (var i = 0; i < eventData.length; i++) {
      events.push(new Office365CalendarEvent(eventData[i]));
    }
    return events;
  };

  this.requiresDayAdjustment = function () {
    return true;
  };

  this.supportsId = function () {
    return true;
  };

  this.getAdjustment = function () {
    return 1;
  };

  this.getType = function () {
    return "office365";
  };

  this.isReadOnly = function () {
    return false;
  };
};

var Office365CalendarEvent = function (data) {
  this.data = data;

  this.getId = function () {
    return this.data.id;
  };

  this.getTitle = function () {
    return this.data.subject;
  };

  this.getStartTime = function () {
    return new Date(this.data.start.dateTime.substring(0, 19));
  };

  this.getEndTime = function () {
    return new Date(this.data.end.dateTime.substring(0, 19));
  };

  this.deleteEvent = function () {
    var options = {
      method: "delete",
    };

    makeRequest("events/" + this.getId(), options);
  };

  this.setTime = function (startTime, endTime) {
    var payload = {
      start: {
        dateTime: formatDate(startTime),
        timeZone: "GMT",
      },
      end: {
        dateTime: formatDate(endTime),
        timeZone: "GMT",
      },
    };
    var options = {
      method: "patch",
      contentType: "application/json",
      payload: JSON.stringify(payload),
    };

    makeRequest("events/" + this.getId(), options);
  };
};