Check for existence of system property

[Abhijit Das7]

Hi everyone, 

I have created around 6-7 custom system properties according to my business requirement. Now I am creating one Scripted rest api and I have to check whether these properties exist or not in this system. 

How can check whether the system properties exist or not with Scripted rest api.

cc; @Ankur Bawiskar 

Thanks in advance. 

[Gangadhar Ravi]

@Abhijit Das7 

To check if a property exists in ServiceNow using the REST API, you can use the following endpoint: "https://<your_instance>.service-now.com/api/now/table/sys_properties?sysparm_query=name=<property_name>"; where <your_instance> is your ServiceNow instance name and <property_name> is the name of the property you want to check

Please mark my answer correct and helpful if this works for you.

[Abhijit Das7]

Hi @Gangadhar Ravi 

My requirement is something like this that inside Scripted REST API (POST), I have to check whether these 6 properties exist using GlideRecord query or not. And if these exist then I will update these properties and if they doesn't exist then I have to return error message. 

Thanks in advance

[AshishKM]

Hi @Abhijit Das7 

Use the below code to check presence of any system property.

//This below code will update the given property value

var grSysProp = new GlideRecord("sys_properties");
grSysProp.addQuery("name", <property_name>); // change the correct propert name
grSysProp.query();
if(grSysProp.next()){
      grSysProp.value= "NewValue"; // update the new value here
      grSysProp.update();
} else {
      var erroMsg = "Property not exist";
}
// you can return the errorMsg variable in return response of REST Call

-Thanks,

AshishKM

[Ankur Bawiskar]

@Abhijit Das7 

what's the business requirement for this?

what did you try so far and what didn't work?