FetchXML Builder · XrmToolBox

Description

Build queries for Microsoft Dataverse and the Power Platform. Investigate data. Fix the layouts. Get code. Empower yourself to achieve more.

Read more: https://fetchxmlbuilder.com/

FetchXML Builder is used to create and execute queries against Microsoft Dataverse / Power Apps / Dynamics 365.
The Power Platform includes technologies we know as:
- Microsoft Dynamics 365
- Dynamics CRM
- XRM
- Power Apps (Model Driven)
- Power Apps (Canvas connected to Dataverse)
- PowerBI (connected to Dataverse)
- Microsoft Teams for Dataverse

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

3. Developer assistance generating code for
- C# QueryExpression code
- WebAPI / OData query string
- Power Automate List Records
- SQL, JavaScript and C# stubs
- Easy to use UI to compose queries for reports in CRM

The tool reads metadata from Microsoft Dataverse and Dynamics 365 / CRM 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

Full release notes:
https://fetchxmlbuilder.com/releases/#1.2023.11.001

Released for manual download:
https://github.com/rappen/FetchXMLBuilder/releases/tag/FetchXMLBuilder-1.2023.11.001

Versions

Version	Release date	Number of downloads	Rating
1.2023.11.1	11/12/2023 10:39:29 AM	40914	4.67
1.2023.8.2	8/21/2023 7:46:19 PM	27368	5.00
1.2023.8.1	8/13/2023 5:03:36 PM	5927	0.00
1.2023.2.2	2/14/2023 7:44:33 PM	40417	5.00
1.2022.11.2	11/23/2022 12:04:18 PM	20273	5.00
1.2022.8.1	8/20/2022 10:31:06 AM	20313	5.00
1.2022.5.1	5/29/2022 7:46:09 PM	30667	4.67
1.2022.4.1	4/24/2022 9:47:20 AM	11484	0.00
1.2022.3.1	3/1/2022 5:16:27 PM	14680	0.00
1.2022.2.2	2/7/2022 10:29:48 AM	8619	5.00
1.2022.2.1	2/6/2022 10:39:22 AM	1540	0.00
1.2022.1.5	1/31/2022 5:29:52 PM	3743	0.00
1.2022.1.4	1/19/2022 10:59:47 AM	5854	0.00
1.2022.1.3	1/17/2022 7:36:46 PM	2535	0.00
1.2022.1.2	1/16/2022 4:07:56 PM	1808	0.00
1.2021.10.2	10/6/2021 1:12:20 PM	22567	5.00
1.2021.4.4	4/1/2021 2:25:34 PM	33628	5.00
1.2020.12.3	12/15/2020 11:27:10 AM	20653	0.00
1.2020.12.2	12/14/2020 10:38:59 PM	1414	0.00
1.2020.11.2	11/13/2020 9:10:53 AM	9358	0.00
1.2020.11.1	11/11/2020 9:22:18 PM	2022	0.00
1.2020.9.1	9/21/2020 9:09:35 PM	12593	0.00
1.2020.7.3	7/22/2020 6:46:08 PM	11887	0.00
1.2020.6.2	6/7/2020 4:07:08 PM	9402	5.00
1.2020.5.7	5/23/2020 2:56:56 PM	5359	0.00
1.2020.5.6	5/23/2020 12:17:29 PM	0	0.00
1.2019.12.1	12/2/2019 9:57:07 PM	23368	5.00
1.2019.9.1	9/10/2019 8:22:32 PM	16902	5.00
1.2019.4.1	4/8/2019 8:05:23 PM	23577	5.00
1.2019.3.7	3/15/2019 12:33:27 AM	7852	0.00
1.2019.3.6	3/12/2019 2:45:09 PM	3191	0.00
1.2019.3.5	3/12/2019 10:54:44 AM	0	0.00
1.2019.3.4	3/11/2019 6:51:16 PM	0	0.00
1.2019.3.3	3/10/2019 11:14:02 AM	176	0.00
1.2018.12.5	12/18/2018 8:50:09 PM	14969	4.50
1.2018.12.2	12/14/2018 4:07:27 PM	2971	0.00
1.2018.12.1	12/14/2018 10:56:15 AM	1553	0.00
1.2018.8.2	8/30/2018 2:47:20 PM	16970	4.67
1.2018.6.1	6/15/2018 10:40:29 AM	13530	5.00
1.2018.4.2	4/6/2018 4:35:39 PM	15313	5.00
1.2018.2.2	2/12/2018 3:23:45 PM	15003	5.00
1.2018.2.1	2/1/2018 11:11:52 AM	6373	5.00
1.2018.1.3	1/5/2018 8:59:34 AM	13155	5.00
1.2018.1.2	1/4/2018 9:55:56 PM	110	0.00
1.2017.10.4	10/25/2017 2:42:30 PM	30739	5.00
1.2017.10.3	10/24/2017 1:27:42 PM	5193	0.00
1.2017.8.1	8/3/2017 10:37:02 AM	34996	5.00
1.2017.6.119	6/13/2017 10:52:21 AM	37186	0.00
1.2017.2.117	2/9/2017 3:12:31 PM	57683	0.00
1.2016.12.115	12/13/2016 11:12:21 PM	37467	0.00
1.2016.7.113	7/7/2016 2:17:10 PM	31509	0.00
1.2016.6.111	6/23/2016 9:55:29 AM	8588	0.00
1.2016.5.109	5/26/2016 2:18:20 PM	7795	0.00
1.2016.5.107	5/12/2016 3:13:01 PM	5391	0.00
1.2016.4.106	4/28/2016 3:16:08 PM	3793	0.00

