FetchXML in .NET Core - CRM Web API

Question

I'm learning how to use CRM Web API with .NET Core to work with entities and I found this very useful library. There is an option to retrieve record data using FetchXML.

string fetchXml = "<fetch mapping='logical'><entity name='account'><attribute name='accountid'/><attribute name='name'/></entity></fetch>";
var fetchResults = await api.GetList("accounts", QueryOptions: new CRMGetListOptions() { FetchXml = fetchXml });

Is there any option how to compose more easily and elegantly the fetchXML, for example by using QueryExpression (Microsoft.CrmSdk.CoreAssemblies) or something similar?

Not really, I use the XrmToolBox FetchXML, although it is not what I wanted. — Banana Cake, Oct 21 '19 at 07:39

score 0 · Answer 1 · answered Oct 08 '19 at 14:48

0

Design the Advanced find query & download the fetchxml
Develop fetchxml queries using XrmToolBox FetchXML builder

You can use QueryExpressionToFetchXmlRequest to convert the QueryExpression into FetchXml.

answered Oct 08 '19 at 14:48

Arun Vinoth-Precog Tech - MVP

22,364
14
59
168

the QueryExpressionToFetchXmlRequest would be good, but I can not use IOrganizationService in .NET Core so I don't know how to use it there and if is possible. – Banana Cake Oct 09 '19 at 09:06

score 0 · Answer 2 · answered Oct 09 '19 at 12:12

0

I have found Mike Ochs's FetchXmlWrapper helpful in certain projects.

More info: https://www.cobalt.net/2014/06/25/performance-improvements-using-fetch-xml-wrapper/

answered Oct 09 '19 at 12:12

Aron

3,877
3
14
21

FetchXML in .NET Core - CRM Web API

2 Answers2