Get Sharepoint 365 Content with Mendix 7

Authentication flow using OpenID Connect

Get Token OAuth

Then put the mapping in micro flow event

Call Sharepoint Online REST API

Location: https://accounts.accesscontrol.windows.net/7007305e-2664-4e6b-b9a4-c4d5ccfd1524/tokens/OAuth/2

HTTP Header: Content-Type = ‘application/x-www-form-urlencoded’

Request: grant_type=client_credentials&client_id=xxx&client_secret=xxx&resource=xxx

Access the SharePoint resource

Now we have the access token, So we can now pass this token in Authorization header with the SharePoint REST API to get the information.

• In Postman tool, add the below URL to retrieve the web title
• https://<sitename>.sharepoint.com/_api/web?$select=Title
• Apply configurations in header
• Method = POST

Get content on Sharepoint 365 relative URL

Call REST API to return Sharepoint List Content

Done. Hope this help