Utarbeidet med KI.
FetchXML handles what OData cannot. This guide shows you the fastest way to create a correct query without writing XML by hand.
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.
Advanced search can export the completed XML. It can be pasted directly into the integration or into Power Automate.
FetchXML can aggregate, count, and group—something OData handles less effectively. This is one of the main reasons to choose it.
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.
FetchXML is difficult to read. Two lines in plain language explaining what it retrieves will save the next person half an hour.
Still et spørsmål eller del hva som hjalp deg.
Har du et spørsmål eller en erfaring å dele?
Bli den første som bidrar.
