OData data explorer and query tester

Once the viewer has read a service's $metadata, the Data tab queries its entity sets for you. You pick the set; the explorer knows its properties and navigations and fills the pickers accordingly.

• Query options: $filter, $select (property picker), $orderby (or click a column header), $top, $skip, $expand, $search (V4) and free custom parameters such as sap-client.
• Counts and paging: $count=true on V4, $inlinecount=allpages on V2; next links are followed with one click.
• Readable results: V2 /Date(…)/ values shown as dates, __metadata removed, deferred navigations and foreign keys turned into links that open the related rows.
• The exact request URL is always visible — copy it, or use Copy as for curl, JavaScript fetch, C# HttpClient, Python requests and Power Query M. Credentials are never put into the snippet, only a placeholder.
• Excel export of the current page or the whole set, with columns typed from the model's Edm types.
• Shareable query links for public services: the URL carries service, set and query.

Services behind a login

Enter user and password for HTTP Basic authentication. They stay in the tab's memory, go to the service over HTTPS only, and are never stored or logged. Intranet addresses cannot be reached from this site; for those, run the viewer yourself.

See the query options cheat sheet for examples you can run with one click.

Try it on Northwind