How do you use FetchXML for advanced queries?
Created with AI.
FetchXML handles what OData cannot. This guide shows you the fastest way to create a correct query without writing XML by hand.
- 5 steps
- Total time: 1 h
- Preparation: 20 min
- Result: A working FetchXML query with aggregation or multiple joins
Required tools
- Access to Advanced Find in Dynamics 365 — There, you build the query visually.
Build the query
1.Start in advanced search, not in a text editor
Build the query visually using the filters and joins you need. Run it and confirm that the result is correct before doing anything else—then you’ll know the logic is sound.
2.Download the query as FetchXML
Advanced search can export the completed XML. It can be pasted directly into the integration or into Power Automate.
Customize and use
3.Add aggregation as needed
FetchXML can aggregate, count, and group—something OData handles less effectively. This is one of the main reasons to choose it.
4.Be aware of the limits
Aggregate queries have an upper limit on the number of rows they process. If this limit is exceeded, the query fails rather than returning an incomplete result. Filter by time period instead of querying all data.
5.Comment on what the query does
FetchXML is difficult to read. Two lines in plain language explaining what it retrieves will save the next person half an hour.
Discussion
Ask a question or share what helped you.
