Inhaltsverzeichnis

2.1 Osnove OData

OData1) (Open Data Protocol) je REST2) temeljen standard za upite podataka, razvijen od strane OASIS-a3).

Zašto OData?

OData verzija

Data Gateway podržava OData v4.016).

Service Document

GET /odata/demo

Navodi sve dostupne Entity Setove (tablice/View-ove).

Metapodaci

GET /odata/demo/$metadata

Vraća shemu u EDMX7) formatu.

Upit Entity Seta

GET /odata/demo/Customers
GET /odata/demo/Customers?$top=10
GET /odata/demo/Customers?$filter=Country eq 'Germany'

Opcije upita

Opcija Opis Primjer
$filter Filtrira rezultate $filter=Price gt 100
$select Odabire stupce $select=Name,Price
$orderby Sortira rezultate $orderby=Name desc
$top Ograničava broj $top=10
$skip Preskače zapise $skip=20
$count Broji rezultate $count=true
$expand Učitava relacije $expand=Orders

Nastavak

Izvori

1)
OData - Open Data Protocol: https://www.odata.org/
2)
Representational State Transfer: https://de.wikipedia.org/wiki/Representational_State_Transfer
3)
OASIS Open: https://www.oasis-open.org/
4)
OData Query Options: https://docs.oasis-open.org/odata/odata/v4.01/odata-v4.01-part2-url-conventions.html
5)
Common Schema Definition Language: https://docs.oasis-open.org/odata/odata-csdl-json/v4.01/odata-csdl-json-v4.01.html
6)
OData Version 4.01 Specification: https://docs.oasis-open.org/odata/odata/v4.01/odata-v4.01-part1-protocol.html
7)
Entity Data Model XML: https://docs.oasis-open.org/odata/odata-csdl-xml/v4.01/odata-csdl-xml-v4.01.html