Categories
GNU/Linux

GNU/Linux ODATA Query Examples

ODATA Query Option Description
$orderby Uri parameter for sorting…
$select Uri parameter to select specific coluimns…
$top Uri parameter to limit the result…
$skip Uri parameter to skip number of rows…
$filter Uri parameter to filter result…
$expand Uri parameter to expand related entity…
$inlinecount Uri parameter to include a total record count…

 

Example to retrieve metadata from JBoss DV Odata service…

https://localhost:8443/odata/vdbname/$metadata

 

Retrieve all records in JSON format…

https://localhost:8443/odata/vdbname/modelname?$format=json

 

Order by column ‘Name’ and retrieve first 5 records…

https://localhost:8443/odata/vdbname/modelname?amp;$orderby=Name&$top=5

 

Order by column ‘Name’ and retrieve records 6-10 records…

https://localhost:8443/odata/vdbname/modelname?$orderby=Name&skip=5&$top=5

 

Filter ODATA result ($filter=Name eq ‘John’)…

https://localhost:8443/odata/vdbname/modelname?$filter=Name%20eq%20%27John%27

Select specific rows…

https://localhost:8443/odata/vdbname/modelname?$select=ID,Name,Description