Online OData Viewer
Open the viewer
JdbcOdata demo: sales (V4) sample service
SQL queries published as OData V4 feeds by JdbcOdata — customers, products and revenue per month from a PostgreSQL database.
- OData version: 4.0
- Service root:
https://odata.status20.net/odata/ $metadata:https://odata.status20.net/odata/$metadata- Entity sets: 4, entity types: 4, complex types: 0, enum types: 0
Open the ER diagram · Browse the tree
Entity sets
| Entity set | Entity type | Key | Properties | Navigations |
|---|---|---|---|---|
| Kunden | Kunden | KundeId | 6 | Umsaetze |
| Produkte | Produkte | ProduktId | 4 | Umsaetze |
| Umsatz | Umsatz | PositionId | 16 | Kunde, Produkt |
| UmsatzProMonat | UmsatzProMonat | RowId | 8 | — |
Example queries
- First five Kunden —
Kunden?$top=5 - Kunden by KundeId, descending —
Kunden?$orderby=KundeId desc&$top=5 - First five Produkte —
Produkte?$top=5 - Produkte by ProduktId, descending —
Produkte?$orderby=ProduktId desc&$top=5 - First five Umsatz —
Umsatz?$top=5 - Umsatz by PositionId, descending —
Umsatz?$orderby=PositionId desc&$top=5
More examples: OData query options cheat sheet.