15 likes
·
3.1K reads
16 comments
Awesome as always Jon!
Cheers, Louis. Glad you enjoyed it.
Just what I needed
Thank you Jon. Just to confirm, if I do not set up the access policies as you outline above, the app registration credentials will automatically allow the viewing of users' emails and calendars?
Thanks again.
Just seems like this is not applying the principle of 'least privileges' for access.
You are correct. Without the access policy the *.All roles provide access to all users email, calendar, etc. unfortunately access policies only work for email and calendar currently
I noticed in your list 365 apps you didn’t mention WORD. Is this because we can’t use any available APIs for WORD or no one thinks there’s a need for that. We currently considering the new AOP add on. We aren’t using Office with that. Thanks.
Hi, the MS Graph APIs only cover Office 365 services, like email, calendar, SharePoint, etc. They do not cover Office 365 products like Word, Excel, PowerPoint, etc. If you need to generate Word or Excel Documents, then I would recommend APEX Office Print.
Hi Jon,
I am getting
{"error":{"code":"InvalidAuthenticationToken","message":"Access token validation failure. Invalid audience.",
error when calling users API. Followed same steps. Please help
Hi, It is hard to say from the information provided, but it could be that you did not grant admin consent after assigning the permission. Check the part of the Blog that starts with "The final step is to Grant Admin consent for the App...".
Hi Jon,
Thank you.
Didn't you have to set up ACL rules and wallet to make the test work?
Ordinarily, yes but I run my stuff on Oracle Cloud Free Tier which already has ACLs and a Wallet with the most common certificates already installed.
Hi Jon, I just stumbled over your post.
We were working on an MS Graph SDK for PL/SQL some time ago and put it on GitHub, could be interesting for you.
Very cool; I'll check it out.
How do I handle pagination?
Hi Jordan, You must write a REST Source Plugin for pagination using REST Data Sources blogs.oracle.com/apex/post/apex-181-early-…. I haven't gotten my head around how to do that yet, so currently, I use PL/SQL to fetch data in a loop. I either use a PL/SQL pipelined table function or add data to an APEX Collection.