Hi All,
Finally, I had to add small utility which can handle reference variables in REST API request for all catalog Items.
Here is script Include to run for BG:
var variables = {"user":"Abraham Lincoln","company":"Yahoo!","comments":"This is testing Text","requested_for":"System Administrator","needed_by":"Today"};
var itemId = "b5c3c1084f10330005ec00fe9310c7eb"; //myTestItem Catalog item
for(var key in variables)
{
if(variables.hasOwnProperty(key) && variables[key] && typeof(variables[key]) !== 'string')
variables[key]=variables[key].toString();
var varGr = new GlideRecord('item_option_new');
var qr = varGr.addQuery('cat_item', itemId);
var variableSet = new sn_sc.CatItem(itemId).getVariableSet();
if(variableSet.length > 0)
qr.addOrCondition("variable_set", variableSet);
varGr.addActiveQuery();
// varGr.addQuery('mandatory', true);
varGr.query();
// gs.print(variable[key] + ':' + varGr.reference);
while(varGr.next()) {
if(varGr.type == 8)
{
var objTable = new TableUtils(varGr.reference);
tableName = objTable.getAbsoluteBase();
gs.print(objTable.getAbsoluteBase());
if (tableName!='task') //Check if parent table is task
gQuery = 'name='+variables[key]; else gQuery = 'number='+variables[key];
var tb = new GlideRecord(tableName);
gs.print(varGr.reference);
tb.addQuery(gQuery);
tb.query();
if(tb.next())
{
variables[key]=tb.getValue('sys_id');
}
}else { variables[key]=variables[key]; }
}
}gs.print(JSON.stringify(variables));
