I'm looking for a way to query Sharepoint O365 (Online) User Profile data from within an Access 2013 application.
I have created a Web App on our O365 Sharepoint (Online) that includes a Sharepoint Azure Sql Server backend (as opposed to lists). I have also created an Access desktop application, for data maintenance and reporting, that links to the same Azure backend . The web app uses the Sharepoint user's login Email and other info located in the Sharepoint User Profile to authenticate permissions, and limit data. Before a new hire can use the web app, their Sharepoint login email and other User Profile data must be added to the app's Azure backend User table.
It has been suggested that I download User Profiles to a csv file via Powershell and CSOM. I have no experience with Powershell or CSOM, but from my research, I'm pretty sure I can call Powershell and run a CSOM script via vba. The various script examples that I have found seem to require Global Admin privileges to succeed. The users that maintain the data will not have admin privileges, so this seems to be a roadblock to that method.
My expertise is in Access (mostly vba) with Sql Server backend, and I am just getting started with Sharepoint. I'm hoping to find a way to link to the Sharepoint User Profile table to the Access Desktop app in the same way that I link to the apps backend Azure tables, so I can then write vba code that will allow the users to add new hires to the app's Azure backend User table.
Is there a way to accomplish this?
Or, if not via the desktop app, is there a way to link to or otherwise get the User Profile data via the existing Web App, or a new Web App?
Thanks!