💡Tip: Convert FetchXml to a Query expression

by Jul 8, 2024

💡Tip: Convert FetchXml to a Query expression

Have you had a situation where you have a FetchXml query, but you needed to inspect, tweak, or extend it a little?

You can load it into a XElement or XDocument and fiddle with it.

But you can ask Dataverse to convert your FetchXml query to a QueryExpression, just by making a request with FetchXmlToQueryExpressionRequest.

The response will contain a QueryExpression that you can inspect, tweak, and extend.

Btw. If you need to convert it back, there is also a QueryExpressionToFetchXmlRequest.

#
Remy van Duijkeren

Remy van Duijkeren

Power Platform Advisor

Microsoft Power Platform Advisor with over 25 years of experience in IT with a focus on (marketing) automation and integration.

Helping organizations with scaling their business by automating processes on the Power Platform (Dynamics 365).

Expert in Power Platform, Dynamics 365 (Marketing & Sales) and Azure Integration Services. Giving advice and strategy consultancy.

Services:
– Strategy and tactics advise
– Automating and integrating

Subscribe to
The Daily Friction

A daily newsletter on automation and eliminating friction

Related Content

Cancel Culture in IT

Cancel Culture in IT Cancel Culture is happening in major communities to developers and contributors, like: Linux Kernel C++ Standard Committee Python NixOS openSUSE Godot And the reasons? Completely absurd: Being Republican Liking an old SNL sketch Using the word...

read more

VS Code is NOT an IDE.

VS Code is NOT an IDE. And I like it that way. I use VS Code as a fast text editor. Just a couple of bare-bone plugins. No bloat. No unnecessary features. Just speed. I see people turning VS Code into a full-fledged IDE with tons of extensions. At that point… just use...

read more

“Can you do tomorrow at 3pm?” 😩

“Can you do tomorrow at 3pm?” 😩 No. No I cannot. But you can check my calendar and book yourself. 😎 I use Calendly. Link in my email footer. Customers book themselves. On my terms. At my availability. Some folks are scared to share a booking link. 😱 They think they’ll...

read more