News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Data retrieved from Dy...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested answer

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

(0) Share

Report

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?

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Steve Zhao2 on at

Like (0)

Report

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

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])

Helpful resources

Quick Links

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1

Adis 136 Super User 2025 Season 1

#2

Sohail Ahmed 81

#3

Jonas "Jones" Melgaard 77 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans