Tag Archives: FetchXML

Validate FetchXml by using ValidateFetchXmlExpression WebAPI function in the script

Introduction: In a recent project, we retrieved Dynamics 365 CRM data using WebAPI and fetchXml expressions. In most cases, we create fetchXml expressions, where we add attributes and filter conditions dynamically in the fetchXml.  When we execute our dynamically created fetchXml expressions, it fails with  different error messages. Here we had come across a requirement… Read More »

How to solve “When using arithmetic values in Fetch a ProxyTypesAssembly must be used in order to know which types to cast values to” while using Fake XRM Easy

Introduction While using Fake XRM Easy for Plug-in or Workflow unit testing, there could be situations that could arise where we need to use fetchXML to retrieve some records. While it works for most of the time, it can be tricky while working with some attributes statecode for starters. In the above fetchXML, “<condition attribute=”statecode”… Read More »

Field Comparisons now available for Queries in Power Platform

Dynamics 365 CRM and the platform underneath has always provided for a proprietary query language called FetchXML. With the introduction of CRM Online, this became the defacto query language as SQL commands could no longer be used (well querying data through sql is being reintroduced, under preview right now, but that is another topic for… Read More »

Use WEB API Batch Request in Dynamics 365 to execute long FetchXML

Introduction: Recently we had a project where we use WEB API for retrieve the records from Dynamics CRM. In our project, we dynamically create FetchXML to retrieve records but sometimes Fetchxml have a lot of columns and conditions etc so its length get increase and we this the fetchxml in URL which violates the browser… Read More »

Inogic’s Top 10 Most Popular Dynamics CRM Blogs of 2014

This blog in the beginning of New Year brings you the Top 10 interesting and useful blogs posted by us during the year 2014. This article consists of content from blogs that belong to CRM 2013 and which have been the most visited, re-tweeted and commented blogs of Inogic. Hope these set of blogs are resourceful and help you some way… Read More »

Use SQL Tracing to find the SQL query generated for Dynamics CRM Platform Operations for CRM On-Premise

Dynamics CRM works largely on FetchXML queries. FetchXML is a proprietary query language for Dynamics CRM. For developers coming from SQL background, they would really want to find the SQL query that the FetchXML translates into. While one way is to explain the FetchXML syntax, it might help to also get the SQL statement that… Read More »