Friday, July 26, 2019

Data access using OData - Filter

As many of you may already be familiar that D365 uses OData (Open data protocol). You can access the data entity let's for example you have developed a Data entity with public collection name "Students".
  1.  Query below will produce the data related to all the students. /data/Students
      2.  Modify The query further to give you only top 10 records. /data/Students?$top=10

     3.  Modify the query to get the students selecting only columns FirstName and the LastName.
              /data/Students?$top=10&$select=FirstName,LastName

     4.  Modify the query to get the students filtering the records specifying the Firstname.
             /data/Students?$top=10&$select=FirstName,LastName&$filter=FirstName%20eq%20%27Elsa%27


Hope this little blog post will help you in filtering the relevant data in Data entities.

Wednesday, July 24, 2019

Download a file after saving in AX 365

I required quite simple code to download an XML file on client machine after saving it to a local directory. This is the small code snippet that might be useful for you as well.


Also this blog post http://erconsult.eu/blog/exposing-dynamics-365-onebox-lan/ will help you configuring the download storage so that we could download file to client browser.