💡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

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

I see your comment. And I see AI fingerprints all over it.

I see your comment. And I see AI fingerprints all over it. You know the ones where you think: Bro... did you even read my post? 😅 I get it. We want engagement. We want the algorithm to give us more eyeballs. But fake engagement is still fake. Here’s what happens when...

read more