Inspiration
Many Canadians, us included, have worked for retail and know the horrors of scheduling conflicts. OfficeAPI was built with this in mind, with the end goal of facilitating scheduling changes and needs.
What it does
We've built an interactive web application which allows standard retail workers to schedule shifts with minimal management interaction, whilst leaving management in control of final schedules through direct access to a human readable spreadsheet.
How we built it
Using Microsoft's development environment, Graph API and Express/Node, we created a back-end to authenticate users, update/retrieve information from OneDrive, update Calendar, as well as send emails. HTML, CSS, and JS were used to create a web interface from which user's can interact with Calendar and OneDrive Excel files that represent their working schedule.
Challenges we ran into
Using Graph API caused issues for our group as there were inaccuracies and clarity issues with the public documentation found online. Connecting the front-end to the back-end also posed a problem, as development was mostly done separately for the 2 sides.
Accomplishments that we're proud of
We're super proud of completing the project in the allotted time, despite starting with 0 knowledge of Microsoft Graph API, and our new acquired knowledge of Graph API.
What we learned
We learn how to access and update Microsoft resources through Graph API and how Excel, Calendar, and Outlook responses formatted from Graph API.
What's next for OfficeAPI
Some of the new features such as payroll information and management GUI are planned for the future.
Log in or sign up for Devpost to join the conversation.