.NET

Posts in this category.

Dataverse: Retrieve unmasked data (Masking Rule Column) via KingswaySoft

Mar 21, 2026

New day, new experience to discover! This time, I have a requirement to create an SSIS batch job function. During data retrieval, I found that the column is masked using the Masking Rule. This blog post is a brief note on how to retrieve the unmasked data. Enjoy! Dataverse Column...

What I learned about SSIS

Jan 16, 2026

Happy New Year, everyone! Today, I want to share a list of knowledge that I have gained since I started learning SSIS - KingswaySoft! Certainly, the tips I wrote here may not be applicable/outdated later on, and you can call them out or discuss with me if you think I have a wrong...

Benchmark: TDS Endpoint vs QueryExpression vs FetchExpression

Nov 29, 2025

I read Mark Carrington's blog post about his latest findings on TDS Endpoint revisited, which can be found here. One of the key points that is interesting is his finding about the internal Dataverse message ExecutePowerBISql, which intersects with the function I created last time...

Customer Insights: Get Email Delivery and Interaction Details of Journey

Sep 13, 2025

I got asked by a customer how to get the interaction details of the Journey. By default, in the Journey that is on the status of Going Live or Completed, we can click on the Delivery funnel button to see the drill-down of the information: Delivery funnel information Then, it will...

Customer Insights: Rendering Marketing Form using React App

Sep 7, 2025

Have you ever used the default Customer Insights - Marketing Forms? If yes, you will notice that the default URL generated is random: https://{server-load}/{organizationid}/digitalassets/forms/{msdynmkt_marketingformid} In the eyes of us tech-savvy, we probably don't really think...

Dataverse: C# extension to simplify how to get Custom API Input

Aug 2, 2025

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,...

Using Azure Service Bus Queue to simplify Dataverse Concurrency

Jun 23, 2025

Have you ever faced a challenge where you needed to process bulk data that would update a single record? For example, you processed receipts for a single customer, and the program failed to update the correct data because the processing happened at almost the same time...