1. Web Services Integration – ServiceNow
  2. What is integration?
  3. Type of Integration
  4. Basic Requirements for Integrate any system
  5. Integration Testing Tools
  6. Integration Module
  7. Inbound Integration
  8. SOAP VS REST API
  9. Table API Web Service – REST
  10. Direct web services – SOAP
  11. Import Set Web Service – SOAP
  12. Import Set API – REST
  13. Scripted Web Services – SOAP
  14. Scripted Web Services – REST
  15. SOAP Message – Outbound
  16. REST Message – Outbound
  17. ServiceNow to ServiceNow Incident Integration
  18. OAuth 2.0 Authentication
  19. ServiceNow – OAuth application connect
  20. Access Token VS Refresh Token

Scripted Web Services – SOAP

Using Scripted Web Service we can put the custom scripts and validate a lot of things.

We can query multiple tables and work on this.

Scenario 1: Need Get Group Information, Group Members & Associated roles attached to group.

In this scenario, we need to call multiple tables across the platform which is not possible through simple API so we need to go for Scripted SOAP Web Services.

Create Input parameter form to take input from third party & Output Parameter used to send data from ServiceNow to third-party.

In the script, we can use request.parameter to access that parameter value and response.parameter used to send the response to third-party.

(function scriptedWebServiceOperation(request, response) {

    // Add your code here
    var grp = request.group_name;
    var gr = new GlideRecord('sys_user_group');
    if (gr.get('name', grp)) {
        response.group_name = gr.name;
        response.group_manager = gr.manager.name;
        response.group_email = gr.email;
        response.Results = "Group " + grp + " is found in servicenow";
        response.Users = getUsers(gr.sys_id);
        response.Role = getRoles(gr.sys_id);
    } else {
        response.Results = "Group " + grp + " not found in servicenow";
    }

    function getUsers(grId) {
        var users = "";
        var grm = new GlideRecord('sys_user_grmember');
        grm.addQuery('group', grId);
        grm.query();
        while (grm.next()) {
            if (users) {
                users = users + ',' + grm.user.name;
            } else {
                users = grm.user.name;
            }
        }
        return users;
    }

    function getRoles(grId) {
        var roles = "";
        var grrl = new GlideRecord('sys_group_has_role');
        grrl.addQuery('group', grId);
        grrl.query();
        while (grrl.next()) {
            if (roles) {
                roles = roles + ',' + grrl.role.name;
            } else {
                roles = grrl.role.name;
            }
        }
        return roles;
    }
})(request, response);

Scenario 2:

Create a Scripted SOAP Message for Create a Incident with below validation:

  • Need to create an incident so that impact & Urgency can’t be selected High.
  • Only deploy CI can be passed as a CI.
  • Category & Sub-Category Dependency should be there.
(function scriptedWebServiceOperation(request, response) {

    // Add your code here
    var v1 = mandatoryValidation();
    if (v1 == true) {
		var grInc = new GlideRecord('incident');
		grInc.initialize();
		grInc.caller_id = request.Caller_ID;
		grInc.short_description = request.Short_Description;
		var grci1 = new GlideRecord('cmdb_ci');
		grci1.get('name',request.CI);
		grInc.cmdb_ci = grci1.sys_id;
		if(request.Impact){
			grInc.impact = request.Impact;
		}
		if(request.Urgency){
			grInc.urgency = request.Urgency;
		}
		grInc.insert();
		response.Result = "Incident Created";
		response.sys_id=grInc.sys_id;
		response.Number = grInc.number;
    } else {
        response.Result = v1;
    }

    function mandatoryValidation() {
        if (request.Caller_ID) {
            if (request.CI) {
                var grci = new GlideRecord('cmdb_ci');
                grci.addQuery('name', request.CI);
                grci.addQuery('operational_status', 1);
                grci.query();
                if (grci.next()) {
                    if (request.Short_Description) {
						if(request.Impact && request.Impact == 1){
							return "Impact can't be 1";
						}else{
							if(request.Urgency && request.Urgency == 1){
								return "Urgency can't be 1";
							}else{
								return true;
							}
						}
                    } else {
                        return "Short Description can't be blank";
                    }
                } else {
                    return "CI may be not found or not in operatonal";
                }
            } else {
                return "CI Can't be blank";
            }
        } else {
            return "Caller Id Can't be blank";
        }
    }

})(request, response);

Total Views: 1367

No responses yet

Leave a Reply

Your email address will not be published. Required fields are marked *