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

#

Subscribe to
The Daily Friction

A daily newsletter on automation and eliminating friction

Related Content

Improving Optimization?

Improving Optimization? The traditional steps of Optimization: 1. Eliminate 2. Automate or 3. Delegate What if we added a missing element? Simplify. Before automating a convoluted workflow or delegating a tangled task, strip away the unnecessary. Make processes leaner...

read more

Unit tests for Dataverse plugins?

Unit tests for Dataverse plugins? I must admit, I almost never write unit tests for Dataverse plugins. Plugins are often quite simple, testing them in isolation is not particularly useful. Often you only test a couple of if-statements. Unit tests don't bring a lot of...

read more

New Dynamics 365 browser extension

New Dynamics 365 browser extension I'm trying out the new -Power Roles- extension and it looks very promising. You browse to a Dynamics 365 (or Power Apps) app and then you press -record-. It will then monitor all the action you do in the app and propose which...

read more