oData query possibilities

  • 21 April 2017
  • Vasiliy Kovalenko

[Your Organization Root URL]/data/Customers                                   List all the customers.
[Your Organization Root URL]/data/Customers?$top=3                            List the first three records.
[Your Organization Root URL]/data/Customers?$skip=3                           Skip the first three records.
[Your Organization Root URL]/data/Customers?$select=FirstName,LastName        List all the customers, but show only the first name and last name properties.
[Your Organization Root URL]/data/Customers?$format=json                      List all the customers in a JSON format that can be used to interact with JavaScript clients.
[Your Organization Root URL]/data/Customers?$filter=CustomerAccount eq 'key'
[Your Organization Root URL]/data/Customers?$filter=ItemModifiedDateTime gt 2017-03-07T03:29:28Z
URL encoded
Filter possibilities
http://www.odata.org/getting-started/basic-tutorial/
http://www.k3technical.com/testing-ax7-odata-services-fiddler/
https://ax.help.dynamics.com/en/wiki/odata-in-dynamics-ax-7/

Search

About

DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics AX.

Authors are allowed to set their own AdSense units.
Join us.

Blog Tags