Tool Link: https://www.ashishvishwakarma.com/FetchXmlTester/
FetchXML Tester Online is a client-side developer tool for Microsoft Dataverse & Dynamics 365 to test, format, and execute FetchXML queries directly in your browser using native WebAPI GET requests without sharing or storing credentials.
- FetchXML Syntax Highlighting: Clean syntax styling with XML tag, attribute, and value formatting.
- Zero-Credential Execution: Executes queries directly against your active Microsoft Dataverse / Dynamics 365 session via native browser Single Sign-On (SSO).
- Smart Entity Pluralization: Automatically identifies the entity name from
<entity name='...'>and suggests the matching Dataverse Web API entity collection set name. - Environment Context Studio: Save and switch between multiple Dataverse environments with shared local storage parity (
lsOrgURLsandqdv_active_env). - Inbuilt XML Beautifier & Formatter: Clean, indent, and format FetchXML with a single click or keyboard shortcut.
- URL Querystring Deep-Linking & File Loading: Load remote query files, inline FetchXML, or full Web API URLs via URL parameters.
- One-Click Sharable Deep Links: Share any query, environment, and friendly name with a single click (
Ctrl+Shift+S). - Saved Queries Library: Persist frequently used queries in browser local storage with instant search, load, and JSON export.
- Local File Loading & Download: Open
.xmlor.txtfiles from disk (Ctrl+O) and export queries. - Dark & Light Mode: Seamless theme switching with persistent preferences.
FetchXML Tester features URL query string loading capabilities with complete parity to WebAPI Tester Studio, enabling query sharing, automated documentation links, and remote file loading directly into the tester.
| Parameter | Example | Behavior |
|---|---|---|
?load= / ?url= / ?file= / ?src= |
?load=https://example.com/query.xml?load=sample.xml |
Fetches any public FetchXML query file (including relative paths). Automatically extracts query name from filename and formats the query into the editor. |
?query= / ?q= / ?fetchxml= / ?xml= |
?query=%3Cfetch%20mapping%3D%27logical%27%3E...%3C%2Ffetch%3E |
Directly populates the editor from a URL-encoded FetchXML string OR a full Dataverse Web API request URL (e.g. https://org.crm.dynamics.com/api/data/v9.2/accounts?fetchXml=...). When a Web API URL is provided, the environment and plural collection are automatically detected and configured. |
?env= / ?org= |
?env=https://contoso.crm.dynamics.com |
Automatically connects to and activates the specified Dataverse tenant in the Environment Manager. |
?name= / ?title= |
?name=Active%20Accounts |
Sets the query title and updates the browser tab title (fX: <name>). |
?plural= / ?entity= |
?plural=accounts |
Explicitly preconfigures the entity plural collection name. |
If a GitHub repository link is passed (e.g. https://github.com/user/repo/blob/main/query.xml or raw link / Gist), FetchXML Tester automatically transforms it to https://raw.githubusercontent.com/user/repo/main/query.xml for direct, CORS-friendly client-side loading.
Click the Share button on the toolbar (or press Ctrl+Shift+S) to generate an all-inclusive deep link that preserves:
- Current FetchXML query (
query) - Connected Dataverse organization (
env) - Query name and description (
name) - Entity plural name (
plural)
Example generated shareable link:
https://www.ashishvishwakarma.com/FetchXmlTester/?query=%3Cfetch%20mapping%3D%27logical%27%3E%3Centity%20name%3D%27account%27%3E%3Cattribute%20name%3D%27name%27%2F%3E%3C%2Fentity%3E%3C%2Ffetch%3E&env=https%3A%2F%2Fcontoso.crm.dynamics.com&name=Active%20Accounts&plural=accounts
Click the Open File button on the toolbar (or press Ctrl+O) to pick and load any local .xml or .txt FetchXML query file from your computer.
| Shortcut | Action |
|---|---|
Ctrl / Cmd + Enter |
Test FetchXML: Execute query against active Dataverse environment |
Ctrl / Cmd + Shift + S |
Share Link: Copy one-click sharable URL with query, environment & name |
Ctrl / Cmd + Shift + F / Alt + Shift + F |
Beautify: Format and indent FetchXML |
Ctrl / Cmd + S |
Save to Library: Save current query to local browser library |
Ctrl / Cmd + O |
Open File: Load FetchXML query from local file |
Ctrl / Cmd + K |
Environment Manager: Open Environment Context Studio |
Escape |
Close any active modal dialog |
This tool runs 100% client-side. All processing (parsing, validation, formatting, and storage) happens locally in your browser. Queries are executed directly against your Dataverse instance using your browser's existing authenticated session. No credentials or data are sent to any external server or third-party proxy.
- Recommended extension: JSON Viewer PRO for formatting raw Dataverse JSON responses.
- Dynamics 365 Web API Concept: How FetchXML works with Web API GET calls
- Companion OData Studio: WebAPI Tester Studio
MIT License © Ashish Vishwakarma