DYNAMICS 365 HOW TO EXECUTE FETCHXML QUERIES IN C#

Previously, we saw how to execute FetchXml query using Xrm.WebApi in JavaScript

In this quick post, we will see how to execute FetchXml query in C#.

  1. Prepare the FetchXml you want to execute whether from the Advanced Find, or any other FetchXml generator in the community
  2. Create the C# function you want to call in order to execute the retrieve request and Copy/Paste the FetchXml query
  3. In order to be able to execute FetchXml queries in C#, you must use the FetchExpression class instead of QueryExpression as per the below

    public void FetchXmlInFetchExpression()
    {
    var fetchQuery = @"
    <fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>
    <entity name='account'>
    <attribute name='name' />
    <attribute name='primarycontactid' />
    <attribute name='telephone1' />
    <attribute name='accountid' />
    <order attribute='name' descending='false' />
    <filter type='and'>
    <condition attribute='primarycontactid' operator='not-null' />
    <condition attribute='name' operator='like' value='%Northwind%' />
    </filter>
    </entity>
    </fetch>";
    var objRecords = AdminService.RetrieveMultiple(new FetchExpression(fetchQuery));
    }

  4. The above fetchXml is a very simple query, but you can build and execute more complex queries based on your needs


Hope This Helps!

Comments

Post a Comment

Popular posts from this blog

DYNAMICS 365 LEVEL UP BROWSER EXTENSION - PART 1 - FORMS

Image
Level up for Dynamics 365/Power Apps is a browser extension in Edge, Google Chrome, and Firefox that can help users to perform advanced actions related to Dynamics 365. It is a free and very useful tool that can be downloaded from the browser extension web store. It contains a bunch of features that we will be listing and explaining them in a series of posts around the Level up extension In this post, we will see a brief summary about the Forms actions that can be done in the Level up for Dynamics 365/Power Apps . LOGICAL NAMES This option will show logical names for fields, tabs, web resources and sub-grids on the form CLEAR LOGICAL NAMES This option will remove the logical names of fields, tab...
Read more

How to Remove an Active Unmanaged Layer from the Ribbon in Power Apps (Dynamics 365 CRM) Using ribbondebug=true

Image
Customizing the ribbon (command bar) in Dynamics 365 CRM via Power Apps can be a powerful way to tailor the user interface to your business needs. However, during development or testing, and over time, customizations can pile up and it's common that you might have unmanaged customizations. Therefore, if you're working in an environment with both managed and unmanaged layers, you may run into issues where an active unmanaged layer causes unexpected behavior or UI inconsistencies. One of the most frustrating issues is when a ribbon behaves incorrectly due to an active unmanaged layer , often created outside of a solution. Fortunately, there’s a powerful tool to inspect and resolve this: the ribbondebug=true URL parameter . In this post, we'll walk through how to identify and remove an active unmanaged layer from the ribbon in Power Apps for a ...
Read more

GET THE SIZE OF TABLES IN DYNAMICS 365 / DATAVERSE ENVIRONMENT

Image
Data size is continuously growing over the time. Thus, data storage and usage with the increasing complexity and new supported data types, is becoming an essential tool for the organizations to be able to expand their business. Therefore, knowing the data volume becomes very critical and in Dataverse, you are able to check the space reserved by each table. In this post, we will see how to get the size of Dynamics 365 / Dataverse tables for an environment . Using the Capacity page in the Power Platform Admin Center, you can get the size of each table (in MB). Login to Power Platform admin Center Under the Resources menu, click the Capacity option Select the Dataverse tab, or click on the Trial tab to check the environments ...
Read more