Error when trying to authenticate with token against ProjectOnline about adf

[ninawrz]

I am currently trying to build a similar pipeline and get an error when I try to call the URL with the token:

_ErrorCode=RestSourceCallFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The HttpStatusCode 401 indicates failure. Request URL: https://****.sharepoint.com/sites/demoa/api/ProjectData/Projects?$select=ProjectId,ProjectActualCost,ProjectActualDuration,ProjectActualFinishDate,ProjectActualStartDate,ProjectActualWork,ProjectCost,ProjectCreatedDate,ProjectCurrency,ProjectDescription,ProjectDuration,ProjectFinishDate,ProjectIdentifier,ProjectLastPublishedDate,ProjectModifiedDate,ProjectName,ProjectPercentCompleted,ProjectPercentWorkCompleted,ProjectStartDate,ProjectStatusDate,ProjectWork Response payload:{"error_description":"Exception of type 'Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException' was thrown."},Source=Microsoft.DataTransfer.ClientLibrary,'

I think there might be a problem with the scope. Which Scope did u use? I currently have set: scope=user.read%20openid%20profile%20offline_access%20ProjectWebAppReporting.Read and also have the scope granted in the appregistration.

Do you have any idea what the issue could be ?

I got the Solution. The Scope must be set to the Sharepoint Site: scope=https://***.sharepoint.com/.default

I also checked out the pagination as the limit is set to 300 response objects but doesnt got any usable state. I think the Problem is that the pagination URL is sent as an relative URL. Did you already did some research on that?

[LunchWithaLens]

Sorry for not replying earlier - and yes, my scope was .default, with the ProjectWebAppReporting.Read and the Graph User.Read as the only required permissions (at least for this app). I hadn't tried doing anything with the pagination - but I think if you just browse to the endpoint it does append the 'next page' link. Not sure if you can strip that out and use it in some way. If I get a chance in the next couple of weeks I'll see if I can get it working. My main aim here was the authentication, but yes, without pagination these recordset sizes aren't going to work well