This article describes the interface that is used to create Test Data. Test Data is stored as a Dynamics record and are edited via a specially adapted form.

Test Data is added to a Solution to allow for easy transport between Dynamics instances.

Configuration pane

Register tab


The name of the Test Data record. On create it is automatically populated but can be renamed at any time. The name will be used for selecting Test Data from within the Global Data node of a Test Record. Ensure that you define a name that accurately describes the data in your Test Data record.

Solution Deployment

Select the unmanaged Dynamics solution to associate the Test Data for deployment. The Test Data is added as a XML web resource to the selected solution to allow for easy transport between Dynamics instances. 

Category and Sub-Category 

The purpose of these fields is to allow you to add metadata about the Test Data which can be used for grouping and sorting in list views. 

Functions tab

If you need to manipulate data when it is being created you can use the power of over 450 functions. For example, to add a random number to a field you can use the Random() function. Search and select functions from this tab.

Source tab

From the Source tab you can reference xCache records, Global Calculations, Global Actions, Decision Table Calculations and Local Data (data within Test Data sheets on the current record).

Explore tab

Explore System Data

Data can be automatically added to the Test Data record in two ways:

  1. By selecting individual records - select an entity, refine the returned records results using the search, then select the record(s) and click the lightning bolt button
  2. By using FetchXML queries - define the FetchXML queries on the Global Calculations sheet, then select DP FetchXml Queries from the Explore System Data drop down list, select the desired FetchXML queries and and click the lightning bolt button. This will add the data from all records returned by the FetchXML query to the selected Sheet.

Explore Data Model

Expand the Explore Data Model section to search for specific entities. Expand the Entities node, then an Entity to show all the attributes.

Fetch-Xml tab

The Fetch-Xml tab shows any FetchXML queries defined on the Global FetchXML sheet.

Test Data editor pane

Default Sheets

There are four default Sheets when a Test is created: Data, Global Calculations, Global Actions and Global FetchXML.


This is a placeholder sheet which gets replaced when you add the first entity of data to the Test Data.

Global Calculations

The Global Calculations sheet lets you define configuration settings which determine how data is automatically added to the Test Data sheets.

Global Actions

Global Actions are currently not used for Test Data.

Global FetchXml

The Global FetchXml sheet is used to define FetchXml queries that can be used for adding data to the Test Data record.

Command bar


This menu provides quick access to the allowed Operators that can be used within formulas.


Selecting a Snippet adds pre-configured examples of functions/sheets to the Test Data.


Select from options to perform the selected command.

Syntax Check button

Validates the structure of the Test Data is correct. 

Clear button

Clears the contents of the selected cell.

Search and Replace button

Toggles the Search and Replace fly out pane.

Execute button

Currently has no effect for Test Data.

Function Wizard button

Toggles the Function Wizard pane open/closed.

N52 Commands 

In the command bar for the Test Data form there is a menu option called N52 Commands with two options:

Clone Test Data

Creates a copy of the Test Data record. After the clone has completed, the copied Test Data record is available in the Test Data list with a prefix :: added to the current Test Data's name. 

Open Configuration

Opens the North52 Configuration record.