How to get the list(array) request item numbers according to the item name in sc_req_item

[Bowen Lu]

Hi I want to how to write the scripted REST API to get the list numbers of request items.

Expect output:

requestItems = ["RITM12345", "RITM23456"]

query param = "title example"

Thanks in advance.

 

[Ankur Bawiskar]

Hi,

can you share what the incoming request/endpoint will look like and what script did you try so far?

[Bowen Lu]

yes , thanks.

I add the code in the question description.

[Ankur Bawiskar · Accepted solution]

script will look like this

(function process(/*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) {

	try {
		var arr = [];
		var itemName = request.pathParams.itemname;
		var ritm = new GlideRecord("sc_req_item");
		ritm.addQuery("cat_item.name", itemName);
		ritm.setLimit(2);
		ritm.query();
		while(ritm.next()) {
			arr.push(ritm.getValue('number'));	
		}
		var responseBody = {};
		responseBody.data = arr;
		responseBody.status = "Success";
		response.setBody(responseBody);
	}
	catch (ex) {
		var message = ex.message;
	}

})(request, response);

[Bowen Lu]

thanks, it worked.

 > ritm.getValue('number')

 helped me.