Showing posts with label Dynamics. Show all posts
Showing posts with label Dynamics. Show all posts

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!