Data retrieved from Dynamics 365 API or Data Factory D365 Connector is incorrect

(0) Share

Report

Posted on by Ib Ninja

I have come across a very strange occurrence. The data I query via Dynamics 365 API (as well as data via Data Factory D365 Connector) differs significantly from theactual Dynamics 365 data (e.g. in SQL or on front end).

Dynamics 365 API request example = 'octoeeo.crm3.dynamics.com/.../contacts eq xxxxxxxxxxxxxxxxxxx'

I also used Dynamics 365 connector in Data Factory. it has the same result.

There are major differences, where columns have values in SQL/front end but no value from API. What could be causing this?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Steve Zhao2 on at

Like (0)

Report

Hi,

This is a weird thing. These all data should be the same because they are all from the dataverse.(Sometimes, the data from on front end would be different due to the cache.)

First, please check whether the environment URL used in the API is the same as SQL.

Second, please make sure the contact GUID is correct.

Then, clear your cache and request API again:

https://octoeeo.crm3.dynamics.com/api/data/v9.2/contacts([contact GUID])

Was this reply helpful? Yes No