Cinteros.Xrm.FetchXmlBuilder 1.2019.12.1

.NET Framework 4.5.2
There is a newer version of this package available.
See the version list below for details.
Install-Package Cinteros.Xrm.FetchXmlBuilder -Version 1.2019.12.1
dotnet add package Cinteros.Xrm.FetchXmlBuilder --version 1.2019.12.1
<PackageReference Include="Cinteros.Xrm.FetchXmlBuilder" Version="1.2019.12.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Cinteros.Xrm.FetchXmlBuilder --version 1.2019.12.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Cinteros.Xrm.FetchXmlBuilder, 1.2019.12.1"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install Cinteros.Xrm.FetchXmlBuilder as a Cake Addin
#addin nuget:?package=Cinteros.Xrm.FetchXmlBuilder&version=1.2019.12.1

// Install Cinteros.Xrm.FetchXmlBuilder as a Cake Tool
#tool nuget:?package=Cinteros.Xrm.FetchXmlBuilder&version=1.2019.12.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

FetchXML Builder is used to create and execute queries against CDS and Dynamics 365/CRM data.
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

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 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.

Product Versions
.NET Framework net452 net46 net461 net462 net463 net47 net471 net472 net48
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.2022.5.1 21,449 5/29/2022
1.2022.4.1 10,684 4/24/2022
1.2022.3.1 13,834 3/1/2022
1.2022.2.2 7,590 2/7/2022
1.2022.2.1 534 2/6/2022
1.2022.1.5 2,715 1/31/2022
1.2022.1.4 4,862 1/19/2022
1.2022.1.3 1,530 1/17/2022
1.2022.1.2 976 1/16/2022
1.2021.10.2 21,927 10/6/2021
1.2021.4.4 32,990 4/1/2021
1.2020.12.3 19,987 12/15/2020
1.2020.12.2 737 12/14/2020
1.2020.11.2 8,698 11/13/2020
1.2020.11.1 1,365 11/11/2020
1.2020.9.1 11,959 9/21/2020
1.2020.7.3 11,180 7/22/2020
1.2020.6.2 8,725 6/7/2020
1.2020.5.7 4,620 5/23/2020
1.2019.12.1 22,678 12/2/2019
1.2019.9.1 16,196 9/10/2019
1.2019.4.1 22,954 4/8/2019
1.2019.3.7 7,187 3/15/2019
1.2019.3.6 2,537 3/12/2019
1.2018.12.5 14,256 12/18/2018
1.2018.12.2 2,274 12/14/2018
1.2018.12.1 882 12/14/2018
1.2018.8.2 16,362 8/30/2018
1.2018.6.1 12,825 6/15/2018
1.2018.4.2 14,730 4/6/2018
1.2018.2.2 14,334 2/12/2018
1.2018.2.1 5,725 2/1/2018
1.2018.1.3 12,458 1/5/2018
1.2017.10.4 30,084 10/25/2017
1.2017.10.3 4,529 10/24/2017
1.2017.8.1 34,390 8/3/2017
1.2017.6.119 36,566 6/13/2017
1.2017.2.117 57,023 2/9/2017
1.2016.12.115 36,758 12/13/2016
1.2016.7.113 30,790 7/7/2016
1.2016.6.111 7,951 6/23/2016
1.2016.5.109 7,120 5/26/2016
1.2016.5.107 4,707 5/12/2016
1.2016.4.106 3,213 4/28/2016

-- New features --
• Integration with the SQL 4 CDS tool! https://markcarrington.dev/sql-4-cds/
• Updates to tree node properties are now immediately reflected in FetchXML and treeview
Both improvements above provided by Mark Carrington https://github.com/MarkMpn

-- Internal--
• Flow now called Power Automate https://github.com/rappen/FetchXMLBuilder/issues/267
• Improved performance for OData v4.0 and Flow – I mean Power Automate – generation
• Using latest and greatest SDKs from Microsoft