Thanks everyone. I have created Scripted Rest API for my requirements, and it works perfectly. Now I can fully control all the fields through script.
I am adding my code here in case if anyone want to take advantage.
(function process(/*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) {
var reqbody = request.body.dataString;
try {
var parser = new global.JSON();
var parsedData = parser.decode(reqbody);
var FirstName = parsedData.v_person_leaving_fn;
var linemanager = parsedData.v_line_manager;
var SurName = parsedData.v_person_leaving_sn;
var Dateleaving = parsedData.v_date_leaving;
var EmpType = parsedData.v_offboarding_employment_type;
// Log the parsed data
gs.log("Parsed Data: " + JSON.stringify(parsedData));
var cartId = GlideGuid.generate(null);
var cart = new Cart(cartId);
// Query the sys_user table to get the requested for user details
var grUser = new GlideRecord('sys_user');
//grUser.addQuery('user_name', linemanager); // Assuming linemanager is the username
grUser.addQuery('name', linemanager); // Assuming linemanager is the username
grUser.query();
if (grUser.next()) {
var linemanagerSysId = grUser.sys_id.toString(); // Get the sys_id of the user
}
var item = cart.addItem('ca9a27141bbcc2102a2eedb7b04bcb0f', 1);
// Set the variables on the request item form
cart.setVariable(item, "v_person_leaving_fn", FirstName);
cart.setVariable(item, "v_person_leaving_sn", SurName);
cart.setVariable(item, "v_line_manager", linemanagerSysId); // Set the sys_id of the user
cart.setVariable(item, "v_date_leaving", Dateleaving);
cart.setVariable(item, "v_offboarding_employment_type", EmpType);
var rc = cart.placeOrder();
var reqNumber = rc.number;
// Update the "Requested For" field on the REQ record
var reqRecord = new GlideRecord('sc_request');
if (reqRecord.get('number', reqNumber)) {
reqRecord.setValue('requested_for', linemanagerSysId); // Set the sys_id of the user
reqRecord.update();
}
// Log the request number
gs.log("Request Number: " + reqNumber);
// Fetch the RITM number for response
var ritm = new GlideRecord('sc_req_item');
ritm.get('request.number', reqNumber);
var ritmNumber = ritm.number;
gs.info("RITM Number: " + ritmNumber);
//gs.log("Test"); // Add any additional logging here if needed
var res = {};
res["status"] = "Success";
res["requestNumber"] = reqNumber;
res["requestItemNumber"] = ritmNumber;
response.setBody(res);
} catch (ex) {
// Log any errors
gs.error("Error: " + ex.message);
var res = {};
res["status"] = "Error";
res["message"] = ex.message;
response.setBody(JSON.stringify(res));
response.setStatus(500);
}
})(request, response);
Jason data format:
{
//"sysparm_id": "ca9a27141bbcc2102a2eedb7b04bcb0f",
"sysparm_quantity": "1",
"v_line_manager": "Damien Reed",
"v_person_leaving_fn": "Andy",
"v_person_leaving_sn": "Rock",
"v_offboarding_employment_type" : "operations",
"v_date_leaving": "2024-03-06"
}
