Hello,

I am trying to configure SharePoint List Reader/Writer using the Web service Template. I tested FME 2021 and 2022. I have an Azure Single Tenant environment and followed the documentation (https://community.safe.com/s/article/How-to-create-a-Sharepoint-Web-Connection#singletenant, https://community.safe.com/s/article/Create-an-FME-Server-Azure-Active-Directory-Web-Connection-in-FME-Desktop, https://community.safe.com/s/article/Troubleshooting-SharePoint-Web-Connections-and-Services).

I did the following:

In the Azure Active Directory portal:

1.      Creating the app registration and getting the Client ID

2.      Add the Redirect URIs (https://login.microsoftonline.com/sTENANT_ID]/oauth2/nativeclient and https://localhost) for a newly created platform

3.      Setting API permissions accordingly

In FME Desktop:

1.      Creating a new Web Service from the existing template

2.      Setting the Client ID

3.      Setting the Redirect URI with the same value as mentioned before. I tried both Redirect URIs

4.      https://eTENANT_NAME].sharepoint.com/.default" alt="https://login.microsoftonline.com/tTENANT_ID]/oauth2/v2.0/authorize?scope=https://eTENANT_NAME].sharepoint.com/.default" target="_blank">https://login.microsoftonline.com/eTENANT_ID]/oauth2/v2.0/authorize?scope=https://rTENANT_NAME].sharepoint.com/.default offline_access&response_type=code&prompt=consent

5.      Setting the token parameter URL (https://login.microsoftonline.com/"TENANT_ID]/oauth2/v2.0/token)

6.      Setting the refresh token URL (https://login.microsoftonline.com//TENANT_ID]/oauth2/v2.0/token)

7.      The request format remains unchanged (client_id=pCLIENT_ID]&refresh_token=rREFRESH_TOKEN]&grant_type=refresh_token)

When I click “Test…” in the “Manage Web Services” dialogue, I am asked to login and am then able to request the access (consent) for my app. After the approval of the admin, I click “Return to app”. A loading indicator “Retrieving access token” appears, finally leading to a timeout. Although the access was granted multiple times, the same messages appear repeatedly.

I already fiddled FME Desktop but did not found any clues. In the Azure Audit Logs, the AADSTS90095 AdminConsentRequiredRequestAccess error appears.

The SharePoint Online Connector works well, while the List Reader/Writer do not.