Windows program to retrieve room bookings from Office 365 via API and save them into a SQL Server database
Budget: $250 – $750 USD
Use the Microsoft Bookings API https://docs.microsoft.com/en-us/graph/api/resources/booking-api-overview?view=graph-rest-1.0 to import room bookings from Office 365 and save them into a SQL Server database.
The program will need to be implemented in multiple phases as follows:
1
Prototype console program that connects to the local SQL database to retrieve Office 365 account credentials, and settings, connects to Office 365, imports room bookings and saves them into a specific table.
2
Enhance the above program so it can be executed multiple times and update the previously imported bookings, delete the ones that have been deleted from Office 365 and insert the new ones.
3
Finalize the program with various settings, timeout, retries, error messages, debugging and logging, etc.
4
Future enhancements - such as writing bookings entered directly in the SQL database back to Office 365 .
Accepted programming languages are C# or VB.NET.
The SQL database table structure and specific details will be provided to the selected people.
Please provide time and cost estimate for this project.
The program will need to be implemented in multiple phases as follows:
1
Prototype console program that connects to the local SQL database to retrieve Office 365 account credentials, and settings, connects to Office 365, imports room bookings and saves them into a specific table.
2
Enhance the above program so it can be executed multiple times and update the previously imported bookings, delete the ones that have been deleted from Office 365 and insert the new ones.
3
Finalize the program with various settings, timeout, retries, error messages, debugging and logging, etc.
4
Future enhancements - such as writing bookings entered directly in the SQL database back to Office 365 .
Accepted programming languages are C# or VB.NET.
The SQL database table structure and specific details will be provided to the selected people.
Please provide time and cost estimate for this project.