FetchXML Builder is used to create queries against CDS databases. CDS includes technologies we know as: - Microsoft Dynamics 365 Customer Engagement - Dynamics CRM - Common Data Service for Apps - XRM - PowerApps (Model Driven) - PowerApps (Canvas connected to D365 or CDS) - PowerBI (connected to D365 or CDS)
The tool will assist in three major areas:
1. Constructing queries, including more advanced features like: - aggregates - outer joins - complex "not-in"-queries - attributes from multi-level linked entities - update existing views with altered queries
2. Querying CDS/CRM for information not (easily) found in the UI - system / internal entities - attributes hidden in CRM UI - join on other fields than relationships
The tool reads metadata from CDS to assist with selecting entities, attributes, relations and to perform validation of condition values.
To make it even more appealing, there is also the possibility to have it show "Friendly names", which will replace the technical names of entities and attributes with their display names in the users' currently selected language, much like Advanced Find does.
Latest version release notes
-- Updates -- 1.2019.4.1 - Fixed #251 Wrong separator used for ODATA with multiple aggregates. Thanks to @filcole and @MarkMpn for the fix! 1.2019.3.7 - Fixed #250 Multiple condition operators and aggregate filters added to WebAPI support by @MarkMpn 1.2019.3.6 - Fixed #246,#247,#248 Crash when connected to CRM 2015 or earlier version 1.2019.3.4 - @MarkMpn continues to add improvements to WebAPI / Flow generator, bugfixes and support for aggregate queries
-- New features-- #123 Generate WebAPI queries by @MarkMpn #241 Generate parameters for Flow List Records #195 Convert from QueryExpression C# code to query by @BetimBeja
-- Bug fixes -- #237 Cancelling Close wipes the window. #231 New - Paste XML does not update query builder
-- Other -- Removed XML validation against fetch.xsd as this is no longer up to date with the platform
This is one of those 'must-have' toolbox plugins. I could not imagine working without it. Many thanks to Jonas and any other contributors!
(T Y, )
New user review:
UI is fairly intuitive. Stretchable windows is a good feature. Ability to display QueryExpression is nice but see above. Ability to remember connection details is a real "God send". Various view is excellent.
The FetchXML functionality supported by this tool is constrained to the limitations of QueryExpression (e.g. comparing attributes from 2 different , linked entities - basic SQL functionality - is not supported). Disappointed.
(John Baptiste Bily, )
In Fetch Veritas
(Henri Lo, )
awesome tool Jonas. Help me a lot building complex FetchXml reports.
(Guillaume Lequertier, )
(Nishant Rana, )
One of the best tools in XRM Tool Box.
(Aura Berrocal, )
(Scott Myers, )
(Andrew N, )
This is a brilliant plugin and really increases your productivity by constructing your FetchXML or QueryExpressions for you. So if you are c# developer and want to use Query expressions, you can use the point and click UI to construct your query, get the results and then have Fetch XML generate the Query Expressions for you that you can just copy and paste into your code!!! Brilliant plugin... keep up the good work!!! :)
(Serjanya AE, )
(Scott Sewell, )
(Roman Uvarov, )
(Allan Varcoe, )
(Don Schiavone, )
Cannot imagine life without this tool!
(Scott Sewell, )
Using FetchXML Builder incrementally reduces my impact on global warming.
(Scott Sewell, )
Indispensable. - Absolutely essential for anyone going after XRM/CDS data.
(Njaka MISAHARISON, )
(Guillaume Goulfault, )
(Natraj Yegnaraman, )
(Josh Painter, )
Fantastic tool. I use it almost every day!
Author: Jonas RappLatest version: 1.2019.4.1Released on: 04/08/2019Nuget package Id: Cinteros.Xrm.FetchXmlBuilderOpen Source: trueGo to project web site Ratings (all versions)5Average rating24Number of ratings Downloads12976Latest version354597All versions13133.22Average per version