ServiceNow Connection

Base URL address: https://[instance].service-now.com/api/now.

The authentication uses a parameters-based authentication.

The authentication has the following user-defined parameters:

• Name:
• Password:

The following request parameters will be automatically processed during the authentication process:

• Authorization: Basic {{=Base64.encode(connection.user.Name + ':' + connection.user.Password)}}

Documentation: https://en.wikipedia.org/wiki/Basic_access_authentication.

---

The external resource list is extracted from: {{=ServiceNow.getExternalResources()}}.

{{=resource.external.sys_name || resource.external.name}}

[Read] action

Endpoint URL address: /table/{{=resource.external.name}}.
The result is extracted from: {{=response.result}}.
The result is paginated.

The following request parameters will be automatically processed:

• sysparm_fields: {{=parameters.fields.join()}}
• sysparm_offset: {{=parameters.iterator}}
• sysparm_limit: {{=parameters.batchSize}}
• _includeUserParameters: {{=parameters}}

Documentation: http://wiki.servicenow.com/index.php?title=Encoded_Query_Strings#gsc.tab=0.

---

[Create] action

Endpoint URL address: /table/{{=resource.external.name}}.
The result is extracted from: {{=response.result}}.
The action uses POST method.

The following request parameters will be automatically processed:

• application/json: {{=item}}

---

[Update] action

Endpoint URL address: /table/{{=resource.external.name + '/' + item[resource.keyField]}}.
The result is extracted from: {{=response.result}}.
The action uses PUT method.

The following request parameters will be automatically processed:

• application/json: {{=item}}

---

[Delete] action

Endpoint URL address: /table/{{=resource.external.name + '/' + item[resource.keyField]}}.
The result is extracted from: {{=response.result}}.
The action uses DELETE method.

---

External Fields

[External]

The external fields list is extracted from: {{=ServiceNow.getExternalFields(resource)}}.

{{=external.element}}

Template: {{=ServiceNow.getFieldTemplate(external)}}. Data type: {{=ServiceNow.getDataType(external.internal_type.value)}} ( length {{=external.max_length || 255}} )

Documentation: http://wiki.servicenow.com/index.php?title=Introduction_to_Fields.

ScheduleDateTime

Data type: DT_DBTIMESTAMP The gathered value is processed with {{=(value && value.substring(0,4) + '-' + value.substring(4,6) + '-' + value.substring(6,8) + 'T' + value.substring(9,11) + ':' + value.substring(11,13) + ':' + value.substring(13,15)}} expression.

Documentation: Sample - 20081001T045959.

---

Reference

Field components:

• Contains the following components: link, value.

---

Duration

Data type: DT_I4 The gathered value is processed with {{=value && parseInt(new Date(value.replace(' ', 'T')).getTime() / 1000).toString()}} expression.

---