

ServiceNow Connector Reference

The following operations allow you to work with the ServiceNow Connector. Click an operation name to see parameter details and samples on how to use it.

---

Initialize the connector

To use the ServiceNow connector, add the element in your configuration before carrying out any other ServiceNow operations.

The ServiceNow API requires all requests to be authenticated as a user. User has to create a own instance with his user credentials. When u create a account in ServiceNow Developer page then you are enable to create your own instance. For more information, see the ServiceNow Developer page.

servicenow.init

The servicenow.init operation initializes the connector to interact with the ServiceNow API. For more information, see the API documentation.

Parameter Name	Description	Required
serviceNowInstanceURL	The base endpoint URL of the ServiceNow API.	Yes.
username	The user Name of the own instance.	Yes.
password	The Password of the own instance.	Yes.

Sample configurations

<servicenow.init>
     <serviceNowInstanceURL>{$ctx:serviceNowInstanceURL}</serviceNowInstanceURL>
     <username>{$ctx:username}</username>
     <password>{$ctx:password}</password>
</servicenow.init>

Sample request

{
    "serviceNowInstanceURL":"https://dev17686.service-now.com", 
    "username":"admin",
    "password":"12345"
}

---

Aggregate API

servicenow.getAggregateRecord

The getAggregateRecord operation allows you to compute aggregate statistics about existing table and column data.

Parameter Name	Description	Required
tableName	Name of the table you want to retrieve a record.	Yes.
sysparmAvgFields	A comma-separated list of fields for which to calculate the average value.	Yes.
sysparmMinFields	A comma-separated list of fields for which to calculate the minimum value.	Yes.
sysparmMaxFields	A comma-separated list of fields for which to calculate the maximum value.	Yes.
sysparmCount	You can set this parameter to true for the number of records returned by the query.	Yes.
sysparmSumFields	A comma-separated list of fields for which to calculate the sum of the values.	Yes.

Sample configurations

<servicenow.getAggregateRecord>
    <tableName>{$ctx:tableName}</tableName>
    <sysparmAvgFields>{$ctx:sysparmAvgFields}</sysparmAvgFields>
    <sysparmMinFields>{$ctx:sysparmMinFields}</sysparmMinFields>
    <sysparmMaxFields>{$ctx:sysparmMaxFields}</sysparmMaxFields>
    <sysparmCount>{$ctx:sysparmCount}</sysparmCount>
    <sysparmSumFields>{$ctx:sysparmSumFields}</sysparmSumFields>
</servicenow.getAggregateRecord>

Sample request

{
    "serviceNowInstanceURL":"https://dev17686.service-now.com", 
    "username":"admin",
    "password":"12345",
    "tableName":"incident",
    "sysparmAvgFields":"category,active",
    "sysparmMinFields":"number",
    "sysparmMaxFields":"number",
    "sysparmCount":"true",
    "sysparmSumFields":"priority"
}

---

Import Set API

servicenow.getRecordStagingTable

The getRecordStagingTable operation retrieves the associated record and resulting transformation result.

Parameter Name	Description	Required
tableNameStaging	Name of the staging table you want to retrieve records.	Yes.
sysIdStaging	The Id that is automatically generated by ServiceNow. It is a unique value for each record.	Yes.

Sample configurations

<servicenow.getRecordsStagingTable>
    <tableNameStaging>{$ctx:tableNameStaging}</tableNameStaging>
    <sysIdStaging>{$ctx:sysIdStaging}</sysIdStaging>
</servicenow.getRecordsStagingTable>

Sample request

{
    "serviceNowInstanceURL":"https://dev17686.service-now.com", 
    "username":"admin",
    "password":"12345",
    "tableName":"incident",
    "sysparmAvgFields":"category,active",
    "sysparmMinFields":"number",
    "sysparmMaxFields":"number",
    "sysparmCount":"true",
    "sysparmSumFields":"priority"
}

servicenow.postRecordStagingTable

The postRecordStagingTable operation inserts incoming data into a specified staging table and triggers transformation based on predefined transform maps in the import set table.

Yes.

Parameter Name	Description	Required
tableNameStaging	Name of the staging table you want to retrieve records.	Yes.
serialNumber	This is an attribute in the table. Specify the row value for serialNumber.
cpuCount	This is an attribute in the table. Specify the row value for cpuCount.	Yes.
manufacturer	This is an attribute in the table. Specify the row value for manufacturer.	Yes.
name	This is an attribute in the table. Specify the row value for name.	Yes.
operatingSystem	This is an attribute in the table. Specify the row value for operatingSystem.	Yes.
diskSpace	This is an attribute in the table. Specify the row value for diskSpace.	Yes.
ram	This is an attribute in the table. Specify the row value for ram.	Yes.
apiColumns	The attribute values of your table in your instance.	Yes.

Sample configurations

<servicenow.postRecordStagingTable>
    <tableNameStaging>{$ctx:tableNameStaging}</tableNameStaging>
    <serialNumber>{$ctx:serialNumber}</serialNumber>
    <cpuCount>{$ctx:cpuCount}</cpuCount>
    <manufacturer>{$ctx:manufacturer}</manufacturer>
    <name>{$ctx:name}</name>
    <operatingSystem>{$ctx:operatingSystem}</operatingSystem>
    <diskSpace>{$ctx:diskSpace}</diskSpace>
    <ram>{$ctx:ram}</ram>
    <apiColumns>{$ctx:apiColumns}</apiColumns>
</servicenow.postRecordStagingTable>

Sample request

{
    "serviceNowInstanceURL":"https://dev17686.service-now.com",
    "username":"admin",
    "password":"12345",
    "tableNameStaging":"imp_computer",
    "serialNumber":"282",
    "cpuCount":"234",
    "name":"Mac",
    "operatingSystem":"ubunthu",
    "manufacturer":"IBM",
    "diskSpace":"400Gb",
    "ram":"ram 1500",
    "apiColumns": {"sys_mod_count":"2","sys_import_state_comment":"wwww"}
}

Top