AddKeySets

Inserts a new keyset inside GroupName and assigns values to keys as specified in KeyValues. Every key specified in KeyValues must exist otherwise an error is raised. However, it is not required to specify all available keys in KeyValues. Only the keys specified are updated in GroupName while unspecified keys are set to an empty string.

Syntax

AddKeySets(GroupName: string, KeyValues: JSONObjectArray): JSONIntegerArray

Examples

Basic examples

In each of these examples, the object repoObject is deemed having been obtained through a call to the COM object "RepositoryLib.WorkflowRepository" (see Obtaining an instance of the Repository Object).

JavaScript​

repoObject.AddKeySets("Users", '[{"FirstName": "John","LastName": "Smith"},{"FirstName": "Richard", "LastName": "Doe"}]');

VB Script​​​

repoObject.AddKeySets "Users","[{""FirstName"":""John"",""LastName"":""Smith""},{""FirstName"":""Richard"",""LastName"": ""Doe""}]"

Inserting a row

In most cases, you won't need to insert or update a row in a script, as this can be easily done through the the Push to Repository action task. However, in some cases you might want to script it for simplicity's sake.
This JavaScript example inserts 2 different rows into the Users group.

var repoObject = new ActiveXObject("RepositoryLib.WorkflowRepository");
repoObject.AddKeySets("customers", '[{"CustomerID": "CUJS123456", "FirstName": "John","LastName": "Smith"},
{"CustomerID": "CURD654321", "FirstName": "Richard", "LastName": "Doe"}]');

Tip: to update a row instead of adding it, use the GetValue() function to get the KeySet ID; then update each individual value using SetValueByID() (see GetValue and SetValueByID).

Sample return value

The method returns a JSONIntegerArray containing the ID's of all keysets inserted into GroupName:

'[131,132]'