Azure Functions is a serverless computing platform provided by Microsoft Azure. It allows developers to write small, event-driven pieces of code that can be executed in response to various events such as HTTP requests, queue messages, blob storage changes, and timer events. Azure Functions can be written in several programming languages, including C#, Java, JavaScript, Python, and PowerShell.
Dynamics 365 imposes a default SQL timeout of 2 minutes for executing SQL queries. In scenarios where long-running or complex queries exceed this timeout, Azure Functions can be used to overcome this limitation. This section outlines the approach and components involved in utilising Azure Functions to handle time-consuming queries on behalf of Dynamics 365. Zavanti leverages Azure Functions to overcome large data/query processes like payment imports, adding locations and assets to property based on master data etc.