Discussion on "APEX & Office 365 Integration - Introduction"

Jon Dixon · 2022-09-16T12:47:19.343Z

Introduction This blog post is the first in a series covering integrations between Oracle APEX and Microsoft Office 365. These integrations are made possible using Microsoft Graph APIs. Being able to integrate with Office 365 opens up a world of poss...

Hi Jon, I get this error Bad Request HTTP Status Code: 400 Request ID: ce4b9b11684bc90f6f5a5eb6a8f4fd5a

Request Timestamp: 2024-02-12T17:55:08.352429Z

I have followed the steps exactly as you describe, what could I be missing? In postman it works correctly.

Thank you very much for your answer.

I'm getting ORA-29024: Certificate validation failure, right after clicking "next" in the first screen of create REST data source.

Thank you! Working on that.Jon Dixon

Hi, everything worked exactly as you described, every single step, however the last step (restful test operation button) says: "Found no data while parsing the service response". Any help please? Nehemias Arias

Hi, Disregard last comment/question. Everything working perfectly. Thank you!!! Moving to next article now. Nehemias Arias

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.

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.

Jon Dixon Hola Jhon Tengo mi cuenta en Oracle Cloud, con una instancia limpia, en la cual Instale Oracle 21c Expres y APEX 23.2, pero no me permite integrarme para autenticarme con Azure AD ni tampoco me deja enviar correos a través de mi servicio de correo de Office 365, voy días intentando e intentando, pero no me sale.

Me solicita habilitar ACL y Wallet, donde puedo encontrar como configurar esto.

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...".

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.

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

Awesome as always Jon!

Cheers, Louis. Glad you enjoyed it.

Discussion

APEX & Office 365 Integration - Introduction

Responses(9)

Recent in Forum

Search Hashnode

APEX & Office 365 Integration - Introduction

Responses(9)

Recent in Forum