Fetch XML is a really handy way of retrieving data from CRM. It is easy to construct complex query and really simple to execute. In this blog article I will explain how you can execute fetch XML query in Dynamic CRM 2011 or CRM online. To start you will first need to download a fetch xml from advanced find and then use the RetrieveMultiple method of the CRM Service to execute the Fetch XML.
First go to Advanced d find and select the entity on which you need to make query
Following is the fetchxml retrieve from Advance Find:
String fetchXml = @"'1.0'?>
'false' mapping='logical' output-format='xml-platform' version='1.0'>
'contact'>
'lastname'/> 'firstname'/>
'contactid'/> 'false' attribute='telephone'/> 'and'>
'vdbwc1_vip' value='1' operator='eq'/>
";
All now that is left is to send a fetch request. This can simply be done by using the following code.
EntityCollection EC = _service.RetrieveMultiple(new FetchExpression(fetchXml));
if (EC != null && EC.Entities != null && EC.Entities.Count >= 1)
{
foreach (Entity E in EC.Entities)
{
Guid entityId = E.Id;
}
}
Above code shows how RetrieveMultiple method is used to retrieve EntityCollection from fetchxml.
Hope this helps. Happy Coding !!