Posts tagged with this topic.
I'm fairly certain that all of us agree that we are performing mundane code to obtain input parameters when developing custom APIs. For populating the context.PluginExecutionContext.InputParameters, we need to extract each parameter and cast the value to the correct data type,...
Azure Durable Functions is an extension of Azure Functions that offers specialized capabilities, including statefulness, orchestration, handling retries, and support for running long-running operations. The orchestration functions can help us group multiple processes and bundle...
With the hype of Model Context Protocol - it's kinda a plugin for LLM (Large Language Model) to interact with the external tool(s), I always wonder how to create one. For my field, which is Power Platform - Dataverse, I saw the great Natraj's GitHub repo about MCP Dataverse, and...
When we want to push data to Dataverse/Dynamics CRM using SSIS - KingswaySoft, usually there are relationships (lookup) that we need to settle. In KingswaySoft, there are multiple ways to handle the Lookup: Do not use TextLookup (Input values are provided in GUID Format) Use...
In the PowerApps-Samples repo, I found interesting sample code to execute Dataverse messages using WebAPIs call. For those who ask why there is this option, it is because not so many organizations let you install NuGet Packages freely without having risk analysis (the reason can...
Last week, we learned how to create an email notification to remind us if App Registration in Azure expires. Today, we will learn how to apply automation to generate a New Secret and update the Dataverse Environment Variable. In the flowchart, here are the steps that we will do:...
Have you ever forgotten to create a new secret for your Azure App Registration causing your application to error? The problem with the UI is we can't detect when the secret will expire. And of course, I'm too lazy to open 1 by 1 to check when the secrets will expire! From the UI,...
This is another benchmark blog post, in which I tried to upgrade the greatest snippet on how to do bulk insert, update, or delete (blog post by Mark Carrington that you can read here) with the async operation. As you know, the latest Dataverse ServiceClient supports async...
Quick tips for those who want to retrieve data using QueryExpression, join it with multiple tables, and filter it using OR condition based on LinkEntities. To simplify the explanation, let me show the SQL Query that we want to achieve for the scenario: SELECT contact.firstname,...
We must construct the SQL Connection String when connecting to Dataverse TDS Endpoints via .NET code. The structure of it by default is just "Server={orgname}.crm.dynamics.com;Database={orgname};Persist Security Info=False;". When we talk about SQL connection strings, there are...