Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

How to handle intergration through API ?

(1) ShareShare
ReportReport
Posted on by 594
Hi guys,
 
In my D365 FO system, I have integration with external system which requires them to get my vendors listing. As I tried to use D365 standard entity and we have VendorsV2 entity for OData, so I try to use it.
Currently, we are on a test, calling this OData using Postman, but we're sometime if not most of the time hit /Request Time Out/ or took about more than 50 second to just execute GET method of this VendorsV2 with only two fields in the selection. Please correct me if I'm wrong, but does the process time took too long ?
 
In Postman, this is what I type as a GET Method : {{baseUrlAzureAPI}}/d365fo/data/VendorsV2?cross-company=true&$filter=dataAreaId eq 'TST' &$select=VendorAccountNumber,VendorOrganizationName
 
As a beginner on this API thing, may I know how usually we handle this kind of integration ? Or when external system wants to get our master data like this Vendors, how is the process ? will they retrieve the whole set to get an update or is there other way like getting the different/modified only ? I also didn't see field ModifiedDate in that standard entity, so if I want to make the external system to just look at the newer modified date, I will need to add the field as the entity extensions? The Modified Date it self already turn ON in the underlying table.
 
Just want to know what is the correct procedure.
 
Thanks.
 
  • Suggested answer
    Kevin Xia Profile Picture
    Microsoft Employee on at
    How to handle intergration through API ?
    Hi,
    After you call OData with postman, there are occasional requests that time out or take a long time to execute GET methods, and I think this may happen because of your network or server performance, which may include tuning network settings, optimizing server resources, and considering load balancing techniques.
    I don't know what the specific processing logic of your GET method is, but I think you can optimize the query to retrieve only the necessary data. Instead of retrieving the entire dataset, use filtering and select only the required fields. This can significantly improve performance. Perhaps there is room for optimization of your GET method?
    Best regards,
    Kevin
  • Martin Dráb Profile Picture
    234,648 Most Valuable Professional on at
    How to handle intergration through API ?
    If you want to export a lot of data, such as all vendors, you may rather want to use Data Management APIs. If you're interested in incremental exports, you could use BYOD or Dataverse. They use change tracking, not ModifiedDateTime field.
     
    Regarding ModifiedDateTime, realize that an entity typically consists of several tables. For example, a vendor have an address, which is in a different table. If the address changes, the entity start returning different data, but ModifiedDateTime of VendTable is still the same. A workaround is creating a computed column combining ModifiedDateTime from different data sources of the entity.

Under review

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

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 565

#2
Martin Dráb Profile Picture

Martin Dráb 536 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 402 Super User 2025 Season 1

Product updates

Dynamics 365 release plans