Hello!
I've been struggling with the SharePointOnlineConnector transformer for a couple days now. I have set up a web service following the official tutorial (first I've set up one for Sharepoint List, then an identical one from the Sharepoint Online template as well).
When using a Sharepoint List Reader I can successfully access the lists, but I can't access anything from the SharePoint Online Connector. I get the following error: "SharepointOnlineConnector: Error making request to https://graph.microsoft.com/v1.0/sites?$select=id,webUrl,name&search=: Access token validation failure. Invalid audience."
The app I've set up in azure has the following permissions (might be overkill, but I'm just testing for now):
Microsoft Graph (5)
Sites.Manage.All
Sites.Read.All
Sites.ReadWrite.All
User.Read
User.ReadWrite
SharePoint (7)
AllSites.Manage
AllSites.Read
AllSites.Write
MyFiles.Read
MyFiles.Write
Project.Read
Project.Write
What am I missing here?
Thanks in advance!