Update system property with Scripted Rest API ( POST)

[Abhijit Das7]

Hi Everyone,

I have created one Scripted Rest API (POST) to update values of two system property. But when I am testing this API from Rest API explorer it is not working , system properties are not getting updated . Can anyone help me in correcting my mistake. 

Scripted Rest API :

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

var requestBody = request.body.dataString;
var parser = new global.JSON();
var parsedData = parser.decode(requestBody);
var tenantId = parsedData.tenant_id;
var tenantName = parsedData.tenant_name;

if(tenantId){
var rec1 = new GlideRecord("sys_properties");
rec1.addQuery("name", "name_of_the_system_property1");
rec1.query();
if (rec1.next()){
rec1.value = tenantId ;
rec1.update;
}

}

if(tenantName ){
var rec2 = new GlideRecord("sys_properties");
rec2.addQuery("name", "name_of_the_system_property2");
rec2.query();
if (rec2.next()){
rec2.value = tenantName ;
rec2.update;
}

}

})(request, response);

cc: @Ankur Bawiskar @kamlesh kjmar @Community Alums 

Thanks in advance

[Community Alums]

Hi @Abhijit Das7 ,

what's the error you're getting?

[Abhijit Das7]

Hi @Community Alums 

I am not getting any error it is just that system properties are not updating. 

I am sending data like this:

But system properties are not updating. I cannot see the values.

Thanks

[Ankur Bawiskar]

@Abhijit Das7 

don't use decode method

try this and check what comes in system logs

Also I assume you are sending the request body in this format

{

"tenant_id":"hello",

"tenant_name":"bye"

}

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

var requestBody = request.body.dataString;
var parsedData = JSON.parse(requestBody);
var tenantId = parsedData.tenant_id;
var tenantName = parsedData.tenant_name;

gs.info("Tenant ID" + tenantId);
gs.info("Tenant Name" + tenantName);

if(tenantId){
var rec1 = new GlideRecord("sys_properties");
rec1.addQuery("name", "name_of_the_system_property1");
rec1.query();
if (rec1.next()){
rec1.value = tenantId ;
rec1.update;
}

}

if(tenantName ){
var rec2 = new GlideRecord("sys_properties");
rec2.addQuery("name", "name_of_the_system_property2");
rec2.query();
if (rec2.next()){
rec2.value = tenantName ;
rec2.update;
}

}

})(request, response);

[Abhijit Das7]

Hi @Ankur Bawiskar 

Even after your suggestion, system property value is not updating. I am able to see gs.info values in logs.

I am using this scripted rest api :

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

var requestBody = request.body.dataString;

var parsedData = JSON.parse(requestBody);

var tenantId = parsedData.tenant_id;

var tenantName = parsedData.tenant_name;

gs.info("Tenant ID" + tenantId);

gs.info("Tenant Name" + tenantName);

if(tenantId){

var rec1 = new GlideRecord("sys_properties");

rec1.addQuery("name", "x_care3_spoke.save.tenantId");

rec1.query();

if (rec1.next()){

rec1.value = tenantId ;

rec1.update;

}

}

if(tenantName ){

var rec2 = new GlideRecord("sys_properties");

rec2.addQuery("name", "x_care3_spoke.save.tenantName");

rec2.query();

if (rec2.next()){

rec2.value = tenantName ;

rec2.update;

}

}

})(request, response);

Sending value like this : 

Thanks