Skip to main content

Notifications

Power Platform integration forum
Under review by Community Managers

Under review

Thank you for your post! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Query Data Export Service Profile for synch failures

Posted on by 3,962

Hi,

 

As you know, the D365 Data Export Service does not have an automated notification when there is a synchronisation failures. The only way to check for failures is to go in to DES and check for it.

 

a2z_0-1633486515929.png

 And clicked the failed records and you will eventually get a Download Failed Records message:

 

a2z_1-1633486573833.png

Then you go to the Azure storage explorer and check if you can get access to that blob area.

Man, give me a break. Just send it to me as an admin person and attach top it the list of failed records.

We pay MS a lot $ and yet they can't  do something simple.

 

Anyway, this is what I am hoping to do.

 

Using a recurring Cloud Flow, I want to interrogate the DES profile for any failures and send to me an email if there are.

According to my research, there is a site that exposes the Crm Exporters APIS. Here is the swagger link to: https://discovery.crmreplication.azure.net/

Swagger UI (azure.net)

 

As you can see from that swagger, it exposes 2 particular APIS that I am interested in.

a2z_2-1633487043827.png

a2z_3-1633487061177.png

 

The 1st API will allow me to get the DES profile ID based on the CRM instance organisation id.

The 2nd one will then allow me to get the failures.

 

Now I have been told that to connect, I need to use App Registration that will act as a connector to 

https://discovery.crmreplication.azure.net/ site but to do that I will need to get a token first.

 

Here is the site that sort of helped me and it explains how to set up the App registration.

oauth 2.0 - How do I authenticate against the Dynamics 365 Data Export Service API? - Stack Overflow

According to that site, I need to give the App registration access to the https://discovery.crmreplication.azure.net/ which I did.  Also I need to give the App registration access to Azure AD so it can sign in and read the user profile:

a2z_4-1633487533150.png

 

So we now come to the Cloud Flow part.

 

1st I need to sign in to https://login.microsftonline.com/tenancy id}/oauth2/token and get a token.

 

The question is what do I enter as the resource?

 

a2z_5-1633487943012.png

Note:  the client_id and client_secret are the ID of the App registration and its password.

 

Is the resource that site that I am trying to get access to (https://discovery.crmreplication.azure.net/)

or is that the online D365 site that has the DES installed and configured?

 

Can someone please explain the Http Cloud Flow step that I need to do in order to connect and call a https://discovery.crmreplication.azure.net/ API?

 

Thanks

 

a2z

 

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans