C#

Posts in this category.

Dataverse: Create an API to update Base Currency

Mar 23, 2024

This time, I've got a request from Trung Dũng Nguyễn where he wants to update the base currency based on the updated Currency inputted into the Transaction Currency table. When I check on the system behavior, the Currency (Base) information will be updated as long as we update at...

Dataverse: How to call Custom API in classic Workflow

Jan 6, 2024

In architecting a solution, we have lots of ways to do it. Specifically, in the Power Platform world, we can combine Dataverse (Dynamics CRM) with Power Platform to do integration/whatever scenarios that we need. But, what if we want to implement the generic integration with only...

Learn how to use Dataverse Background operations (preview)

Sep 23, 2023

Let's learn how to use Dataverse Background operations (preview). For those who don't know, this is a way to call our custom API via background task (system job). Unfortunately, this method is not a way to bypass a two-minute execution time-out. For me, this feature is more of a...

Dataverse: SSIS vs. ExecuteMultipleRequest

Aug 26, 2023

I am always curious to try SSIS (as mostly my experience is on customizing CRM CE/Dataverse side) as people are always telling me how fast it is to process large data. So today, we will learn and compare ExecuteMultipleRequest vs. SSIS. In the SSIS part, we will be using...

How to call OnPremise WebAPI from Canvas App

Aug 13, 2023

In a time where technology is very fast changing, I see some of the Organizations that still rely on so-called legacy systems or probably still depend on systems that just run on their network (on-premise). So, today, we will learn how to call on-premise WebAPI from Canvas Apps....

Dataverse: The Importance of OrderBy When Retrieve more than 5k records

Jul 15, 2023

Lately, I've been playing with retrieving large sets of data from Dataverse. The total records that I need are more than 50k records (if you are using FetchXML, you can get the method here). But somehow seems like Dataverse limits my total records and here is how we fixed it. As...

Dataverse: UpsertRequest vs Custom API. Which one is faster?

Jul 8, 2023

For those who don't know, we already have UpsertRequest for so long (I learned how to use it correctly in this blog post that you can read here). UpsertRequest is a feature where we can request Dataverse to create or update the data based on columns that we are defined. In...

Dataverse: Setup spkl from pac plugin init project

Feb 25, 2023

When we are generating a plugin project using Power Platform CLI > "pac plugin init" command, the csproj that is being generated it's different from the one that SparkleXrm by Scott Durrow has (the plugin project generated using "pac plugin init" I believe using minimal csproj...