FetchXML Studio — User Guide

Overview

FetchXML Studio is a full-featured query editor for Dataverse FetchXML. Write or build queries visually, execute them with pagination support, view results in a sortable table, and export to CSV, Excel, or JSON.

Prerequisites

• An active connection to a Dataverse environment
• Read access to the tables you intend to query

Getting Started

1. Select FetchXML Studio from the sidebar
2. The editor opens ready for input — the current environment is shown in the header

Interface Layout

Workflow

1. Write or Build a Query

Manual editing:

Type or paste FetchXML directly into the editor. Example:

<fetch top="50">
  <entity name="account">
    <attribute name="name" />
    <attribute name="emailaddress1" />
    <filter>
      <condition attribute="statecode" operator="eq" value="0" />
    </filter>
  </entity>
</fetch>

Visual builder tab:

Switch to the Builder tab to construct queries without writing XML:

1. Select an entity from the dropdown
2. Check the fields to include
3. Add filter conditions using the condition builder
4. Switch back to the XML tab to review or fine-tune the generated FetchXML

2. Format the XML

Click Format or press Alt+Shift+F to auto-indent and pretty-print the XML. Formatting also validates the XML — malformed XML will be highlighted.

3. Run the Query

Click Run Query or press Ctrl+Enter.

• Queries are automatically paginated — up to 5,000 rows are fetched
• Execution time (ms) and row count are displayed above the results table
• A warning banner appears when results are truncated at the 5,000 row limit

4. Work with Results

Note: The table displays the first 500 rows. Use Export to access all fetched rows.

5. Export

Select a format and click Export:

6. Query History

Click Recent to see the last 10 queries run against this environment. Each entry shows the entity name, row count, and how long ago it was run. Click an entry to load it back into the editor.

Keyboard Shortcuts

Tips

Troubleshooting