Sla conditions state value

[BHARATHS]

Need to set an state value dynamically from sys_choice list based selecting table, please helpt to write an scripted rest api

[Prathmeshdagade · Accepted solution]

Hello @BHARATHS 
scripted rest api

(function process(request,  response) {

try {
var body = request.body.data;

var tableName = body.table;
var recordSysId = body.sys_id;
var fieldName = body.field; // e.g. "state"
var choiceLabel = body.choice_label;

if (!tableName || !recordSysId || !fieldName || !choiceLabel) {
response.setStatus(400);
response.setBody({
status: "error",
message: "Missing required parameters"
});
return;
}
var choiceGR = new GlideRecord("sys_choice");
choiceGR.addQuery("name", tableName);
choiceGR.addQuery("element", fieldName);
choiceGR.addQuery("label", choiceLabel);
choiceGR.addQuery("inactive", false);
choiceGR.query();

if (!choiceGR.next()) {
response.setStatus(404);
response.setBody({
status: "error",
message: "Choice not found for given table and field"
});
return;
}

var choiceValue = choiceGR.getValue("value");
var targetGR = new GlideRecord(tableName);
if (!targetGR.get(recordSysId)) {
response.setStatus(404);
response.setBody({
status: "error",
message: "Record not found"
});
return;
}

targetGR.setValue(fieldName, choiceValue);
targetGR.update();
response.setStatus(200);
response.setBody({
status: "success",
table: tableName,
field: fieldName,
label: choiceLabel,
value: choiceValue
});

} catch (ex) {
response.setStatus(500);
response.setBody({
status: "error",
message: ex.message
});
}

})(request, response);

sys_choice table   : Stores choice list values for fields like state, priority, etc.

If this response proves useful, please mark it as Accept as Solution and Helpful. Doing so benefits both the community and me. 👍🙂

[Dr Atul G- LNG]

Hi @BHARATHS 

You are creating technical debt by using a script. It’s better to use the OOTB SLA definition and build it that way—it will be easier to implement and maintain.