The OData URL can be modified to represent the corresponding results. It provides various Filter options
$Filter: It is like the WHERE condition. The below URL in the browser returns the products with the price less than 100.
https://services.OData.org/v3/OData/OData.svc/Products?$filter=Price lt 100
$Select: It is used to display only the respective columns of the table.
https://services.OData.org/v3/OData/OData.svc/Products?$select=ID,Categories
In the above example, it displays only the columns ID and Category.
$Orderby: It is used to sort the results. The below url displays the products with the price in decreasing order.
https://services.OData.org/v3/OData/OData.svc/Products?$orderby=Price desc
$top : It displays the initial records of the table.
https://services.OData.org/v3/OData/OData.svc/Products?$top=3
$skip: The Data records can be skipped through this option.
https://services.OData.org/v3/OData/OData.svc/Products?$skip=4
$expand: It is used to join two tables and display corresponding results.
https://services.OData.org/v3/OData/OData.svc/Categories(1)?$expand=Products
Multiple query options is possible through the & symbol
InitialURL/Entityset?$option1=……&$option2=….&$optionN