For security reasons, our business is required to maintain a visitor control log to track when external guests enter and leave the premises.
When our infrastructure used to have on-prem file/storage servers, I had written a simple app that enabled the guests to check in and out via a public kiosk. When checking in, visitors' names, their internal contacts, and check-in times recorded in an Excel spreadsheet on a shared drive; upon checking out, the system would find them in the spreadsheet and append their check-out time. This was achieved using the DocumentFormat.OpenXml SDK.
We have since transitioned entirely to the cloud with SharePoint Online replacing our file servers, and I was trying to find some way to achieve something similar to the above without any success.
The options I found were the following:
Map SharePoint Online site onto the local drive. Windows 10/11 KIOSK mode does not allow access to local drive.
Save file to local drive and upload it. Windows 10/11 KIOSK mode does not allow access to local drive.
Use Microsoft Graph A little stuck on how to find the ID of the file to be read from/written to.
Any pointers in the right direction, particularly with Microsoft Graph and identifying the file I intend to use, would be much appreciated.