how to retrieve the RITM variables using the Rest API's

[rajasekahr]

Is there any easy way to get the ritm variables along with Ritm fields .please suggest if any body come across .

sysparm_display_value=true&sysparm_fields=number,sys_created_by,variables.one,variables.two

but this needs manualy to add all the variables and fields from it.

[RAHUL YADAV9]

Don't mention this in URL and that will return you all the fields available in the RITM. If you want to get only specific fields then you can create a scripted REST API and you can show only fields that you want to send in response.

Please mark correct and helpful if this helps.

[rajasekahr]

as per my understanding if they give our url they will access our ritm record variables.

scripted rest api do you have sample codes how to get the ritm variables, i had tried some things in community it was not working properly.

[Hitoshi Ozawa · Accepted solution]

Hi Rajasekahr,

Create a Scripted REST API.

1. Select "System Web Services" > "Scripted Web Servcies" > "Scripted REST APIs" from Application Navigator. 
   
2. Select "Query Parameter" and add a mandatory parameter "number" to accept ritm number to get values.
   
3. Select "Resources" tab and create a GET method.
   

Script

(function process( /*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) {
    var queryParams = request.queryParams;
    var number = queryParams.number.toString();

    var grRitm = new GlideRecord('sc_req_item');
    grRitm.addQuery('number', number);
    grRitm.query();
    if (grRitm.next()) {
        // get field values
        var fields = grRitm.getFields();
        var ritmFields = {};
        for (var i = 0; i < fields.size(); i++) {
            var glideElement = fields.get(i);
            if (glideElement.hasValue()) {
                ritmFields[glideElement.getName().toString()] = glideElement.toString();
            }
        }
        // get variables
        var grVar = new GlideRecord('sc_item_option_mtom');
        grVar.addQuery('request_item', grRitm.sys_id);
        grVar.query();
		var varList = [];
        if (grVar.hasNext()) {
            while (grVar.next()) {
                var fieldName = grVar.sc_item_option.item_option_new.name.toString();
                var type = grVar.sc_item_option.item_option_new.type.toString();
                var value = grVar.sc_item_option.value.toString();
                varList.push({
                    'name': fieldName,
                    'type': type,
                    'value': value
                });
            }
			ritmFields['variables'] = varList;
        }
        return ritmFields;
    } else {
		response.setError(new sn_ws_err.NotFoundError('specified ritm was not found.')); // error - record not found
	}


})(request, response);

[rajasekahr]

Thanks for your response it is working for single RITM

Please suggest it is possible to pass multiple ritm's number or any filter based on filter we can able to fecth multiple RITM numbers?