FetchXmlToQueryExpressionRequest FetchXmlToQueryExpressionRequest FetchXmlToQueryExpressionRequest FetchXmlToQueryExpressionRequest Class


Contains the data that is needed to convert a query in FetchXML to a QueryExpression.

For the Web API use the FetchXmlToQueryExpression Function.

Web API support for this message was added with December 2016 update for Microsoft Dynamics 365 (online) and December 2016 Service Pack for Microsoft Dynamics 365 (on-premises) .

public ref class FetchXmlToQueryExpressionRequest sealed : Microsoft::Xrm::Sdk::OrganizationRequest
public sealed class FetchXmlToQueryExpressionRequest : Microsoft.Xrm.Sdk.OrganizationRequest
type FetchXmlToQueryExpressionRequest = class
    inherit OrganizationRequest
Public NotInheritable Class FetchXmlToQueryExpressionRequest
Inherits OrganizationRequest


      // Create a Fetch query that we will convert into a query expression.
var fetchXml =
    @"<fetch mapping='logical' version='1.0'>
     <entity name='opportunity'>
      <attribute name='name' />
       <condition attribute='estimatedclosedate' operator='next-x-fiscal-years' value='3' />
      <link-entity name='account' from='accountid' to='customerid'>
       <link-entity name='contact' from='parentcustomerid' to='accountid'>
        <attribute name='fullname' />
         <condition attribute='address1_city' operator='eq' value='Bellevue' />
         <condition attribute='address1_stateorprovince' operator='eq' value='WA' />

// Run the query with the FetchXML.
var fetchExpression = new FetchExpression(fetchXml);
EntityCollection fetchResult =
Console.WriteLine("\nOutput for query as FetchXML:");

// Convert the FetchXML into a query expression.
var conversionRequest = new FetchXmlToQueryExpressionRequest
    FetchXml = fetchXml

var conversionResponse =

// Use the newly converted query expression to make a retrieve multiple
// request to Microsoft Dynamics CRM.
QueryExpression queryExpression = conversionResponse.Query;

EntityCollection result = _serviceProxy.RetrieveMultiple(queryExpression);

// Display the results.
Console.WriteLine("\nOutput for query after conversion to QueryExpression:");

The following example shows how to use this message. For this sample to work correctly, you must be connected to the server to get an IOrganizationService interface. For the complete sample, see the link later in this topic.

Query#FetchXmlAndQueryExpressionQueryConversion1 QueryVB#FetchXmlAndQueryExpressionQueryConversion1


Message Availability

This message works regardless whether the caller is connected to the server or offline.


Pass an instance of this class to the Execute(OrganizationRequest) method, which returns an instance of FetchXmlToQueryExpressionResponse.

Privileges and Access Rights

For a complete list of the required privileges, see FetchXmlToQueryExpression message privileges.

Notes for Callers

The use of the keyword Distinct in query expressions is different from the FetchXML query language. When mapping a query from Fetch to QueryExpression, results will not be consistent if the Distinct keyword is used in the FetchXML string.


FetchXmlToQueryExpressionRequest() FetchXmlToQueryExpressionRequest() FetchXmlToQueryExpressionRequest() FetchXmlToQueryExpressionRequest()

Initializes a new instance of the FetchXmlToQueryExpressionRequest class.


ExtensionData ExtensionData ExtensionData ExtensionData

Gets or sets the structure that contains extra data. Optional.

(Inherited from OrganizationRequest)
FetchXml FetchXml FetchXml FetchXml

Gets or sets the query to convert.

Item[String] Item[String] Item[String] Item[String]

Gets or sets the indexer for the Parameters collection.

(Inherited from OrganizationRequest)
Parameters Parameters Parameters Parameters

Gets or sets the collection of parameters for the request. Required, but is supplied by derived classes.

(Inherited from OrganizationRequest)
RequestId RequestId RequestId RequestId

Gets or sets the ID of an asynchronous operation (system job). Optional.

(Inherited from OrganizationRequest)
RequestName RequestName RequestName RequestName

Gets or sets the name of the request. Required, but is supplied by derived classes.

(Inherited from OrganizationRequest)

Applies to

See also