---
title: "Discussion on \"APEX & Office 365 Integration - Introduction\" | Hashnode"
description: "Discussion on \"APEX & Office 365 Integration - Introduction\". The first post in a series where you will learn how to utilize MS Office 365 services (Calendar, Email, SharePoint) from your APEX Apps using MS Graph APIs"
url: "https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [APEX & Office 365 Integration - Introduction](https://blog.cloudnueva.com/apex-msgraph-introduction?utm_source=hashnode&utm_medium=feed)

The first post in a series where you will learn how to utilize MS Office 365 services (Calendar, Email, SharePoint) from your APEX Apps using MS Graph APIs

Sep 16, 2022 · 8 min read · blog.cloudnueva.com  
Read the article

-   [#orclapex](https://hashnode.com/tag/orclapex)
-   [#oracle](https://hashnode.com/tag/oracle)
-   [#integration](https://hashnode.com/tag/integration)
-   [#msgraph](https://hashnode.com/tag/msgraph)
-   [#office365](https://hashnode.com/tag/office365)

## Written by

[Jon Dixon](https://hashnode.com/@orclapex)

@orclapex · San Diego, CA

  
[View profile](https://hashnode.com/@orclapex)

APEX, ORDS & the Oracle Database

I’m Jon Dixon, an Oracle APEX developer and consultant at Cloud Nueva. I write about APEX, ORDS, the Oracle Database, and how AI is changing the way we build software. This blog is where I share practical examples, lessons learned, and ideas from my work.

## Responses 9

Markdown supported · ⌘↵ to post

[Víctor Ayala](https://hashnode.com/@VicAyaL)

[Feb 12, 2024](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/65ca5d5b572247d70ac5fc82)

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.

[Nehemias Arias](https://hashnode.com/@narias)

[Oct 23, 2023](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/6535d134aa602055e82fec53)

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

[Nehemias Arias](https://hashnode.com/@narias)

[Oct 31, 2023](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/6535d134aa602055e82fec53#reply-6541879b3be149affc02c497)

Thank you! Working on that.[Jon Dixon](https://hashnode.com/@orclapex)

[Nehemias Arias](https://hashnode.com/@narias)

[Nov 1, 2023](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/6535d134aa602055e82fec53#reply-654215c49ba50faa87405c8e)

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](https://hashnode.com/posts/apex-msgraph-introduction/@narias)

[Nehemias Arias](https://hashnode.com/@narias)

[Nov 1, 2023](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/6535d134aa602055e82fec53#reply-6542188d3be149affc02d1dd)

Hi, Disregard last comment/question. Everything working perfectly. Thank you!!! Moving to next article now. [Nehemias Arias](https://hashnode.com/@narias)

[Soeren Dalby](https://hashnode.com/@sdalby)

[Feb 17, 2023](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/63ef1b8046e2f1644c4f2ba6)

Just what I needed

[Paul Jereb](https://hashnode.com/@pauljereb)

[Dec 7, 2022](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/639072a268aae0e23a91e6f8)

Hi Jon, I just stumbled over your post.

We were working on an [MS Graph SDK for PL/SQL](https://github.com/cdngmnks/msgraph-sdk-plsql) some time ago and put it on GitHub, could be interesting for you.

[Jon Dixon](https://hashnode.com/@orclapex)

[Dec 8, 2022](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/639072a268aae0e23a91e6f8#reply-6391e72b0771b6e5cf4a824c)

Very cool; I'll check it out.

[Imre Tarnai](https://hashnode.com/@timre)

[Oct 27, 2022](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/635a5e23f383cb196e2dcc82)

Hi Jon,

Thank you.

Didn't you have to set up ACL rules and wallet to make the test work?

[Jon Dixon](https://hashnode.com/@orclapex)

[Oct 27, 2022](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/635a5e23f383cb196e2dcc82#reply-635a7f6ed8057a1bc9638293)

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.

[Javier Bermudez Tito](https://hashnode.com/@jbermudez)

[Mar 25, 2024](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/635a5e23f383cb196e2dcc82#reply-6600df4ccafd5c12d4c830f9)

[Jon Dixon](https://hashnode.com/@orclapex) 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.

[VB VLOG’S](https://hashnode.com/@bheem487)

[Oct 5, 2022](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/633d60c812186eae2bef83b9)

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

[Jon Dixon](https://hashnode.com/@orclapex)

[Oct 6, 2022](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/633d60c812186eae2bef83b9#reply-633ece3357b647c4f72b0929)

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

[Gregory Grimes](https://hashnode.com/@gpgrimes)

[Sep 22, 2022](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/632cc5e6e06c24f9f23a5511)

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.

[Jon Dixon](https://hashnode.com/@orclapex)

[Sep 22, 2022](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/632cc5e6e06c24f9f23a5511#reply-632ce16f318ff0fa183383da)

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.

[sssuarez](https://hashnode.com/@sssuarez)

[Sep 16, 2022](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/6324cb9abc15ea8efdf5e5d7)

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.

[sssuarez](https://hashnode.com/@sssuarez)

[Sep 16, 2022](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/6324cb9abc15ea8efdf5e5d7#reply-6324cbcbbc15ea8efdf5e5e0)

Just seems like this is not applying the principle of 'least privileges' for access.

[Jon Dixon](https://hashnode.com/@orclapex)

[Sep 16, 2022](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/6324cb9abc15ea8efdf5e5d7#reply-6324efb5bc15ea8efdf5e92b)

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

[Louis Moreaux](https://hashnode.com/@lmoreaux)

[Sep 16, 2022](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/6324757ebc15ea8efdf5d853)

Awesome as always Jon!

[Jon Dixon](https://hashnode.com/@orclapex)

[Sep 16, 2022](https://hashnode.com/posts/apex-msgraph-introduction/63247057bc15ea8efdf5d71d/comment/6324757ebc15ea8efdf5d853#reply-63248fdfdd55cd8b89b1ccac)

Cheers, Louis. Glad you enjoyed it.
