Question
BPM Company
NL
Last activity: 2 Apr 2024 4:53 EDT
Authentication 403 error in SharePoint Online component
Hi all,
We've installed the SharePoint Online Integration v2 component on our PegaCloud dt1 environment and using it in our application.
We followed the configuration steps as described https://docs-previous.pega.com/data-management-and-integration/87/installing-sharepoint-online-component and https://docs-previous.pega.com/data-management-and-integration/87/connecting-your-application-sharepoint .
We connect to a sharepoint-site that was recently configured by our client. The site was configured with a Sharepoint expert and we double checked the authorization configuration of the sharepoint site.
While running one of the data pages (D_SPOnlineGetAllLists) we get a 403 http status code. In the log I see that an error occurs:
BEARER authentication error: No access token available
HTTP Status code: 403 Forbidden
We did a connection setup in postman following the steps of Microsoft: https://learn.microsoft.com/en-us/azure/active-directory/develop/quickstart-register-app#configure-a-client-application-to-access-web-apis . Here we are succesfully able to retrieve a list of lists. The setup is different than how the SP Online component handles the authentication calls, a high-trust sharepoint is used not line with the steps that Microsoft provides in the URL above.
Hi all,
We've installed the SharePoint Online Integration v2 component on our PegaCloud dt1 environment and using it in our application.
We followed the configuration steps as described https://docs-previous.pega.com/data-management-and-integration/87/installing-sharepoint-online-component and https://docs-previous.pega.com/data-management-and-integration/87/connecting-your-application-sharepoint .
We connect to a sharepoint-site that was recently configured by our client. The site was configured with a Sharepoint expert and we double checked the authorization configuration of the sharepoint site.
While running one of the data pages (D_SPOnlineGetAllLists) we get a 403 http status code. In the log I see that an error occurs:
BEARER authentication error: No access token available
HTTP Status code: 403 Forbidden
We did a connection setup in postman following the steps of Microsoft: https://learn.microsoft.com/en-us/azure/active-directory/develop/quickstart-register-app#configure-a-client-application-to-access-web-apis . Here we are succesfully able to retrieve a list of lists. The setup is different than how the SP Online component handles the authentication calls, a high-trust sharepoint is used not line with the steps that Microsoft provides in the URL above.
Now from the Microsoft documentation, it seems that the API to retrieve an access token has changed because of the the Graph API introduction. For the Graph API, the authentication method is different from the Sharepoint API.
Here, we use the endpoints:
- Auth URL: https://login.windows.net/common/oauth2/authorize?resource=https%3A%2F%2Fgraph.microsoft.com
- Access token URL: https://login.microsoftonline.com/common/oauth2/token
- Also, the endpoint to which we make the call is different. For example, for retrieving all lists from Sharepoint, the endpoint was
.. and with Graph API became https://graph.microsoft.com/v1.0/sites/<SPO site>/lists (see the site: https://techcommunity.microsoft.com/t5/microsoft-sharepoint-blog/use-postman-and-aad-app-to-get-data-from-sharepoint-online-using/ba-p/510051)
Either way, I don't manage to make this work in our Pega environment, also if I use the exact same setup as in Postman Pega doesn't manage to get a token.
Help is very much appreciated!
Best regards,
Erwin