You can use the REST API to pull data from any table.

variables are actually called "Options" once they have a value assigned and are stored in the Options table [sc_item_option].   The table called "Variables" ([item_option_new]) only stores the definition of that variable (i.e., it's type, associated question, hint, etc.).   So the Options table is where you want to look at for your actual values.

To get to the Options you are looking for, you will need to look at a Many-to-Many table [sc_item_option_mtom] relating your Requested Items to their Options.   You should have RITM sys_id and then use below:

A.you would query [sc_item_option_mtom] to get a list of the Options (your variables) that belong to it.

B)you can use that list of option sys_id's to query [sc_item_option] for the values you are after.

Regards,

Sachin

Hi,

please share your script

MRVS value is stored in json format

Regards
Ankur

Hi ursnani,

This line actually gives you access to variables

//Get the object containing the catalog variables.
        ritmVariables = grRitm.variables;

//If you want to access variables which are MRVS, then use the below code

mrvs = ritmGR.variables.variable_set_name;
var rowCount = mrvs.getRowCount();
for (var i = 0; i < rowCount; i++) {
	var row = mrvs.getRow(i);
	var var1 = row.your_var_name;
	var var2 = row.your_var_name2;
}

Ref: https://community.servicenow.com/community?id=community_blog&sys_id=865b5aeddbc023c0feb1a851ca9619f9

Kindly mark the comment as a correct answer and helpful if it helps to solve your problem.

Regards,
Asif
2020 ServiceNow Community MVP

Hi Asif,

Thanks for the code and It almost worked. But its returning only the last row in the object. but not not all the rows. here is the code I using. Can you please let me know where to modify so that I can get all the rows instead of only last row in mrvs.

var mrvs = grRitm.variables.test_copy;
var rowCount = mrvs.getRowCount();
gs.log('Naveen ' +mrvs+'Rows == '+rowCount);
for (var j = 0; j < rowCount; j++) {
var row = mrvs.getRow(j);
var var1 = row.test_1;
var var2 = row.test_2;
responseObj ={
"test_1":row.test_1,
"test_2":row.test_2,
};
}
}

gs.log('FInal OBJ == '+responseObj);

return responseObj;

When I print responseObj its giving an output as below in postman.

{
"result": {
"test_1": "Haridasu",
"test_2": "Naveen"
}
}

and When I print 'mrvs' its giving me all the rows and values in an array as below.

Naveen [ {
"test_1" : "10",
"test_2" : "20"
}, {
"test_1" : "30",
"test_2" : "40"
}, {
"test_1" : "44",
"test_2" : "45"
}, {
"test_1" : "kumar",
"test_2" : "Test"
} ]

Rows == 4

When I return mrvs, it theowing an error cannot map object as mrvs is an array.

Can please help in getting all the rows on the object that is returned.

Thanks,

Naveen.