Online OData Viewer
Open the viewer
Guides and resources
Guides for reading OData services: SAP, Power BI and Dynamics endpoints, query options, V2 vs V4, the public sample services and how the viewer compares.
Guides
- OData query options cheat sheet — Every OData system query option with V2 and V4 syntax and an example you can run live against the public TripPin and Northwind services in the browser.
- OData V2 vs V4 $metadata, side by side — How associations, function imports, annotations, counts and JSON payloads differ between OData V2 and V4 — with the Northwind service in both versions to compare live.
By platform
- Explore Dynamics 365 OData endpoints — Read the $metadata of Business Central, Finance & Operations and Dataverse OData endpoints as a tree and ER diagram, find entity sets and properties, and test queries.
- Power BI OData.Feed: find out why the feed fails — "The feed's metadata document appears to be invalid", HTTP 406, missing columns: load the service's $metadata in the browser to see which entity set, type or property Power Query trips over.
- View SAP Gateway OData services — Inspect SAP Gateway, RAP and CAP OData services: entity sets, sap:label and sap:creatable annotations, UI and Capabilities vocabularies, ER diagram, live data with sap-client and Basic Auth.
Features
- Entity-relationship diagram from OData $metadata — Paste an OData service URL or EDMX file and get an entity-relationship diagram with keys, navigation properties, multiplicities, inheritance and complex types. Export as PNG, SVG or Mermaid.
- OData data explorer and query tester — Query any public or Basic-Auth-protected OData service from the browser: pick an entity set, build $filter, $select, $orderby, $expand and paging, see the request URL, copy it as curl, fetch, C#, Python or Power Query, export to Excel.
Sample services
- Northwind (OData V4) sample service — The classic Northwind trading database: customers, orders, products and suppliers as an OData V4 service. Entity sets, keys and navigations of the public OData 4.0 service, with queries you can run in the browser.
- TripPin (OData V4, RESTier) sample service — OASIS' reference service with people, trips, airlines and airports: enum types, complex types, bound functions and actions. Entity sets, keys and navigations of the public OData 4.0 service, with queries you can run in the browser.
- Northwind (OData V2) sample service — The same Northwind model as an OData V2 service: associations, association sets and function imports. Entity sets, keys and navigations of the public OData 2.0 service, with queries you can run in the browser.
- OData.org demo (V2) sample service — Small products/categories/suppliers demo with a complex Address type and a function import. Entity sets, keys and navigations of the public OData 2.0 service, with queries you can run in the browser.
- 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. Entity sets, keys and navigations of the public OData 4.0 service, with queries you can run in the browser.
Comparisons
- Looking for an XOData alternative? — Comparison of the Online OData Viewer and XOData: OData V2–V4.01, ER diagram, private services with Basic Auth, data explorer, exports, open source and self-hostable.