💡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

Get My Thoughts on Automation & Development

Join my personal newsletter and get practical insights on building faster, integrating smarter, and removing friction in IT systems — especially on Power Platform and Dynamics 365.

Related Content

Some devs just want to finish the level.

Some devs just want to finish the level. But software development is an infinite game — not Mario Kart. (Thanks Simon Sinek, you philosopher in sneakers 👟) Here’s the difference: 🛑 Finite devs: - Just want to ship and dip - Avoid complexity by ignoring it - See...

read more

Kindness to AI: good manners, or just survival?

Kindness to AI: good manners, or just survival? I wonder how much electricity OpenAI has burned just because people say "please" and "thank you". AI: "Generating helpful answer... Electric bill: "Crying in kilowatts." 😅 But hey, better be polite...you don’t want to...

read more

Microsoft Teams: Too Many Apps in One?

Microsoft Teams: Too Many Apps in One? All-in-one apps like Teams? That’s a hard pass from me. Microsoft Teams wants to be the one app to rule them all. But I’m the guy who likes my apps separate, like LEGO bricks—not superglued together. I open my To-Do app...

read more