CONVERT QUERYEXPRESSION TO FETCHXML AND VICE-VERSA IN DYNAMICS 365

In this quick post, we will see how to convert Query Expression to FetchXML and how to convert FetchXML to Query Expression in Dynamics 365.

1. QUERY EXPRESSION TO FECTH XML
   The below function can be used to convert a Query Expression into Fetch Xml query
   
   public void ConvertQueryExpressionToFetchXml()
   {
   List<Account> lstAccounts = new List<Account>();
   QueryExpression qeQuery = new QueryExpression(Account.EntityLogicalName)
   {
   ColumnSet = new ColumnSet(Account.Fields.Id),
   Criteria = new FilterExpression()
   {
   FilterOperator = LogicalOperator.And,
   Conditions =
   {
   new ConditionExpression(Account.Fields.StateCode, ConditionOperator.Equal, (int)AccountState.Active),
   }
   },
   };
   var qeToFetchXmlRequest = new QueryExpressionToFetchXmlRequest
   {
   Query = qeQuery
   };
   var qeToFetchXmlResponse = (QueryExpressionToFetchXmlResponse)AdminService.Execute(qeToFetchXmlRequest);
   var fetchXml = qeToFetchXmlResponse.FetchXml;
   }
   
   
   
   
2. FETCH XML TO QUERY EXPRESSION
   The below function can be used to convert a Fetch Xml query into a Query Expression
   
   public void ConvertFetchXmlToQueryExpression()
   {
   List<Account> lstAccounts = new List<Account>();
   FetchExpression feQuery = new FetchExpression();
   feQuery.Query = @"<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='statecode' operator='eq' value='0' />
   </filter>
   </entity>
   </fetch>";
   var feToQueryExpressionRequest = new FetchXmlToQueryExpressionRequest
   {
   FetchXml = feQuery.Query
   };
   var feToQueryExpressionResponse = (FetchXmlToQueryExpressionResponse)AdminService.Execute(feToQueryExpressionRequest);
   var queryExpression = feToQueryExpressionResponse.Query;
   }
   
   
   

Hope This Helps!