DYNAMICS 365 HOW TO EXECUTE FETCHXML QUERIES IN C#

Views (19)

Charles Abi Khirs

3,569

Like(0)

Report

Prepare the FetchXml you want to execute whether from the Advanced Find, or any other FetchXml generator in the community
Create the C# function you want to call in order to execute the retrieve request and Copy/Paste the FetchXml query
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));
}
The above fetchXml is a very simple query, but you can build and execute more complex queries based on your needs