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.

1 comment:

  1. Hey,
    Thanks for sharing grate information. Helpful for beginner to get traffic from Social Sites and improve site traffic.

    I also learn something new from your post and next I will try to own my blogging method. Thanks again for sharing awesome blogging tips.

    Swasthya

    Regards
    Monika

    ReplyDelete