Show more versions (50 more)

Ratings

Latest version

vishnu kiran chitiki ()

allen ai ()

Rh Gh ()

Other versions

Yadavendra yadav () - version 1.2023.8.2

Matt Ruma () - version 1.2023.8.2

M Fonsell () - version 1.2023.2.2

This is brilliant tool indeed - thx Jonas!

Stefan Rauchegger () - version 1.2023.2.2

amazing! great to learn the details behind dataverse

Phil DeBusk () - version 1.2022.11.2

Richard LE () - version 1.2022.8.1

Jiguo Jiang () - version 1.2022.5.1

COOL stuff!!! especially the change to webapi query!!!

Rayan Hanoudi () - version 1.2022.5.1

Microsoft should've built this tool. I used it all the time. One minor feedback, is that I wished it allowed me to show more than 5000 records without having to use pagination. Well, guess what, there is a setting to show more than 5,000 records :) https://jonasr.app/wp-content/uploads/Retrieve-All-Pages.png

Tool author answer ()

Thanks! 😊 Did you use the settings to show *all* pages in one retrieve? See screenshot: https://jonasr.app/wp-content/uploads/Retrieve-All-Pages.png

Juan Simon () - version 1.2022.5.1

Love this tool! It helped some many times and saves a ton of time! Thank you for building and sharing it with everyone!

Maciek Letowt () - version 1.2022.5.1

Seshendra A () - version 1.2022.5.1

Wonderful tool, helps in my daily job activity. thank you

Mariam Guirassy () - version 1.2022.5.1

Tiklu Ganguly () - version 1.2022.2.2

Zakariae Benhallam () - version 1.2021.10.2

This is the tool that I use the most . it's helpful to build complex FetchXML queries, and also provide views for Power Automate parameters, Query Expression , Webapi and much more .

Jussi Muilu () - version 1.2021.10.2

Veljko Vidovic () - version 1.2021.10.2

xu xinyi () - version 1.2021.4.4

Jussi Muilu () - version 1.2021.4.4

Pablo Roldan () - version 1.2020.6.2

Best tool ever

Cleiton Santos () - version 1.2019.12.1

One of the tools you cannot live without

dominique Vissoh () - version 1.2019.12.1

Brian Blair () - version 1.2019.9.1

Great Plugin!

Ben Becker () - version 1.2019.4.1

very handy, love how you can clearly see the relationship references in an intuitive manner, this is great, thank you!

Pankrasio Iscariote () - version 1.2019.4.1

cool

CHRIS JONES () - version 1.2018.12.5

Thomas Payne () - version 1.2018.12.5

Michael Ochs () - version 1.2018.8.2

Trevor Bennett () - version 1.2018.8.2

Great plugin

Ben Walker () - version 1.2018.8.2

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 () - version 1.2018.8.2

New user review: PROS: 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. CONS: 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 () - version 1.2018.8.2

In Fetch Veritas

Henri Lo () - version 1.2018.8.2

awesome tool Jonas. Help me a lot building complex FetchXml reports.

Guillaume Lequertier () - version 1.2018.6.1

Nishant Rana () - version 1.2018.6.1

One of the best tools in XRM Tool Box.

Aura Berrocal () - version 1.2018.6.1

Scott Myers () - version 1.2018.6.1

Andrew N () - version 1.2018.6.1

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 () - version 1.2018.4.2

Scott Sewell () - version 1.2018.4.2

Essential.

Roman Uvarov () - version 1.2018.2.2

GOOD

Allan Varcoe () - version 1.2018.2.2

Don Schiavone () - version 1.2018.2.2

Cannot imagine life without this tool!

Scott Sewell () - version 1.2018.2.2

Using FetchXML Builder incrementally reduces my impact on global warming.

Scott Sewell () - version 1.2018.2.1

Indispensable. - Absolutely essential for anyone going after XRM/CDS data.

Njaka MISAHARISON () - version 1.2018.1.3

Guillaume Goulfault () - version 1.2017.10.4

Natraj Yegnaraman () - version 1.2017.8.1

Josh Painter () - version 1.2017.8.1

Fantastic tool. I use it almost every day!

Related information

Author: Jonas Rapp Latest version: 1.2023.11.1 Released on: 11/12/2023 Nuget package Id: Cinteros.Xrm.FetchXmlBuilder Open Source: true Go to project web site Ratings (all versions) 5Average rating 51Number of ratings Downloads 40914Latest version 800378All versions 14552.33Average per version Tags Troubleshooting Data Customizations Development Reporting Configuration