Multi Row variable set values store in an object

[pawan2]

Hi All,

Hope you are all well!. I need your valuable thought about how to store multi row variable values in an object. Currently I'm developing a rest API GET method to retrieve data from ServiceNow. Below is the high-level scripted REST API GET method I'm developing. However I could retrieve variable values, But I'm getting undefined error when I trying to retrieve multi row variable set values. Appreciate your help here.

var g = new GlideRecord('sc_task');

g.get(SYS_ID OF THE SCTASK);

scTask.query();

while(g.next()) {

var obj = {};

obj.app= obj.application_name= g.variables.app_id.getDisplayValue();//working fine

obj.account= g.variables.account.toString();//working fine

obj.multiCategory=g.variables.multiRowVariableSet1.user_name; // This part is not working. Multi row variable set name is multiRowVariableSet1 and the variable name is user_name. I need to store this multi row variable values in the same obj I've created here.

result.push(obj);

Thanks & Regards,

Pawan

[pawan2]

Hi Hitoshi,

Thanks for the response and I really appreciate your support. But still this script return undefined unfortunately. Appreciate if you could help me to get these values into the object.

Thanks in advance,

Pawan

[Hitoshi Ozawa]

Following should set obj.multiCategory with comma separated user_name from mrvs.

var g = new GlideRecord('sc_task');
if (gr.get(<SYS_ID OF THE SCTASK>)) {
  var requestItem= gr.request_item;  // get request item for the task
  var mrvs = requestItem.variables.multiRowVariableSet1;

  // to get content of mrvs
  var jsonObj = JSON.parse(mrvs);
  var userList = [];
  for (var i=0; i< jsonObj.length; i++) {
    userList.push((jsonObj[i].user_name.toString());
  }
  var obj = {};
  obj.app= obj.application_name= g.variables.app_id.getDisplayValue();//working fine
  obj.account= g.variables.account.toString();//working fine
  obj.multiCategory=userList.join(',');
  result.push(obj);
}

[pawan2]

Hi Hitoshi.

Thanks for the prompt response. Much appreciated. Can we try this in a background script. Cause when I add this part userList.push(jsonObj[i].user_name.toString()); It will return an error. If I remove this part and run, It will return values continuesly as a word without comma separator. Appreciate your further assistance.

Thanks in advance.

[pawan2]

Can we test this in a background script? When I try below in background script, It returns [object object instead of values. Not sure I've done a mistake here. Appreciate your help.

var gr = new GlideRecord('sc_task');

if (gr.get('sys_id')) {

var requestItem= gr.request_item;  // get request item for the task

var mrvs = requestItem.variables.multiRowVariableSet1; // to get content of mrvs

var jsonObj = JSON.parse(mrvs);

var userList = [];

for (var i=0; i< jsonObj.length; i++) { userList.push(jsonObj[i].user_name.toString());

}

var obj = {};

obj.multiCategory=userList.join(',');

gs.print(obj);

}

[Hitoshi Ozawa]

The problem was with the name of the mrvs. ServiceNow converts to all lowercase.

var result = [];
var gr = new GlideRecord('sc_task');
if (gr.get('ee3c63e99739011086d3b4b3f153af2c')) {
  var requestItem= gr.request_item;  // get request item for the task
  var mrvs = requestItem.variables.multirowvariableset1;

  // to get content of mrvs
  var jsonObj = JSON.parse(mrvs);
  var userList = [];
  for (var i=0; i< jsonObj.length; i++) {
    userList.push(jsonObj[i].user_name.toString());
  }
  var obj = {};
  //obj.app= obj.application_name= gr.variables.app_id.getDisplayValue();//working fine
  //obj.account= gr.variables.account.toString();//working fine
  obj.multiCategory = userList.join(',').toString();
  //gs.info('obj:' + obj.multiCategory);

  result.push(obj);
  gs.info(result[0].multiCategory);
}

Execution result:

*** Script: test user 1,test user 2

This is my variables in RITM.