Unauthorized using O Data in Azure Data Factory V2 and CRM API

(0) Share

Report

Posted on by Rubi_8448

1) Start an Edge Browser

2) Paste a Dynamics CRM link (in our case: https://xxxxxx.api.crm4.dynamics.com/api/data/v9.1 )

3) I can see the data collections which the API returns:

4) Now start Azure Data Factory and click ‘Copy data’:

5) Go to ‘Source’ – ‘Generic protocol’ and click button ‘New connection’ right on the screen.

Select ‘O Data:

6) Enter the same URL used in Edge and provide an authentication type, user name and password. After that click 'Test connection’.

The error message is: Failed to create odata connection to RequestUrl. Failed to get metadata of odata service, please check if service url and credential is correct and your application has permission to the resource. Expected status code: 200, actual status code: Unauthorized

The user is an AAD user and is admin in Dynamics CRM. Using Edge with this user is showing the user has enough permissions.

Why is the connection failing in ADF?

I have the same question (0)