2022.2

For a quick start, turn to this How-to: Interacting with the Data Repository API.
Caution: All operations on the Repository must be performed through this API - rather than dir-
ectly accessing the physical file - since the Repository's underlying file structure may change
over time. This API is guaranteed to remain compatible with future versions of the Data Repos-
itory. It is used by all Workflow tasks dealing with the Repository.
Data repository structure
The table below lists the different levels in the repository and what their names corresponds to:
The term ... ... is the same as an Excel ... ... is the same as a Database ...
Group Sheet Table
Key Column Field
KeySet Row Record
Note: Group and key names are case-insensitive.
API Reference
Obtaining an instance of the Repository Object
The Data Repository is accessed via a COM object that exposes methods to store and retrieve data
within the Repository.
JavaScript
var repoObject = new ActiveXObject("RepositoryLib.WorkflowRepository");
VB Script
set repoObject = CreateObject("RepositoryLib.WorkflowRepository")
In each example in this documentation, the object repoObject is deemed having been obtained
through the above call to the COM object.
The default Repository is always stored at the same location (see "Where to find the Data Repository"
on page82).
The ConnectionString property allows to create an instance of the Repository at another location;
see "ConnectionString" on page82.
Using a JSON parameter or return value
Whenever a parameter or return value is defined as a JSONStringArray type, that JSON array is itself a
string. Since a JSON array internally defines double quotes as the delimiter for each element, you must
Page 147