Declarative Agent for M365 Copilot

The following files are customizable and show example implementations to help you get started.

This project integrates with the ServiceNow platform using two ServiceNow Script REST APIs to enable seamless data exchange and automation of specific workflows.

ServiceNow’s scripted REST API allows developers to create custom web service APIs that can interact with ServiceNow data and services. These APIs can be configured to support a variety of HTTP methods (GET, POST, PUT, DELETE) and can be used to perform operations such as querying data, creating records, updating records, and deleting records.

This section contains code for a script REST API designed to list incidents related to a user.

1. Go to System Web Services: movement System Web Services > Scripted Web Services > Scripted REST APIs.
2. Create a new API: Click New Provide the name and namespace of your API.
3. resource definition: Create a resource by specifying an HTTP method, relative path, and path parameters.
4. Write a script: In the scripting window, write the scripts needed to process request and response objects.
5. API testing: Use REST API Explorer to test your API and ensure it works as expected.

The API is built on ServiceNow’s platform and leverages powerful scripting capabilities to retrieve and return incident data.

This API supports the GET method and responds with a JSON object containing relevant incident details.

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

 
	var username = request.pathParams.username;
    
	
	
    var instanceName = gs.getProperty('instance_name', 'default_instance');

	
    username = username.replace(/\+/g, ' ');

    
    var gr = new GlideRecord('incident');
    gr.addQuery('caller_id.name', username);
    gr.query();

    
    var result = [];
    while (gr.next()) {
        result.push({
            number: gr.getValue('number'),
            short_description: gr.getValue('short_description'),
            state: gr.getValue('state')
        });
    }

    
    if (result.length === 0) {
        response.setStatus(404);
        response.setBody({error: 'No incidents found for the user name'});
    } else {
        
        response.setStatus(200);
        response.setBody(result);
    }

})(request, response);

This section contains code for a scripted REST API designed to create new incidents in ServiceNow.

This API leverages the capabilities of ServiceNow to accept incident details through a POST request and create a record of that incident in the ServiceNow system. The request body must contain the required incident data, and if created successfully, the API will respond with details of the newly created incident.

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

    
    var requestBody = request.body.data;

    
    if (!requestBody || !requestBody.short_description || !requestBody.username) {
        response.setStatus(400); 
        response.setBody({error: "Missing required fields: short_description or username"});
        return;
    }

    
    var userGr = new GlideRecord('sys_user');
    userGr.addQuery('name', requestBody.username);
    userGr.query();

    if (!userGr.next()) {
        response.setStatus(404); 
        response.setBody({error: "User not found with username: " + requestBody.username});
        return;
    }

    var callerId = userGr.sys_id;

    
    var gr = new GlideRecord('incident');
    gr.initialize();
    gr.short_description = requestBody.short_description;
	gr.description = requestBody.description;
    gr.caller_id = callerId; 
    gr.category = requestBody.category || 'inquiry'; 
    gr.impact = requestBody.impact || 3; 
    gr.urgency = requestBody.urgency || 3; 

    var incidentNumber;
    try {
        
        var sysId = gr.insert();
        incidentNumber = gr.number;

        
        response.setStatus(201); 
        response.setBody({
            result: 'Incident created successfully',
            sys_id: sysId,
            number: incidentNumber
        });
    } catch (e) {
        
        gs.error("Error creating incident: " + e.message);
        response.setStatus(500); 
        response.setBody({error: "Error creating incident: " + e.message});
    }

})(request, response);