Tuesday, November 5, 2019

D365FO oData endpoint and filters for optimal use

By now you know that, the metadata for the data entities present in a particular instance of a Dynamics 365 for Finance and Operations instance is publicly available and can be accessed by anyone anywhere using the URL
https://<Your-Devbox-URL>.cloudax.dynamics.com/data/$metadata 

And you will be able to get data using filtering conditions directly in the URL now... for example: 


https://<your-devbox-url>.cloudax.dynamics.com/data/ProductStatusSetups?$top=2

https://<your-devbox-url>.cloudax.dynamics.com/data/ProductStatusSetups?$select=StatusId


https://<your-devbox-url>.cloudax.dynamics.com/data/ProductStatusTables?$filter=ProductStatusId%20eq%20%27CANCELLED%27


https://<your-devbox-url>.cloudax.dynamics.com/data/ProductStatusTables?$filter=ProductStatusId eq 'CANCELLED'


Do make use of the flexibility you get from the new web-client urls in Dynamics.

Happy coding!