OData WebAPI Tester Online - Microsoft Dataverse & Dynamics 365 Query Runner

OData WebAPI Tester is a 100% client-side developer studio designed to format, validate, test, and execute Microsoft Dataverse and Dynamics 365 OData v4 Web API queries directly in your browser with zero credential sharing.

Key Features

Browser Single Sign-On (SSO): Safely test queries in your authenticated Dataverse session with zero credentials, tokens, or proxies stored or transmitted.
Multi-line OData Code Editor: Real-time syntax highlighting, bracket matching, indentation, and live OData linter for queries.
Visual Clause Builder: Build complex OData queries visually with entity sets, field-by-field conditions, operators, and nested $expand relationships.
Resizable Split Screen: Inspect Code Editor and Visual Clause Builder side-by-side with real-time bidirectional synchronization.
Environment Manager: Seamlessly switch between development, UAT, and production tenants. Interoperable with FetchXmlTester and Quick Data Viewer (QDV).
Code Generator: Generate production-ready code snippets for Xrm.WebApi.retrieveMultipleRecords, Power Automate Flow (List rows), C# HttpClient, cURL, Fetch API, and PowerShell.

OData Query Syntax Reference

Supported system query options in Dataverse OData v4:

$select: Comma-separated list of attributes to return (e.g. $select=name,telephone1,address1_city).
$filter: Boolean expression to filter rows (e.g. $filter=statecode eq 0 and (contains(name,'Contoso') or address1_city eq 'Seattle')).
$expand: Semicolon-delimited nested relationship queries (e.g. $expand=primarycontactid($select=fullname,emailaddress1;$filter=donotemail eq false)).
$orderby: Sort order for results (e.g. $orderby=createdon desc).
$top: Number of rows to return per page (e.g. $top=50).
$count: Boolean flag to return the total row count (e.g. $count=true).

Frequently Asked Questions

How do I test Microsoft Dataverse OData queries without sharing credentials?

OData WebAPI Tester executes queries directly within your authenticated browser session via native Single Sign-On (SSO) in a new tab. No passwords, client secrets, or tokens are ever stored or transmitted to external servers.

How do I format and beautify long OData Web API queries?

Paste your raw OData query URL into the Request URI bar or type directly into the Code Editor. Click Beautify to format query clauses across multiple indented lines with structured nested $expand relations.

Can I use Visual Clause Builder and Code Editor side-by-side in split screen?

Yes. Select the Split View option on the toolbar to display the Code Editor and Visual Clause Builder side-by-side with an interactive resizable divider. Any changes in one pane automatically synchronize with the other in real time.

How do I copy Dataverse queries into Power Automate or JavaScript?

Click Code Gen in the toolbar to generate ready-to-paste snippets for Xrm.WebApi.retrieveMultipleRecords, Power Automate List rows parameters, Fetch API, C# HttpClient, cURL, and PowerShell.

OData syntax error detected

System Query Options

Option	Description	Example
`$select`	Comma-delimited list of attributes to retrieve	`$select=name,telephone1,address1_city`
`$filter`	Boolean expression to filter entity rows	`$filter=statecode eq 0 and statuscode eq 1`
`$expand`	Include navigation property records (semicolon-delimited subclauses)	`$expand=primarycontactid($select=fullname,emailaddress1)`
`$orderby`	Sort query results ascending or descending	`$orderby=name asc, createdon desc`
`$top`	Limit the maximum number of rows returned	`$top=50`
`$skip`	Skip specified number of rows in results	`$skip=100`
`$count`	Retrieve total matching record count	`$count=true`

Filter Operators

Operator	Type	Example
`eq` / `ne`	Equality / Inequality	`statecode eq 0`, `donotemail ne true`
`gt` / `ge`	Greater than / or equal	`revenue gt 50000`, `createdon ge 2026-01-01`
`lt` / `le`	Less than / or equal	`numberofemployees le 100`
`and` / `or` / `not`	Logical Conjunctions	`statecode eq 0 and not (statuscode eq 2)`
`contains(a, b)`	String function	`contains(name, 'Contoso')`
`startswith(a, b)`	String function	`startswith(accountnumber, 'ACC')`
`endswith(a, b)`	String function	`endswith(telephone1, '00')`

