GENERATE_JSM_OBJECT_ARRAY Function

This function is only supported for ServiceNow -> Jira, Salesforce -> Jira or Cherwell  -> Jira migrations.

ServiceNow and Cherwell

Parameters (String, String);

Returns: String;

Its intended use is to construct an array of Keys or IDs of assets in Jira that can then be related to an issue or another asset, based on the relationships in the source ServiceNow or Cherwell server. 

The first parameter is the name of the attribute on the Jira object type that contains the source identifier value from the source record.

The second parameter is the attribute value itself.  

Example:

GENERATE_JSM_OBJECT_ARRAY('Source Id',[sys_id])

NOTE: The function should be used in an update of existing Issues or assets, not when creating new. Jira does not support the addition of relationships to assets when creating issues and relationships between assets will only be successful when all the assets have already been created beforehand.

Salesforce

When migrating from a Salesforce environment, you must provide an additional three parameters.

Parameters (String, String, String, String, String);

Returns: String;

The first and second parameters are the same as above. 

The third parameter is the name of the Salesforce object (table) to obtain the relationship to the current record being migrated.

The fourth parameter is the name of the field on the Salesforce object that stores the id of the current record.

The fifth parameter is the name of the field on the Salesforce object that stores the related record id.

Example:

GENERATE_JSM_OBJECT_ARRAY('Salesforce ID',[Id],'Parent_Child_Relationship__c','Parent__c','Child__c')