Dynamics 365 Finance and Supply Chain Management OData for Integrating Applications
Rob Dowsett
|
May 22 2024
|
4 min read
Microsoft Dynamics 365 Finance and Supply Chain Management (also known as Finance and Operations) provides many options for integration with different strengths. One of the strengths of OData is that it is a common standard (https://www.odata.org/) with libraries available in many different languages or platforms.
Be sure to evaluate the integration technology to match the size and scale of your operations.
When an OData integration covers multiple operations (sales order lines from an ecommerce system, for example), it may be useful to combine multiple OData requests into a batch operation:
When creating an integration, it is key to evaluate volume and throughput to ensure successful operations. One of the ways that D365 Supply Chain Management ensures availability of services and consistency of response times is by recognizing when an integrating application has exceeded the available resources. When the webservices are over-allocated. it will respond with a 429Too Many Requests (https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/429).
Throttling Overview
Throttling is when the number of requests exceeds the rate at which the system allows over a period of time.
When your OData request experiences throttling, you’ll receive an HTTP 429 Too Many Requests error.
Throttling can lead to delayed data processing, reduced performance, and potential issues with retry policies.
Dynamics provides a “wait” value—but depending on the scale and nature of your integration it may make sense to evaluate other wait models. One common approach which provides some resiliency, and helps prevent all “waiting” clients from retrying at the same time in mutli-client scenarios is Exponential back off and jitter https://aws.amazon.com/blogs/architecture/exponential-backoff-and-jitter/
OData Paging
When you make an OData request to an entity it is possible to specify a page size—if you do not specify one and there are a large number of records in the related tables then Dynamics will default in a page size for you.
When there are more pages of data to retrieve, the service response includes an @odata.nextlink property which is a URL for the next page.
This error typically manifests as users or applications, “seeing no data” when the Entra app id may have been associated to a user with DAT as the default company. Any integration using OData should be aware of this.
For more technical D365 Finance and Supply Chain Management advice, please contact us here.
This publication contains general information only and Sikich is not, by means of this publication, rendering accounting, business, financial, investment, legal, tax, or any other professional advice or services. This publication is not a substitute for such professional advice or services, nor should you use it as a basis for any decision, action or omission that may affect you or your business. Before making any decision, taking any action or omitting an action that may affect you or your business, you should consult a qualified professional advisor. In addition, this publication may contain certain content generated by an artificial intelligence (AI) language model. You acknowledge that Sikich shall not be responsible for any loss sustained by you or any person who relies on this publication.
About the Author
Rob Dowsett
Rob has worked in the Microsoft Dynamics channel for over 15 years, with expertise in Dynamics 365 Enterprise. Throughout his career, Rob helped build a thriving Dynamics AX practice with a team of over 20 and gained multiple Microsoft President Club awards.
Sign up for Insights
Join 14,000+ Business executives and decision makers.
Latest Insights
Article
Microsoft Government Cloud for Economic Development Organiza...
June 14, 2024
Article
Microsoft Government Cloud for Economic Development Organiza...
June 14, 2024
Data security is paramount, especially for organizations entrusted with sensitive information vital to economic development initiatives. Yet, many Ec...
Internal Audit – The Key Ingredient in AI Implementations
June 13, 2024
Article
Internal Audit – The Key Ingredient in AI Implementations
June 13, 2024
Artificial intelligence (AI)-powered tools have been leveraged by companies and early adopters for some time now. The recent introduction to Generati...
In 2023 and early 2024, the Life Sciences market was much different than in the prior two years. Companies were not receiving the funding they had in...
Utilize Dynamics 365 FetchXML Query Generated From a View Wi...
June 12, 2024
Article
Utilize Dynamics 365 FetchXML Query Generated From a View Wi...
June 12, 2024
Dynamics 365 FetchXML is a powerful tool for querying data from Dataverse within Power Automate. It allows you to retrieve specific records based on ...
NVSPBind – A Tale of an Obscure Utility, and its Modern Re...
June 11, 2024
Article
NVSPBind – A Tale of an Obscure Utility, and its Modern Re...
June 11, 2024
A recent issue with Hyper-V networking on a server brought to memory an older application that lives for a single purpose: to alter the bindings of n...
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Strictly Necessary Cookies
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.