Important Rule in Dataverse: Inside nested $expand clauses, nested parameters MUST be separated by semicolons (;), not ampersands (&). For example: $expand=primarycontactid($select=fullname;$filter=donotemail eq false).

Special Dataverse CRM Filter Functions

Microsoft Dataverse supports specialized CRM query functions prefixed with Microsoft.Dynamics.CRM.:

Function	Description	Example
`In(PropertyName='...',PropertyValues=[...])`	Match values in a set	`Microsoft.Dynamics.CRM.In(PropertyName='address1_city',PropertyValues=['Seattle','Chicago'])`
`Between(PropertyName='...',PropertyValues=[...])`	Match range between two values	`Microsoft.Dynamics.CRM.Between(PropertyName='revenue',PropertyValues=[10000,50000])`
`EqualUserId(PropertyName='...')`	Current logged-in user	`Microsoft.Dynamics.CRM.EqualUserId(PropertyName='ownerid')`
`Last7Days(PropertyName='...')`	Date in the last 7 days	`Microsoft.Dynamics.CRM.Last7Days(PropertyName='createdon')`
`ThisMonth(PropertyName='...')`	Date within current month	`Microsoft.Dynamics.CRM.ThisMonth(PropertyName='modifiedon')`
`NextXDays(PropertyName='...',PropertyValues=[14])`	Date in next X days	`Microsoft.Dynamics.CRM.NextXDays(PropertyName='scheduledend',PropertyValues=[14])`

FetchXML vs OData v4 Web API Quick Reference

FetchXML Element	OData v4 Web API Equivalent	Notes
`<entity name="account">`	`/api/data/v9.2/accounts`	OData uses the plural entity set name
`<attribute name="name" />`	`$select=name`	Comma-separated attribute list
`<filter type="and">`	`$filter=... and ...`	Logical expression
`<condition attribute="statecode" operator="eq" value="0" />`	`$filter=statecode eq 0`	Uses `eq`, `ne`, `gt`, etc.
`<link-entity name="contact" from="contactid" to="primarycontactid">`	`$expand=primarycontactid(...)`	Uses single-valued navigation property name
`<order attribute="name" descending="false" />`	`$orderby=name asc`	Sort direction: `asc` or `desc`
`<fetch count="50">`	`$top=50`	Limits returned records

OData WebAPI Tester executes queries directly within your authenticated browser session via native Single Sign-On (SSO) in a new tab. No passwords, client secrets, or bearer tokens are ever stored or transmitted to external servers. Your credentials never leave your browser.

Paste your raw OData query URL into the Request URI bar or type directly into the Code Editor. Click Beautify (or press Ctrl+Shift+F) to format query clauses across multiple indented lines with structured nested $expand relations.

Yes. Click the "Split" button on the toolbar. The Code Editor and Visual Clause Builder are displayed side-by-side with an interactive resizable divider. Any changes made in the visual builder immediately update the code editor, and edits in the code editor synchronize with the visual builder in real time.

Click "Code Gen" in the toolbar. Select "Power Automate" to view the exact values to paste into the Table Name, Select Columns, Filter Rows, Expand Query, and Sort By inputs of the "List rows" action. You can also select "Xrm.WebApi" for JavaScript, "C#", "cURL", "Fetch API", or "PowerShell".

Click the "Headers" button in the bottom panel and ensure Include Formatted Values is checked. This adds the HTTP header Prefer: odata.include-annotations="OData.Community.Display.V1.FormattedValue", instructing Dataverse to return human-readable text alongside numerical option set codes and GUIDs.

Yes! WebAPI Studio fully supports loading queries from external files and URL query parameters with full FetchXmlTester parity:

?load=<url> or ?url=<url> or ?file=<url>: Fetches and loads any remote OData query file (including raw GitHub links).
?query=<odata> or ?q=<odata>: Directly populates the editor from a URL-encoded query.
?env=<org_url>: Automatically connects to your specified Dataverse tenant.
?view=split: Opens directly in resizable split screen mode.
Open Local File: Click Open in the toolbar (or press Ctrl+O) to load any .odata, .txt, or .json file from your disk.
Share Link: Click Share in the toolbar to generate a one-click link containing your current query and environment.