Posts tagged with this topic.
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,...
If you use the Appointment table, some attributes like RequiredAttendees and OptionalAttendees are tricky to use in Power Automate. For instance, if the Appointment status is completed, you want to trigger an email that needs to be sent automatically to the...
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...
Today we will learn how to create a Custom Connector from scratch and implement API Key Authentication. The authentication code that I used is the reference from the below YouTube video from Nick Chapsas: https://www.youtube.com/watch?v=GrJJXixjR8M Without further ado, let's...
Currently, I'm still focusing on how to improve bulk processing in Dataverse. After implementing User Multiplexing, we will learn another consideration that we can apply which is the total threads and chunks of data per thread. Of course, some variables such as network speed,...
I have an interesting question about how to get the Azure Key Vault Secret from the plugin. The official documentation about the RetrieveEnvironmentVariableSecretValue action states that it can only be triggered from Power Automate Flow. The problem with this step is that it...
We always love SQL4CDS by Mark Carrington. One of its features is using the TDS (Tabular Data Stream) Endpoint for reading data. On one of the cron jobs, I have a logic to aggregate the sum of the data. Although I was using SQL4CDS Engine to retrieve the data, I observed the...
Last week, we learned that bulk operation messages offer higher performance than ExecuteMultipleRequest. Today, we dig deeper with the sample of scenarios that I prepared so you can understand when you need to use ExecuteMultipleRequest vs bulk operation messages. Enjoy!...
This is another benchmark post; this time, we need to compare ExecuteMultipleRequest vs CreateMultipleRequest. For those who don't know ExecuteMultipleRequest allows us to basically mix operations (Create, Update, or Delete) and pass parameters to control if an error is raised...
I just realized creating ServiceClient is an expensive operation (I found one blog post that confirmed this problem even though this was an article from 2017). During one of the API call tests, almost half of the time was wasted on the creation of ServiceClient. Before, I always...