top of page
Search
  • admin

Using FetchXmlBuilder to generate OData query

Quite often, we need to specify the attributes to select or the filter conditions on related entities in DataVerse connector in Microsoft Flow.


Expand Query is exactly where we can specify those. However, the Flow designer does not have the context awareness and showing you an easy to select list.

Furthermore, the expand query is case sensitive that it must match the relationship Schema as how it was entered in DataVerse upon creation. One may entered it with upper case or all lower cases, eg. new_Account.


Luckily, the FetchXMLBuilder tool in XrmToolbox comes with a very handy feature that can generate the query for us.


In the example below, my query sets to return name attribute, and filtering on name equals 'test'.


Click on View menu, then select OData 4.0 (WebAPI).



The OData query will be generated for you at the bottom of the screen.


You may then simply copy and paste the $expand query to the Expand Query of Microsoft Flow designer.




Thats it for now.




0 comments

Recent Posts

See All

Adding custom PCF control to Dynamics 365 CE form

PCF Gallery (https://pcf.gallery/) has a great list of PCF controls available to use - both free and payable controls. Once you have imported the solution to your Dynamics 365 environment, you have to

Kommentare


bottom of page