This connector supports both identity and Provisioning.
-
The Identity component of the ServiceNow connector allows you, as an Identity administrator, to configure ServiceNow as a connected system and then make Identity users part of the ServiceNow system. The connector also enables the user or Identity administrator to reset ServiceNow account passwords and enable and disable user accounts.
-
The Provisioning component of this connector enables exporting and importing of user accounts, groups, roles, incidents, tasks, catalog tasks, requests, and approvals on a ServiceNow system. The Request data format enables export and importing of request item and request item variables included as multi-level attributes under that.
-
Trigger component of this connector enables event driven processing for user accounts, incidents, tasks, catalog tasks, requests, request items, request item variables, and approvals.
-
ServiceNow request linked data formats (tasks, catalog tasks, requests, and approvals) and triggers (tasks, catalog tasks, requests, request items, request item variables, and approvals) allow request processing at ServiceNow side and request provisioning at Fischer side.
Identity Integration
Product Feature |
Supported |
---|---|
Authenticate(Test Connection |
Yes |
Validate User |
Yes |
Enable/Disable User |
Yes |
Reset Password |
Yes |
Expire Password |
Yes: Immediate |
Provisioning Integration
Data Format |
Export |
Create |
Modify |
Delete |
Trigger |
User |
Yes |
Yes |
Yes |
Yes |
Yes |
Group |
Yes |
Yes |
Yes |
Yes |
No |
Role |
Yes |
Yes |
Yes |
Yes |
No |
Incident |
Yes |
Yes |
Yes |
Yes |
Yes |
Task |
Yes |
Yes |
Yes |
Yes |
Yes |
Catalog Task |
Yes |
Yes |
Yes |
Yes |
Yes |
Request |
Yes |
Yes |
Yes |
Yes |
Yes |
Request Item* |
Yes |
Yes |
Yes |
Yes |
Yes |
Request Item Variable* |
Yes |
Yes |
Yes |
Yes |
Yes |
Approval |
Yes |
Yes |
Yes |
Yes |
Yes |
*Not available as a separate data format. But can be managed using another data format.
Prerequisites
Ensure that these prerequisites are satisfied:
- An administrator account that can be used to establish a connection and has authority to manage accounts on the ServiceNow connected system.
- Identity Administrator rights.
Creating the Connected System
Admin UI
-
Log in to Identity Administration and click the Systems tab.
- On the Connected System View page, click the Add button and select the ServiceNow connected system from the Type drop-down list. The Connected System Details page displays the default values:
-
Enter the desired information:
Definition Supported Connectors Displays whether the connected system is Identity only, Provisioning only, or both.
Type Select the connected system type. Locale Select the preferred language (default: English). Locale specific information such as Display Name and Description can be added only while modifying the connected system.
Name The name for this connected system. Note: The name cannot be modified later. Display Name The display name of the new connected system. Description The description of the connected system. Associated With Select how the connector associated with this system will run:
- Server (default) - Runs locally on the Provisioning/Identity Server.
- Global Identity Gateway - Runs remotely on a Global Identity Gateway cluster member. Note: Only GIG clusters that have at least one registered and enabled member will display in this list.
- See Using the Global Identity Gateway with Connected Systems for additional information.
Password Reset By Enables administrators to configure password management functions normally available to Users and OBO (On Behalf Of) Users: - OBO User Only - Connected system and account association information is displayed only in Self-Service user management (for OBO Users). OBO Users can reset passwords for accounts on this connected system. Administrators can perform all user management functions for this connected system (e.g., enable/disable, validate, associate user, and password reset). End users will not see their accounts on this connected system in Self-Service and Kiosk; therefore, they cannot reset passwords for accounts on this connected system.
- Users and OBO User - Connected system and account association information is displayed in Self-Service password reset, Self-Service - Kiosk, and Self-Service user management. Self-Service users, Kiosk users, and OBO Users can reset passwords for accounts on this connected system. Administrators can perform all user management functions for this connected system (e.g., enable/disable, validate, associate user, and password reset).
- External - Connected system and account association information is not displayed in Self-Service password reset, Self-Service - Kiosk, and Self-Service user management. Self-Service users, Kiosk users, and OBO Users cannot reset passwords for accounts on this connected system.
Note: When user management configuration enables OBO Users to perform password resets, this definition must be set to OBO User Only or Users and OBO User. For connectors that support Provisioning only, there is no password reset capability.
Provisioning Option Select the provisioning option: - Automated (default) - The connected system functions as a normal connected system; there are no restrictions.
- Administrative - The connected system cannot be used as an object in a workflow.
Enable HPAM Support Select to make the connected system HPAM enabled (default: cleared). Note: This can only be set for systems that support Identity. Enable Transfer of Accounts
Select to make the connected system Transfer of Accounts enabled (default: cleared).
Share Across All Orgs Option to make a connected system available across all organizations.
Note: This configuration is limited to master organization.
Connection Information Service URL The URL for ServiceNow Server (https://sandbox.service-now.com).
Service Account Name The administrative user account.
Service Account Password The administrative user password.
Connection Timeout
The maximum number of seconds to wait for the Web Service to respond before the connection attempt times-out. 0 means no time out.
Password Expiration Support Expiration Options For Admin/OBO User Password Reset Specify the password expiration: None, or Immediate.
System Owner Add or Remove users assigned as the owners of the system. Displays the Connected System Owner Search page for selecting users. The HPAM column indicates whether the system owner is authorized to use the HPAM feature. The Approvers column indicates whether the system owner is an approver in the approval process. -
Click the Test Connection button to test the Connection Information:
- If successful, one or both of these messages may display:
Message: Connection from Provisioning to the connected system was established successfully.
Message: Connection from Identity to the connected system was established successfully.- If unsuccessful, one or both of these messages may display these messages may display:
Error: Failed to establish connection from Provisioning to the connected system.
Error: Failed to establish connection from Identity to the connected system.
Note: If the connection fails, additional messages may display providing more information regarding the failure, and additional information may be posted to the Provisioning and Identity logs. -
(Optional) To select owners of the system, click the System Owner Add button. The Connected System Owner Search page displays:
-
Select the owners and then click the Select button. The system owner displays under the System Owner section:
Note: More than one user can be assigned as an owner.
-
To add additional system owners, click the Add button.
-
- On the Connected System Details page, click the Add button to save the configured connected system. The Object Category Association page displays a list of categories that are already associated and/or can be selected to add additional associations to this connected system:
-
Select one or more available object categories or provide search criteria and click the Search button to find specific categories to select. If there are no available categories to select, proceed to Step 7.
-
Click the Add Association button to associate the selected object categories to the connected system.
-
-
Click the Back button to return to the Connected System View page. The new connected system displays in the list.
See Copying, Modifying, and Deleting Connected Systems for additional information.
Studio
- Log in to the Workflow and Connectivity Studio and click Connectivity ► Add Systems on the menu bar. The Add Connected Systems window displays.
- Select the ServiceNow connected system from the Type drop-down list. The default values display.
-
Enter the desired information:
Definition Type Select the connected system type. Name The name for this connected system. Note: The name cannot be modified later. Display Name The display name of the new connected system. Description The description of the connected system. Supported Connectors Displays whether the connected system is Identity only, Provisioning only, or both. Only connectors that support Provisioning are available here. Associated With Select how the connector associated with this system will run: - Server (default) - Runs locally on the Provisioning/Identity Server.
- Global Identity Gateway - Runs remotely on a Global Identity Gateway cluster member. Note: Only GIG clusters that have at least one registered and enabled member will display in this list.
Password Reset By Enables administrators to configure password management functions normally available to Users and OBO (On Behalf Of) Users: - OBO User Only - Connected system and account association information is displayed only in Self-Service user management (for OBO Users). OBO Users can reset passwords for accounts on this connected system. Administrators can perform all user management functions for this connected system (e.g., enable/disable, validate, associate user, and password reset). End users will not see their accounts on this connected system in Self-Service and Kiosk; therefore, they cannot reset passwords for accounts on this connected system.
- Users and OBO User - Connected system and account association information is displayed in Self-Service password reset, Self-Service - Kiosk, and Self-Service user management. Self-Service users, Kiosk users, and OBO Users can reset passwords for accounts on this connected system. Administrators can perform all user management functions for this connected system (e.g., enable/disable, validate, associate user, and password reset).
- External - Connected system and account association information is not displayed in Self-Service password reset, Self-Service - Kiosk, and Self-Service user management. Self-Service users, Kiosk users, and OBO Users cannot reset passwords for accounts on this connected system.
Note: When user management configuration enables OBO Users to perform password resets, this definition must be set to OBO User Only or Users and OBO User. For connectors that support Provisioning only, there is no password reset capability.
Provisioning Option Select the provisioning option:
- Automated (default) - The connected system functions as a normal connected system; there are no restrictions.
- Administrative - The connected system cannot be used as an object in a workflow.
Enable HPAM Support Select to make the connected system HPAM enabled (default: cleared). Note: This can only be set for systems that support Identity. Enable Transfer of Accounts Select to make the connected system Accounts to be transferred.
Note: This can only be set for systems that support Identity.
Connection Information Service URL The URL for ServiceNow Server (https://sandbox.service- now.com).
Service Account Name The administrative user account.
Service Account Password The administrative user password.
Connection Timeout
The maximum number of seconds to wait for the Web Service to respond before the connection attempt times-out. 0 means no time out.
Password Expiration Support Expiration Options For Admin/OBO User Password Reset Specify the password expiration: None or Immediate.
- Click the Connect button to test the Connection Information:
- If successful, this message will display:
Connection from Studio to the connected system was established successfully.
- If unsuccessful, this message will display:
Failed to establish connection from Studio to the connected system.
Note: If the connection fails, additional messages may display providing more information regarding the failure.
-
Click the Apply button to apply changes. The Category Association window displays.
-
Select one or more object categories from the Available Categories list or enter a category name and click the Search button to find a specific category to select. If there are no available categories to select, proceed to Step 6.
-
Click the Add button to associate the selected object categories to the connected system.
-
-
Click OK to accept selected categories.
See Copying, Modifying, and Deleting Connected Systems for additional information.
Using the Connected System for Identity
Perform these procedures to configure the connector:
- Connector Details for Identity
- Identity Password Management
Connector Details for Identity
Field |
System Attribute |
Example Value |
---|---|---|
Login ID | UserID | BLANE |
Account ID | UserID | BLANE |
Identity Password Management
See User Management for details on password management.
Using the Connected System for Provisioning
Perform these procedures to configure the connector:
- Configuring for Export
- Configuring for Import
- Connector Details for Provisioning
Note: If the number of records to be processed exceeds one thousand, we recommend configuring the workflow to use bulk mode, which lowers the memory consumption of the system by streaming data to files. Because data is streamed for every task, performance of the workflow execution will be decreased due to increased read-write operations. See the Workflow and Connectivity Studio document for details on how to configure bulk mode.
Configuring for Export
Perform these procedures to configure the connector for data export:
- Configuring the Export Connector
- Configuring the Export Link
From the Workflow and Connectivity Studio, select the ServiceNow UserExport workflow listed under the projects folder.
If a workflow does not already exist, create an export workflow. See the Workflow and Connectivity Studio document for details on creating export workflows.
Configuring the Export Connector
- In the Design pane, double-click the export object (the first workflow object after the Start object). The Configure Data Source window displays:
-
From the Configure Plug-in tab, set these properties as required:
Associated Connected System Select the connected system from the list. The export operation will be done from this connected system. Data Formats Select the type of data format to use: User(default), Group, Role, Incident, Tasks, Catalog Task, Request, or Approval. DeltaExportMode Select the type of attribute to export if a change takes place (this works in conjunction with ExportMode when DeltaExport is selected):
- OnlyChangedAttributes - Performs a partial export of only the changed attributes from the last time the query was
- ChangedAndMandatoryAttributes (default) - Performs a partial export of both changed and mandatory attributes from the last time the query was run. Mandatory attributes are exported whether they have been changed or
- AllAttributes - Performs a full export of all attributes that contain a
DynamicConnectedSystem Select the global variable to use as the dynamic connected system name. This works in conjunction with DynamicConnectedSystemOption when GlobalVariable is selected. DynamicConnectedSystemOption Select how to control Dynamic System Support (DSS): - None - There will not be any Dynamic System Support.
- Transaction-SystemName - The value of the Transaction-SystemName attribute in data will be used as the dynamic connected system. The connected system name must be passed as the value of the attribute Transaction-SystemName; if it is missing in data, the operation will fail.
- GlobalVariable - Select a global variable to use as the dynamic connected system name from the property DynamicConnectedSystem.
ExecuteGIGAssociatedTaskAsynchronously Select execution mode for GIG associated tasks.
If this property is true, GIG associated tasks will execute asynchronously.ExportEntryByID To fetch the details of an entry by SysID. SysID is unique Id for an entry in ServiceNow.
ExportMode Select the type of data to export:
- FullExport - Exports all
- DeltaExport - Exports changed, mandatory, or all attributes, depending on the DeltaExportMode property
FetchDisplayValueForReferenceAttributes
Select the option to fetch values for reference attributes:
- TRUE (default) - Fetches display value
- FALSE - Fetches internal value
Filter Specify search criteria to determine the objects to be exported from ServiceNow Use the Set Filter button that becomes active to create a filter. See "Set Filter" for additional information. MaxResults Maximum Number of results to be returned.
Results Per Page Number of entries fetched in a single call. If paging is not required set this to 0.
Set Filter
Element Description Attribute Select the attribute of the filter. This represents the attribute name for searching the Grouper directory.
Comparison Select the operator value for this filter.
Value Enter the required result value AND Condition List Creates an AND statement comparing selected conditions. If there is more than one condition in this list box, all conditions must be true. OR Condition List Creates an OR statement comparing selected conditions. If there is more than one condition in this list box, one of the conditions must be true.
Filter Syntax Displays the filter syntax used to retrieve entries from the LDAP directory and to build the export list. Edit Filter Manually Check this box to manually edit the filter in the Filter Syntax to build complex filters.
-
Using logical AND/OR, generate the complex filter to narrow the search result.
-
Click OK when complete to return to the Configure Data Source window.
- (Optional)Select the Attributes tab. Only standard attributes display
-
Modify schema attributes using these buttons.
Description Add Adds additional attributes to the list. The Add New Attribute dialog displays. Export Exports the schema list to an XML file. Import Imports the schema list from an XML file. Reset Schema Resets the schema definition to the default schema prepackaged with the IdM Suite, plus any global variable added.
Reset Schema Resets the schema definition to the default schema prepackaged with the IdM Suite, plus any global variable added.
-
- Click the Add button to display the Add New Attribute window:
- (Optional) Select the Appearance tab to change how the Connected System object displays in the Design pane.
- Click OK to save any changes and return to the Workflow and Connectivity Studio window.
Configuring the Export Link
-
In the Design pane, double-click the export link between the export object (the first workflow object after the Start object) and the Data Mapper object. The Configure Link window displays:
-
From the Attribute Selection tab, set these properties as required:
Description Source Attributes Select the attributes to export. Selected Attributes Displays default attributes and those attributes that have been selected from the Source Attributes.
Notes: The check boxes are used only for delta export operations. These checked attributes will always be exported whether they were changed or not. Usually, the attributes that are selected as mandatory attributes help in identifying or verifying an entry when completing mapping functions
Format Displays the Format Date window to specify a date/time format to be applied to the selected date type attribute. During export, the attribute’s value is converted to the specified format. See the Format Date steps below for additional information.
Notes:
- The Format button is only enabled for date attributes.
Advanced Settings Displays the Configure Attributes window for configuring advanced settings for attributes. See the Configure Attributes window on page 39 for additional information.
-
- From the Attribute Selection tab, select attributes to export.
- Click OK to save any changes and return to the Workflow and Connectivity Studio window.
- Deploy the workflow by selecting Deploy ► New Deployment. See the Workflow and Connectivity Studio documentation for details of deployment options.
- Manage and run the deployed workflow from the Admin UI ► Server tab. See the Identity Suite Administration documentation for details.
Configuring for Import
Perform these procedures to configure the connector for data import:
-
Configuring the Import Connector
-
Configuring the Import Link
From the Workflow and Connectivity Studio, select the ServiceNow UserAdd, UserModify, or UserDelete workflow listed under the projects folder.
If a workflow does not already exist, create an import workflow. See the Workflow and Connectivity Studio documentation for details on creating import workflows.
Configuring the Import Connector
- In the Design pane, double-click the import object (the last workflow object). The Configure Data Source window displays:
-
From the Configure Plug-in tab, set these properties as required:
Associated Connected System Select the connected system from the list. The import operation will be done to this connected system. Data Formats Select the type of data format to use: User(default), Group, Role, Incident, Tasks, Catalog Task, Request, or Approval DynamicConnectedSystem Select the global variable to use as the dynamic connected system name. This works in conjunction with DynamicConnectedSystemOption when GlobalVariable is selected. DynamicConnectedSystemOption
Select how to control Dynamic System Support (DSS):- None - There will not be any Dynamic System Support.
- Transaction-SystemName - The value of the Transaction-SystemName attribute in data will be used as the dynamic connected system. The connected system name must be passed as the value of the attribute Transaction-SystemName; if it is missing in data, the operation will fail.
- GlobalVariable - Select a global variable to use as the dynamic connected system name from the property DynamicConnectedSystem.
See the Dynamic System Support appendix in the Workflow and Connectivity Studio document for additional information.
ExecuteGIGAssociatedTaskAsynchronously Select execution mode for GIG associated tasks.
If this property is true, GIG associated tasks will execute asynchronously.Id * Enter the attribute that contains the value used to uniquely identify the user account user ID on the connected system. loginId * Enter the attribute that contains the value used to uniquely identify the user account login ID on the connected system. -
(Optional) Select the Attributes tab. Only standard attributes display:
-
Modify schema attributes with the buttons.
Description Add Adds additional attributes to the list. The Add New Attribute dialog displays. Export Exports the schema list to an XML file. Import Imports the schema list from an XML file. Reset Schema Resets the schema definition to the default schema prepackaged with the IdM Suite, plus any global variable added.
-
- (Optional) Select the Appearance tab to change how the Connected System object displays in the Design pane.
- Click OK to save any changes and return to the Workflow and Connectivity Studio window.
Configuring the Import Link
-
In the Design pane, double-click the import link between the Data Mapper object and the import object (the last workflow object). The Configure Link window displays:
Element Description Source Attributes Select the attributes to import. Check for attribute-level auditing. If auditing is enabled and these attributes below are checked, Provisioning will log all events for auditing purposes.
Selected Attributes Displays default attributes and those attributes that have been selected from the Source Attributes. Note: The default attributes are those that are commonly used to create a new user. Advanced Settings Displays the Configure Attributes window for configuring advanced settings for attributes. Under the Encrypted column, check the box of any attribute that needs to be encrypted. Key Attribute Select the attribute to be used as the key attribute while processing import opeartions.
- From the Attribute Selection tab, select attributes to import.
- (Optional) Select the Appearance tab to change how the link displays in the Design pane.
- Click OK to save any changes and return to the Workflow and Connectivity Studio window.
- Deploy the workflow by selecting Deploy ► New Deployment. See the Workflow and Connectivity Studio for details of deployment options.
- Manage and run the deployed workflow from the Admin UI ► Server tab. See the Identity Suite Administration documentation for details.
Connector Details for Provisioning
Configuration import properties Id and loginId are used by the Provisioning Policy and IdentityHub features to populate the ACCOUNT_ID and ACCOUNT_USERNAME columns of the FISC_USER_ACCOUNT table of the Product database. See the 'Provisioning Policy' and 'Provisioning Using the IdentityHub' chapters of the Identity Suite Administration Guide for details.
This table shows the default attributes specified for these properties for the connected system:
Identity Property |
System Attribute |
---|---|
Id |
UserID |
loginid |
UserID |
Entitlement Support
This connector supports both Static and Dynamic entitlements in the form of Groups and Roles. Entitlements are configured from the Admin UI ' Server ' Resources. See the Resource Management chapter in the Identity Suite Administration Guide for details on resources.
To configure entitlements
- On the Resource Detail page, under Entitlement Options, click Add The Entitlement Search page displays:
- Click Search which redirects to Provisioning Entitlements View:
- To add a Static Entitlement, Click Add Static Entitlement button in Resource Detail page. Enter a desired Name, Value (existing Group or Role within Service Now), and a Description, for example:
-
This is an example screen for a resource after setting static and dynamic entitlements:
To view entitlements that have been provisioned for existing users
- From Admin UI ► Users ► Search Users to Modify ► Profile View for a user ► User Access View page, expand the plus sign for a ServiceNow account. All entitlements associated for the user are listed.
Lookup Data
To filter data, use the Data Mapper rule Lookup Data
- Log in to the Workflow and Connectivity Studio and double-click the Data Mapper object on the Design The Configure Data Mapper window displays.
- Select the Lookup Data rule under the Mapping Rule column and then click the Source Value. The Configure Lookup window displays.
- Select the ServiceNow system from the Select System drop-down list:
Note: User, Group, Role, Incident, Tasks, Catalog Task, Request, and Approval lookup are supported by this dialog.
- In the Enter Lookup Prefix field, enter the prefix to be added to the Lookup fields.
- The connector support two types of lookup search:
- By Id
- By Filter
- Select the Lookup Type from the drop-down list, for example, User, By Id
- Click the SysID Pick button to select the ID for a Successful Lookup.
- If Lookup Type selected is By Filter, Click the Filter Build button, and then from the Set Filter window, generate the search filter, for example:
- Click the Selected Fields Pick button to select the attributes to be fetched after a successful lookup. The Lookup Configuration dialog displays:
- Click OK. The updated Configure Lookup window displays, for example:
Configuring Triggers
Perform these procedures to create trigger:
Prerequisites
Ensure that these prerequisites are satisfied:
- Create a ServiceNow provisioning connector before creating a ServiceNow trigger (see the section Creating the Connected System in the Studio).
- Create and deploy workflows to be run by the ServiceNow Server See the ‘Creating workflows’ and ‘Deploying Workflows’ sections in the Workflow Development chapter in the Workflow and Connectivity Studio document for details.
Creating a Trigger
-
From the Workflow and Connectivity Studio menu bar, click File ► New Trigger ► ServiceNow The Create a New Trigger window displays.
-
Enter a trigger name in the Name field.
-
Click the Browse button to select a directory other than the default displayed in the Directory field. The directory should be a child of the default location in order to have the trigger listed under the projects folder of the Workflow and Connectivity Studio.
-
Select one of the available systems in the System field.
Note: Only connected systems of the trigger type will be available. - Enter descriptive text in the Description field and then click OK. A new trigger system object and link display in the Design pane.
Note: The trigger must be fully configured before it can be saved and deployed. Proceed to the sections below to complete configuring the trigger.
Configuring a Trigger Agent - In the Design pane, double-click the trigger system. The Configure Data Source window displays.
Note: To modify an existing trigger, on the menu bar click View ► Triggers, and then select one of the ServiceNow triggers listed under the projects folder. - Select one of the available systems in the Associated Connected System drop-down list for the trigger:
- (Optional) Select the Appearance tab to change how the Connected System object displays in the Design pane.
Note: A trigger cannot be saved until a trigger link has been configured. - Click OK to save any changes and return to the Workflow and Connectivity Studio window.
Configuring a Trigger Link
-
Double-click the link between the Start object and the Trigger system object. The Configure Link window displays.
Element Description Trigger Data Format Select the type of data format to trigger: Incident (default), User, Task, Catalog Task, Incident, Request, Request Item, Request Item Variable or Approval Operations Select the operations to be triggered. Find Option to find an attribute from source attributes by providing a filter condition. Source Attributes All available attributes for the selected trigger data format. Selected Attributes Displays default attributes and those attributes that have been selected from the Source Attributes. Advanced Settings Displays the Configure Attributes window for configuring advanced settings for attributes. Under the Encrypted column, check the box of any attribute that needs to be encrypted. Set Unique Key Sets which attribute from the Selected Attributes will make the entry unique.
Clear Unique Key Removes the current unique key attribute selection. No unique key attribute is defined after selecting this option.
Effective Date Select these effective date options:
- Set - Sets an attribute from the selected attributes to apply an effective date offset to control when the triggered data is run. A condition can be provided that determines when or if an effective date offset should be applied. Set a condition and effective date offset from the Effective Date tab.
- Clear - Removes the selected attribute from being defined for effective date processing.
- Format - Specifies a desired date/time format to be applied to the selected effective date field. Any field type can be selected to apply a date/time format to the effective date value.
Trigger Callback Url The Provisioning server URL to notify changes from ServiceNow. This must be an external address reachable from Internet
eg:-http://trigger-qa.fiscindia.com:6060/dataforum/rest - Select the attributes to be triggered from the Source Attributes.
- Click the Effective Date tab and then click the Add button. The Set Trigger Data Condition window displays.
- Set an Effective Date Offset value and specify a condition and when it will be used:
-
For Triggers - All conditions specified here will be evaluated for each incoming data entry. The offset corresponding to the first condition that is satisfied will be applied to the date contained in the effective date attribute. An offset can be mapped to a condition that is specified as default. If none of the conditions in the list are satisfied, the offset corresponding to the default condition will be applied to the effective date.
- For Chained workflows - From the Chained workflow Configure Data Source window, specify the attribute that should have an effective date condition and offset value applied. From the preceding Data Mapper, provide conditions and offset values to calculate the target effective date value and save this value to the effective date attribute as the target attribute.
-
- Click OK when finished.
- Set an Effective Date Offset value and specify a condition and when it will be used:
-
From the Target Workflow Selection tab, select the deployed workflow(s) to run when the trigger occurs, and then click the Add > button.
To remove a selected workflow from being run, highlight it under Selected Workflows and click the < Remove button.
Notes:
-
Lookup may be required to get additional attributes to run Target workflows. Lookup workflows run prior to Target workflows.
-
If more than one workflow is selected, they are run in the order listed.
Lookup workflows must be deployed in Synchronous mode; otherwise, lookup data may not be available before running target workflows. -
If serialized execution of workflows is required, consider chaining them.
-
Set a check condition before running workflows. Build a complex condition with logical AND/ OR.
-
Click OK to return to the Configure Link window.
-
-
- Highlight a workflow from the Selected Workflows list and click the Set Condition button to set a condition before running Target workflows. The Set Lookup Condition window displays.
- From the Lookup Workflow Selection tab, select the deployed workflow(s) to run when the trigger occurs, and then click the Add > button.
To remove a selected workflow from being run, highlight it under Selected Workflows and click the < Remove button.
Notes:
-
Lookup may be required to get additional attributes to run Target Lookup workflows run prior to Target workflows.
-
If more than one workflow is selected, they are run in the order listed.
Lookup workflows must be deployed in Synchronous mode; otherwise, lookup data may not be available before running Target workflows.
-
- Highlight a workflow from the Selected Workflows list and click the Set Primary button to set the primary workflow to be run.
- Highlight a workflow from the Selected Workflows list and click the Set Condition button to set a condition before running Lookup workflows. The Set Lookup Condition window displays. Set a check condition before running workflows. Build a complex condition with logical AND/OR. Click OK to return to the Configure Link window.
- Click OK to save any changes and return to the Workflow and Connectivity Studio window.
- Save the trigger.
- Deploy the trigger by clicking the deploy tool bar button. The Deploy Trigger window displays.
- Click the Deploy New button. The Deploy Trigger window displays:
- Enable the trigger from the Server tab of the Admin UI.
See the Identity Suite Administration Guide - Volume 1 for details on enabling triggers.
Supported Data Formats
This connector can provision these data formats :
- User - Represents a user in an organization. See Complete List of Fields in the User Object for the data dictionary.
- Group- A group is a set of users who share a common purpose. Groups may perform tasks such as approving change requests, resolving incidents, receiving email notifications, or performing work order tasks. Any business rules, assignment rules, system roles, or attributes that refer to the group apply to all group members automatically. Users with the user_admin role can create and edit groups. See Complete List of Fields in the Group Object for the data dictionary.
- Role- A role is a category that can be assigned to a group or user, and can be granted access to particular parts of the system. Once access has been granted to a role, all of the groups or users assigned to that role are granted the same access. Roles can also contain other roles, and any access granted to one role will be granted to any role that contains it. See Complete List of Fields in the Role Object for the data dictionary.
- Task - Task is a base table with many common fields used by incident, request, request items etc.
- Catalog Task - Catalog task is an extension of task table. Item tasks are generated as standard catalog tasks when an item is ordered. Tasks are assigned to users or groups as part of the fulfillment process when that item is ordered.
- Request - Request Management is the process of managing all types of requests made by end users. Request delivers employee self‑service through a published catalog of services.
- Approval - Manage authorization on tasks before the work is done. Approvals can be defined for tasks and associate users or groups to approve/reject them.
- Incident - An incident in ServiceNow represents an unplanned interruption to an IT Service or a reduction in the quality of an IT Service. See Complete List of Fields in the Incident Object for the data dictionary.
Data Format: User
The User data format is used to query information about users and to provision and modify users in an organization. The records in the User table represent actual users.
Complete List of Fields in the User Object
Attribute Name |
API Attribute Name |
MV |
Field Type |
Description |
Create |
Modify |
Delete |
Business Phone |
phone |
n |
string |
Business Phone |
y |
y |
y |
Manager |
manager |
n |
reference |
Manager of the User |
y |
y |
y |
Location |
location |
n |
reference |
Location |
y |
y |
y |
Street |
street |
n |
string |
Street |
y |
y |
y |
City |
city |
n |
string |
City |
y |
y |
y |
Web service access only |
web_service_acc ess_only |
n |
boolean |
Prevent user from accessing UI, and require a SOAP role to make API protocol calls (such as SOAP and WSDL requests) |
y |
y |
y |
VIP |
vip |
n |
boolean |
VIP |
y |
y |
y |
First name |
first_name |
n |
string |
The User’s Firstname |
y |
y |
y |
Domain |
sys_domain |
n |
string |
Domain to which the user belongs |
y |
y |
y |
Locked out |
locked_out |
n |
boolean |
When checked, user cannot login |
y |
y |
y |
Gender |
gender |
n |
string |
Gender |
y |
y |
y |
Updates |
sys_mod_count |
n |
string |
Updates |
y |
y |
y |
Employee Number |
employee_numb er |
n |
string |
Employee Number |
y |
y |
y |
Calendar integration |
calendar_integra tion |
n |
Integer |
Calendar Integration |
y |
y |
y |
Middle name |
middle_name |
n |
string |
Middle name of the user |
y |
y |
y |
Updated |
sys_updated_on |
n |
Date/ Time |
Updated |
y |
y |
y |
Last login |
last_login |
n |
Date/ Time |
Last login time |
y |
y |
y |
Country code |
country |
n |
string |
Country code |
y |
y |
y |
User ID |
user_name |
n |
string |
User ID |
y* |
y* |
y* |
Time zone |
time_zone |
n |
string |
Time Zone |
y |
y |
y |
|
|
n |
|
Email of the User. By default the group email address overrides individual email addresses of members. |
y |
y |
y |
Failed login attempts |
failed_attempts |
n |
Integer |
Failed login attempts |
y |
y |
y |
Company |
company |
n |
string |
Company |
y |
y |
y |
Roles |
roles |
n |
string |
Roles |
y |
y |
y |
Last name |
last_name |
n |
string |
The User’s lastname |
y |
y |
y |
Password |
user_password |
n |
string |
Password |
y |
y |
y |
Active |
active |
n |
boolean |
Inactive users do not show in user choice lists |
y |
y |
y |
Prefix |
introduction |
n |
string |
Prefix |
y |
y |
y |
Department |
department |
n |
string |
Department |
y |
y |
y |
State/Province |
state |
n |
string |
State/Province |
y |
y |
y |
Password needs reset |
password_needs _reset |
n |
boolean |
User will be prompted to change password at next login |
y |
y |
y |
Created |
sys_created_on |
n |
Date/ Time |
Created |
y |
y |
y |
LDAP server |
ldap_server |
n |
Reference(LD AP Server) |
LDAP Server |
y |
y |
y |
Cost center |
cost_center |
n |
Reference(co st center) |
Cost Center |
y |
y |
y |
Class |
sys_class_name |
n |
string |
Class Name |
y |
y |
y |
Home phone |
home_phone |
n |
string |
Home Phone |
y |
y |
y |
Time format |
time_format |
n |
string |
Display times with this format (blank means system default) |
y |
y |
y |
Language |
preferred_language |
n |
string |
Language |
y |
y |
y |
Zip / Postal code |
zip |
n |
string |
Zip / Postal code |
y |
y |
y |
Building |
building |
n |
Reference(Building) |
Building |
y |
y |
y |
Last login time |
last_login_time |
n |
Date/ Time |
Last Login time |
y |
y |
y |
Sys ID |
sys_id |
n |
GUID |
Sys ID |
y |
y |
y |
Default perspective |
default_perspective |
n |
Reference(Menu List) |
Default Perspective |
y |
y |
y |
Photo |
photo |
n |
Image |
Photo |
y |
y |
y |
Schedule |
schedule |
n |
Reference(Schedule ) |
Schedule |
y |
y |
y |
Source |
source |
n |
string |
Source |
y |
y |
y |
Mobile phone |
mobile_phone |
n |
string |
Mobile Phone number |
y |
y |
y |
Title |
title |
n |
String |
Title |
y |
y |
y |
Created by |
sys_created_by |
n |
string |
Created by |
|
|
|
Date format |
date_format |
n |
string |
Display dates with this format (blank means system default) |
y |
y |
y |
Name |
name |
n |
string |
Name |
y |
y |
y |
Notification |
notification |
n |
Integer |
Enable or disable notifications for this user ie. email, SMS etc |
y |
y |
y |
Internal Integration User |
internal_integration_user |
n |
boolean |
Internal Integration User |
y |
y |
y |
Updated by |
sys_updated_by |
n |
string |
Updated By |
y |
y |
y |
MemberGroup->Group |
|
y |
String |
Groups that have the User as member |
n |
y |
n |
MemberGroup->SysID |
|
y |
String |
SysID of the Group |
n |
y |
n |
MemberRole-> Role |
|
y |
String |
The Roles of the User |
n |
y |
n |
MemberRole-> SysID |
|
y |
String |
SysId of the Role |
n |
y |
n |
Data Format: Group
The Group data format is used to query user Groups and add, modify and delete Groups in ServiceNow.
Complete List of Fields in the Group Object
Attribute Name |
API Attribute Name |
MV |
Field Type |
Description |
Create |
Modify |
Delete |
Active |
active |
n
|
boolean |
Check box that indicates whether the group is active or inactive. Inactive groups still appear in any reference field that already references the group, but are not visible by non-admin users in: · lists of groups · the reference lookup list for reference fields · the autocomplete list of groups displayed when you type into a reference field |
y |
y |
y |
CostCenter |
cost_center |
n |
Reference(Cost center) |
Related problem, if one exists |
y |
y |
y |
DefaultAsignee |
default_asignee |
n |
Reference(User) |
Default assignee for this assignment group |
y |
y |
y |
Description |
description |
n |
string |
Helpful information about the group. |
y |
y |
y |
GroupEmail |
|
n |
|
Group email distribution list or the email address of the group's point of contact, such as the group manager. |
y |
y |
y |
ExcludeManager |
exclude_manager |
n |
boolean |
Check box that controls whether the group's manager receives email notifications. |
y |
y |
y |
HourlyRate |
hourly_rate |
n |
currency |
Default hourly rate used to calculate costs for tasks assigned to this group. The hourly rate should be provided in DOLLAR ($). |
y |
y |
y |
IncludeMembers |
include_members |
n |
boolean |
Check box that controls whether the group members receive individual emails when someone sends an email to the Group Email address. |
y |
y |
y |
Manager |
manager |
n |
Reference(User) |
Group manager or lead. |
y |
y |
y |
Name |
name |
n |
string |
Name of the group. |
Y* |
n |
y |
Parent |
parent |
n |
Reference(Group) |
Other group of which this group is a member. If a group has a parent, the child group inherits the roles of the parent group. The members of the child group are not members of the parent group. For example, if an incident is assigned to the parent group and you click the Assigned to lookup icon, only the members in the parent group are available. The members of the child group are not available. |
y |
y |
y |
Roles |
roles |
n |
User roles |
User Roles |
y |
y |
y |
Source |
source |
n |
string |
Source |
y |
y |
y |
CreatedBy |
sys_created_by |
n |
string |
Created by |
n |
n |
y |
Created |
sys_created_on |
n |
Date/ Time |
Created |
n |
n |
y |
SysID |
sys_id |
n |
Sys ID |
Sys ID |
n |
Y* |
Y* |
Updates |
sys_mod_count |
n |
Integer |
Updates |
n |
n |
y |
UpdatedBy |
sys_updated_by |
n |
String |
Updated by |
n |
n |
y |
Updated |
sys_updated_on |
n |
Date/ Time |
Updated |
n |
n |
y |
Type |
type |
n |
List(Group Type) |
Category for this group. For example, a group designated as type catalog is a service catalog group and can also be accessed under the Service Catalog > Catalog Policy > Fulfillment Groups module. |
y |
y |
y |
MemberRole->Role |
|
y |
String |
The Roles of the Group |
n |
y |
n |
MemberRole->SysID |
|
y |
String |
SysId of the Role |
n |
y |
n |
MemberUser->UserID |
|
y |
String |
The ID of users in the Group |
n |
y |
n |
MemberUser->SysID |
|
y |
String |
The SysID of users in the Group |
n |
y |
n |
SubGroup->Name |
|
y |
string |
The subgroups in the Group |
n |
y |
n |
SubGroup->SysID |
|
y |
String |
The SysID of subgroup |
n |
y |
n |
Data Format: Role
The Role data format is used to query Roles and add, modify and delete Roles in ServiceNow .
Complete List of Fields in the Role Object
Attribute Name |
API Attribute Name |
MV |
Field Type |
Description |
Create |
Modify |
Delete |
CanDelegate |
can_delegate |
n |
boolean |
Can be delegated |
y |
y |
y |
Description |
description |
n |
string |
Description of the role |
y |
y |
y |
ElevatedPrivilege |
elevated_privilege |
n |
boolean |
This role is an elevated privilege |
y |
y |
y |
IncludesRoles |
includes_roles |
n |
string |
Includes roles |
y |
y |
y |
Name |
name |
n |
string |
Name of the role |
Y* |
n |
y |
AppFile |
sys_app_file |
n |
Reference |
The application file properties related to this role |
y |
y |
y |
CreatedBy |
sys_created_by |
n |
string |
Created by |
n |
n |
y |
Created |
sys_created_on |
n |
Date/ Time |
Created |
n |
n |
y |
SysID |
sys_id |
n |
Sys ID |
Sys ID |
n |
Y* |
Y* |
Updates |
sys_mod_count |
n |
Integer |
Updates |
n |
n |
y |
UpdatedBy |
sys_updated_by |
n |
String |
Updated by |
n |
n |
y |
Updated |
sys_updated_on |
n |
Date/ Time |
Updated |
n |
n |
y |
Grantable |
grantable |
n |
boolean |
Can be granted independently |
y |
y |
y |
Data Format: Task
The Task data format is used to query Tasks and add, modify and delete Tasks in ServiceNow.
Complete List of Fields in the Task Object
Attribute Name |
API Attribute Name |
MV |
Field Type |
Description |
Create |
Modify |
Delete |
Active |
active |
n |
boolean |
Active |
y |
y |
y |
ActivityDue |
activity_due |
n |
Date |
Activity due |
y |
y |
y |
ActualEnd |
work_end |
n |
Datetime |
Actual end |
y |
y |
y |
ActualStart |
work_start |
n |
Datetime |
Actual start |
y |
y |
y |
AdditionalAssigneeList |
additional_assignee_list |
n |
string |
Additional assignee list |
y |
y |
y |
AdditionalComments |
comments |
n |
string |
Additional comments |
y |
y |
y |
Approval |
approval |
n |
string |
Approval |
y |
y |
y |
ApprovalHistory |
approval_history |
n |
journal |
Approval history |
y |
y |
y |
ApprovalSet |
approval_set |
n |
Datetime |
Approval set |
y |
y |
y |
AssignedTo |
assigned_to |
n |
reference |
Assigned to |
y |
y |
y |
AssignmentGroup |
assignment_group |
n |
reference |
Assignment group |
y |
y |
y |
BusinessDuration |
business_duration |
n |
Timer |
Business duration |
y |
y |
y |
CloseNotes |
close_notes |
n |
string |
Close notes |
y |
y |
y |
Closed |
closed_at |
n |
Datetime |
Closed |
y |
y |
y |
ClosedBy |
closed_by |
n |
reference |
Closed by |
y |
y |
y |
CommentsAndWorkNotes |
comments_and_work_notes |
n |
string |
Comments and Work notes |
y |
y |
y |
Company |
company |
n |
reference |
Company |
y |
y |
y |
ConfigurationItem |
cmdb_ci |
n |
reference |
Configuration item |
y |
y |
y |
ContactType |
contact_type |
n |
string |
Contact type |
y |
y |
y |
Contract |
contract |
n |
reference |
Contract |
y |
y |
y |
CorrelationDisplay |
correlation_display |
n |
string |
Correlation display |
y |
y |
y |
CorrelationID |
correlation_id |
n |
string |
Correlation ID |
y |
y |
y |
Created |
sys_created_on |
n |
Datetime |
Created |
n |
n |
n |
CreatedBy |
sys_created_by |
n |
string |
Created by |
n |
n |
n |
DeliveryPlan |
delivery_plan |
n |
reference |
Delivery plan |
y |
y |
y |
DeliveryTask |
delivery_task |
n |
reference |
Delivery task |
y |
y |
y |
Description |
description |
n |
string |
Description |
y |
y |
y |
Domain |
sys_domain |
n |
string |
Domain |
y |
y |
y |
DomainPath |
sys_domain_path |
n |
string |
Domain Path |
y |
y |
y |
DueDate |
due_date |
n |
Datetime |
Due date |
y |
y |
y |
Duration |
calendar_duration |
n |
Number |
Duration |
y |
y |
y |
EffectiveNumber |
task_effective_number |
n |
string |
Effective number |
y |
y |
y |
Escalation |
escalation |
n |
integer |
Escalation |
y |
y |
y |
ExpectedStart |
expected_start |
n |
Datetime |
Expected start |
y |
y |
y |
FollowUp |
follow_up |
n |
Datetime |
Follow up |
y |
y |
y |
GroupList |
group_list |
n |
string |
Group list |
y |
y |
y |
Impact |
impact |
n |
integer |
Impact |
y |
y |
y |
Knowledge |
knowledge |
n |
boolean |
Knowledge |
y |
y |
y |
Location |
location |
n |
reference |
Location |
y |
y |
y |
MadeSLA |
made_sla |
n |
boolean |
Made SLA |
y |
y |
y |
Number |
number |
n |
string |
Number |
y |
y |
y |
Opened |
opened_at |
n |
Datetime |
Opened |
y |
y |
y |
OpenedBy |
opened_by |
n |
reference |
Opened by |
y |
y |
y |
Order |
order |
n |
integer |
Order |
y |
y |
y |
Parent |
parent |
n |
reference |
Parent |
y |
y |
y |
Priority |
priority |
n |
integer |
Priority |
y |
y |
y |
ReassignmentCount |
reassignment_count |
n |
integer |
Reassignment count |
y |
y |
y |
RejectionGoto |
rejection_goto |
n |
reference |
Rejection goto |
y |
y |
y |
SLADue |
sla_due |
n |
Date |
SLA due |
y |
y |
y |
Service |
business_service |
n |
reference |
Service |
y |
y |
y |
ServiceOffering |
service_offering |
n |
reference |
Service offering |
y |
y |
y |
ShortDescription |
short_description |
n |
string |
Short description |
y |
y |
y |
State |
state |
n |
integer |
State |
n |
y* |
y* |
SysID |
sys_id |
n |
GUID |
Sys ID |
y |
y |
y |
TaskType |
sys_class_name |
n |
string |
Task type |
y |
y |
y |
TimeWorked |
time_worked |
n |
timer |
Time worked |
y |
y |
y |
TransferReason |
route_reason |
n |
integer |
Transfer reason |
y |
y |
y |
UniversalRequest |
universal_request |
n |
reference |
Universal Request |
y |
y |
y |
Updated |
sys_updated_on |
n |
Datetime |
Updated |
n |
n |
n |
UpdatedBy |
sys_updated_by |
n |
string |
Updated by |
n |
n |
n |
Updates |
sys_mod_count |
n |
integer |
Updates |
n |
n |
n |
UponApproval |
upon_approval |
n |
string |
Upon approval |
y |
y |
y |
UponReject |
upon_reject |
n |
string |
Upon reject |
y |
y |
y |
Urgency |
urgency |
n |
integer |
Urgency |
y |
y |
y |
UserInput |
user_input |
n |
string |
User input |
y |
y |
y |
Variables |
variables |
n |
variables |
Variables |
y |
y |
y |
WatchList |
watch_list |
n |
string |
Watch list |
y |
y |
y |
WorkNotes |
work_notes |
n |
string |
Work notes |
y |
y |
y |
WorkNotesList |
work_notes_list |
n |
string |
Work notes list |
y |
y |
y |
WorkflowActivity |
wf_activity |
n |
reference |
Workflow activity |
y |
y |
y |
Data Format: Catalog Task
The Catalog Task data format is used to query Catalog Tasks and add, modify and delete Catalog Tasks in ServiceNow.
Complete List of Fields in the Task Object
Attribute Name |
API Attribute Name |
MV |
Field Type |
Description |
Create |
Modify |
Delete |
Active |
active |
n |
boolean |
Active |
y |
y |
y |
ActivityDue |
activity_due |
n |
Date |
Activity due |
y |
y |
y |
ActualEnd |
work_end |
n |
Datetime |
Actual end |
y |
y |
y |
ActualStart |
work_start |
n |
Datetime |
Actual start |
y |
y |
y |
AdditionalAssigneeList |
additional_assignee_list |
n |
string |
Additional assignee list |
y |
y |
y |
AdditionalComments |
comments |
n |
string |
Additional comments |
y |
y |
y |
Approval |
approval |
n |
string |
Approval |
y |
y |
y |
ApprovalHistory |
approval_history |
n |
journal |
Approval history |
y |
y |
y |
ApprovalSet |
approval_set |
n |
Datetime |
Approval set |
y |
y |
y |
AssignedTo |
assigned_to |
n |
reference |
Assigned to |
y |
y |
y |
AssignmentGroup |
assignment_group |
n |
reference |
Assignment group |
y |
y |
y |
BusinessDuration |
business_duration |
n |
Timer |
Business duration |
y |
y |
y |
Catalog | sc_catalog | n | reference | Catalog | y | y | y |
CloseNotes |
close_notes |
n |
string |
Close notes |
y |
y |
y |
Closed |
closed_at |
n |
Datetime |
Closed |
y |
y |
y |
ClosedBy |
closed_by |
n |
reference |
Closed by |
y |
y |
y |
CommentsAndWorkNotes |
comments_and_work_notes |
n |
string |
Comments and Work notes |
y |
y |
y |
Company |
company |
n |
reference |
Company |
y |
y |
y |
ConfigurationItem |
cmdb_ci |
n |
reference |
Configuration item |
y |
y |
y |
ContactType |
contact_type |
n |
string |
Contact type |
y |
y |
y |
Contract |
contract |
n |
reference |
Contract |
y |
y |
y |
CorrelationDisplay |
correlation_display |
n |
string |
Correlation display |
y |
y |
y |
CorrelationID |
correlation_id |
n |
string |
Correlation ID |
y |
y |
y |
Created |
sys_created_on |
n |
Datetime |
Created |
n |
n |
n |
CreatedBy |
sys_created_by |
n |
string |
Created by |
n |
n |
n |
DeliveryPlan |
delivery_plan |
n |
reference |
Delivery plan |
y |
y |
y |
DeliveryTask |
delivery_task |
n |
reference |
Delivery task |
y |
y |
y |
Description |
description |
n |
string |
Description |
y |
y |
y |
Domain |
sys_domain |
n |
string |
Domain |
y |
y |
y |
DomainPath |
sys_domain_path |
n |
string |
Domain Path |
y |
y |
y |
DueDate |
due_date |
n |
Datetime |
Due date |
y |
y |
y |
Duration |
calendar_duration |
n |
Number |
Duration |
y |
y |
y |
EffectiveNumber |
task_effective_number |
n |
string |
Effective number |
y |
y |
y |
Escalation |
escalation |
n |
integer |
Escalation |
y |
y |
y |
ExpectedStart |
expected_start |
n |
Datetime |
Expected start |
y |
y |
y |
FollowUp |
follow_up |
n |
Datetime |
Follow up |
y |
y |
y |
GroupList |
group_list |
n |
string |
Group list |
y |
y |
y |
Impact |
impact |
n |
integer |
Impact |
y |
y |
y |
Knowledge |
knowledge |
n |
boolean |
Knowledge |
y |
y |
y |
Location |
location |
n |
reference |
Location |
y |
y |
y |
MadeSLA |
made_sla |
n |
boolean |
Made SLA |
y |
y |
y |
Number |
number |
n |
string |
Number |
y |
y |
y |
Opened |
opened_at |
n |
Datetime |
Opened |
y |
y |
y |
OpenedBy |
opened_by |
n |
reference |
Opened by |
y |
y |
y |
Order |
order |
n |
integer |
Order |
y |
y |
y |
Parent |
parent |
n |
reference |
Parent |
y |
y |
y |
Priority |
priority |
n |
integer |
Priority |
y |
y |
y |
ReassignmentCount |
reassignment_count |
n |
integer |
Reassignment count |
y |
y |
y |
RejectionGoto |
rejection_goto |
n |
reference |
Rejection goto |
y |
y |
y |
Request |
request |
n |
reference |
Request |
y |
y |
y |
RequestItem |
request_item |
n |
reference |
Request item |
y |
y |
y |
ResolveTime | calendar_stc | n | integer | Resolve Time | y | y | y |
SLADue |
sla_due |
n |
Date |
SLA due |
y |
y |
y |
Service |
business_service |
n |
reference |
Service |
y |
y |
y |
ServiceOffering |
service_offering |
n |
reference |
Service offering |
y |
y |
y |
ShortDescription |
short_description |
n |
string |
Short description |
y |
y |
y |
State |
state |
n |
integer |
State |
n |
y* |
y* |
SysID |
sys_id |
n |
GUID |
Sys ID |
y |
y |
y |
TaskType |
sys_class_name |
n |
string |
Task type |
y |
y |
y |
TimeWorked |
time_worked |
n |
timer |
Time worked |
y |
y |
y |
TransferReason |
route_reason |
n |
integer |
Transfer reason |
y |
y |
y |
UniversalRequest |
universal_request |
n |
reference |
Universal Request |
y |
y |
y |
Updated |
sys_updated_on |
n |
Datetime |
Updated |
n |
n |
n |
UpdatedBy |
sys_updated_by |
n |
string |
Updated by |
n |
n |
n |
Updates |
sys_mod_count |
n |
integer |
Updates |
n |
n |
n |
UponApproval |
upon_approval |
n |
string |
Upon approval |
y |
y |
y |
UponReject |
upon_reject |
n |
string |
Upon reject |
y |
y |
y |
Urgency |
urgency |
n |
integer |
Urgency |
y |
y |
y |
UserInput |
user_input |
n |
string |
User input |
y |
y |
y |
Variables |
variables |
n |
variables |
Variables |
y |
y |
y |
WatchList |
watch_list |
n |
string |
Watch list |
y |
y |
y |
WorkNotes |
work_notes |
n |
string |
Work notes |
y |
y |
y |
WorkNotesList |
work_notes_list |
n |
string |
Work notes list |
y |
y |
y |
WorkflowActivity |
wf_activity |
n |
reference |
Workflow activity |
y |
y |
y |
Data Format: Request
The Incident data format is used to query requests and add, modify and delete requests in ServiceNow .
Complete List of Fields in the Request Object
Attribute Name |
API Attribute Name |
MV |
Field Type |
Description |
Create |
Modify |
Delete |
Active |
active |
n |
boolean |
Active |
y |
y |
y |
ActivityDue |
activity_due |
n |
due_date |
Activity due |
y |
y |
y |
ActualEnd |
work_end |
n |
Datetime |
Actual end |
y |
y |
y |
ActualStart |
work_start |
n |
Datetime |
Actual start |
y |
y |
y |
AdditionalAssigneeList |
additional_assignee_list |
n |
string |
Additional assignee list |
y |
y |
y |
AdditionalComments |
comments |
n |
string |
Additional comments |
y |
y |
y |
Approval |
approval |
n |
string |
Approval |
y |
y |
y |
ApprovalHistory |
approval_history |
n |
journal |
Approval history |
y |
y |
y |
ApprovalSet |
approval_set |
n |
Datetime |
Approval set |
y |
y |
y |
AssignedTo |
assigned_to |
n |
reference |
Assigned to |
y |
y |
y |
AssignmentGroup |
assignment_group |
n |
reference |
Assignment group |
y |
y |
y |
BusinessDuration |
business_duration |
n |
glide_duration |
Business duration |
y |
y |
y |
Closed |
closed_at |
n |
Datetime |
Closed |
y |
y |
y |
ClosedBy |
closed_by |
n |
reference |
Closed by |
y |
y |
y |
CloseNotes |
close_notes |
n |
string |
Close notes |
y |
y |
y |
CommentsAndWorkNotes |
comments_and_work_notes |
n |
string |
Comments and Work notes |
y |
y |
y |
Company |
company |
n |
reference |
Company |
y |
y |
y |
ConfigurationItem |
cmdb_ci |
n |
reference |
Configuration item |
y |
y |
y |
ContactType |
contact_type |
n |
string |
Contact type |
y |
y |
y |
Contract |
contract |
n |
reference |
Contract |
y |
y |
y |
CorrelationDisplay |
correlation_display |
n |
string |
Correlation display |
y |
y |
y |
CorrelationID |
correlation_id |
n |
string |
Correlation ID |
y |
y |
y |
Created |
sys_created_on |
n |
Datetime |
Created |
n |
n |
n |
CreatedBy |
sys_created_by |
n |
string |
Created by |
n |
n |
n |
DeliveryAddress |
delivery_address |
n |
string |
Delivery address |
y |
y |
y |
DeliveryPlan |
delivery_plan |
n |
reference |
Delivery plan |
y |
y |
y |
DeliveryTask |
delivery_task |
n |
reference |
Delivery task |
y |
y |
y |
Description |
description |
n |
string |
Description |
y |
y |
y |
Domain |
sys_domain |
n |
domain_id |
Domain |
y |
y |
y |
DomainPath |
sys_domain_path |
n |
domain_path |
Domain Path |
y |
y |
y |
DueDate |
due_date |
n |
Datetime |
Due date |
y |
y |
y |
Duration |
calendar_duration |
n |
glide_duration |
Duration |
y |
y |
y |
EffectiveNumber |
task_effective_number |
n |
string |
Effective number |
y |
y |
y |
Escalation |
escalation |
n |
integer |
Escalation |
y |
y |
y |
ExpectedStart |
expected_start |
n |
Datetime |
Expected start |
y |
y |
y |
FollowUp |
follow_up |
n |
Datetime |
Follow up |
y |
y |
y |
GroupList |
group_list |
n |
string |
Group list |
y |
y |
y |
Impact |
impact |
n |
integer |
Impact |
y |
y |
y |
Knowledge |
knowledge |
n |
boolean |
Knowledge |
y |
y |
y |
Location |
location |
n |
reference |
Location |
y |
y |
y |
MadeSLA |
made_sla |
n |
boolean |
Made SLA |
y |
y |
y |
Number |
number |
n |
string |
Number |
y |
y |
y |
Opened |
opened_at |
n |
Datetime |
Opened |
y |
y |
y |
OpenedBy |
opened_by |
n |
reference |
Opened by |
y |
y |
y |
Order |
order |
n |
integer |
Order |
y |
y |
y |
Parent |
parent |
n |
reference |
Parent |
y |
y |
y |
ParentInteraction |
parent_interaction |
n |
reference |
Parent interaction |
y |
y |
y |
Price |
price |
n |
currency |
Price |
y |
y |
y |
Priority |
priority |
n |
integer |
Priority |
y |
y |
y |
ReassignmentCount |
reassignment_count |
n |
integer |
Reassignment count |
y |
y |
y |
RejectionGoto |
rejection_goto |
n |
reference |
Rejection goto |
y |
y |
y |
RequestedFor |
requested_for |
n |
reference |
Requested for |
y |
y |
y |
RequestedForDate |
requested_date |
n |
glide_date |
Requested for date |
y |
y |
y |
RequestItem->Active |
active |
n |
boolean |
Active |
y |
y |
y |
RequestItem->ActivityDue |
activity_due |
n |
due_date |
Activity due |
y |
y |
y |
RequestItem->ActualEnd |
work_end |
n |
Datetime |
Actual end |
y |
y |
y |
RequestItem->ActualStart |
work_start |
n |
Datetime |
Actual start |
y |
y |
y |
RequestItem->AdditionalAssigneeList |
additional_assignee_list |
n |
string |
Additional assignee list |
y |
y |
y |
RequestItem->AdditionalComments |
comments |
n |
string |
Additional comments |
y |
y |
y |
RequestItem->Approval |
approval |
n |
string |
Approval |
y |
y |
y |
RequestItem->ApprovalHistory |
approval_history |
n |
journal |
Approval history |
y |
y |
y |
RequestItem->ApprovalSet |
approval_set |
n |
Datetime |
Approval set |
y |
y |
y |
RequestItem->AssignedTo |
assigned_to |
n |
reference |
Assigned to |
y |
y |
y |
RequestItem->AssignmentGroup |
assignment_group |
n |
reference |
Assignment group |
y |
y |
y |
RequestItem->Backordered |
backordered |
n |
boolean |
Backordered |
y |
y |
y |
RequestItem->Billable |
billable |
n |
boolean |
Billable |
y |
y |
y |
RequestItem->BusinessDuration |
business_duration |
n |
glide_duration |
Business duration |
y |
y |
y |
RequestItem->Catalog |
sc_catalog |
n |
reference |
Catalog |
y |
y |
y |
RequestItem->Closed |
closed_at |
n |
Datetime |
Closed |
y |
y |
y |
RequestItem->ClosedBy |
closed_by |
n |
reference |
Closed by |
y |
y |
y |
RequestItem->CloseNotes |
close_notes |
n |
string |
Close notes |
y |
y |
y |
RequestItem->CommentsAndWorkNotes |
comments_and_work_notes |
n |
string |
Comments and Work notes |
y |
y |
y |
RequestItem->Company |
company |
n |
reference |
Company |
y |
y |
y |
RequestItem->ConfigurationItem |
cmdb_ci |
n |
reference |
Configuration item |
y |
y |
y |
RequestItem->ConfigurationItem |
configuration_item |
n |
reference |
Configuration item |
y |
y |
y |
RequestItem->ContactType |
contact_type |
n |
string |
Contact type |
y |
y |
y |
RequestItem->Context |
context |
n |
reference |
Context |
y |
y |
y |
RequestItem->Contract |
contract |
n |
reference |
Contract |
y |
y |
y |
RequestItem->CorrelationDisplay |
correlation_display |
n |
string |
Correlation display |
y |
y |
y |
RequestItem->CorrelationID |
correlation_id |
n |
string |
Correlation ID |
y |
y |
y |
RequestItem->Created |
sys_created_on |
n |
Datetime |
Created |
n |
n |
n |
RequestItem->CreatedBy |
sys_created_by |
n |
string |
Created by |
n |
n |
n |
RequestItem->DeliveryPlan |
delivery_plan |
n |
reference |
Delivery plan |
y |
y |
y |
RequestItem->DeliveryTask |
delivery_task |
n |
reference |
Delivery task |
y |
y |
y |
RequestItem->Description |
description |
n |
string |
Description |
y |
y |
y |
RequestItem->Domain |
sys_domain |
n |
domain_id |
Domain |
y |
y |
y |
RequestItem->DomainPath |
sys_domain_path |
n |
domain_path |
Domain Path |
y |
y |
y |
RequestItem->DueDate |
due_date |
n |
Datetime |
Due date |
y |
y |
y |
RequestItem->Duration |
calendar_duration |
n |
glide_duration |
Duration |
y |
y |
y |
RequestItem->EffectiveNumber |
task_effective_number |
n |
string |
Effective number |
y |
y |
y |
RequestItem->Escalation |
escalation |
n |
integer |
Escalation |
y |
y |
y |
RequestItem->EstimatedDelivery |
estimated_delivery |
n |
Datetime |
Estimated delivery |
y |
y |
y |
RequestItem->ExpectedStart |
expected_start |
n |
Datetime |
Expected start |
y |
y |
y |
RequestItem->FlowContext |
flow_context |
n |
reference |
Flow Context |
y |
y |
y |
RequestItem->FollowUp |
follow_up |
n |
Datetime |
Follow up |
y |
y |
y |
RequestItem->GroupList |
group_list |
n |
string |
Group list |
y |
y |
y |
RequestItem->Impact |
impact |
n |
integer |
Impact |
y |
y |
y |
RequestItem->Item |
cat_item |
n |
reference |
Item |
y |
y |
y |
RequestItem->Knowledge |
knowledge |
n |
boolean |
Knowledge |
y |
y |
y |
RequestItem->Location |
location |
n |
reference |
Location |
y |
y |
y |
RequestItem->MadeSLA |
made_sla |
n |
boolean |
Made SLA |
y |
y |
y |
RequestItem->Number |
number |
n |
string |
Number |
y |
y |
y |
RequestItem->Opened |
opened_at |
n |
Datetime |
Opened |
y |
y |
y |
RequestItem->OpenedBy |
opened_by |
n |
reference |
Opened by |
y |
y |
y |
RequestItem->Order |
order |
n |
integer |
Order |
y |
y |
y |
RequestItem->OrderGuide |
order_guide |
n |
reference |
Order Guide |
y |
y |
y |
RequestItem->Parent |
parent |
n |
reference |
Parent |
y |
y |
y |
RequestItem->Price |
price |
n |
currency |
Price |
y |
y |
y |
RequestItem->Priority |
priority |
n |
integer |
Priority |
y |
y |
y |
RequestItem->Quantity |
quantity |
n |
integer |
Quantity |
y |
y |
y |
RequestItem->ReassignmentCount |
reassignment_count |
n |
integer |
Reassignment count |
y |
y |
y |
RequestItem->RecurringPrice |
recurring_price |
n |
price |
Recurring Price |
y |
y |
y |
RequestItem->RecurringPriceFrequency |
recurring_frequency |
n |
choice |
Recurring Price Frequency |
y |
y |
y |
RequestItem->RejectionGoto |
rejection_goto |
n |
reference |
Rejection goto |
y |
y |
y |
RequestItem->Request |
request |
n |
reference |
Request |
y |
y |
y |
RequestItem->RequestedFor |
requested_for |
n |
reference |
Requested for |
y |
y |
y |
RequestItem->Service |
business_service |
n |
reference |
Service |
y |
y |
y |
RequestItem->ServiceOffering |
service_offering |
n |
reference |
Service offering |
y |
y |
y |
RequestItem->ShortDescription |
short_description |
n |
string |
Short description |
y |
y |
y |
RequestItem->SLADue |
sla_due |
n |
due_date |
SLA due |
y |
y |
y |
RequestItem->Stage |
stage |
n |
workflow |
Stage |
y |
y |
y |
RequestItem->State |
state |
n |
integer |
State |
y |
y |
y |
RequestItem->SysID |
sys_id |
n |
GUID |
Sys ID |
y |
y |
y |
RequestItem->TaskType |
sys_class_name |
n |
sys_class_name |
Task type |
y |
y |
y |
RequestItem->TimeWorked |
time_worked |
n |
timer |
Time worked |
y |
y |
y |
RequestItem->TransferReason |
route_reason |
n |
integer |
Transfer reason |
y |
y |
y |
RequestItem->UniversalRequest |
universal_request |
n |
reference |
Universal Request |
y |
y |
y |
RequestItem->Updated |
sys_updated_on |
n |
Datetime |
Updated |
n |
n |
n |
RequestItem->UpdatedBy |
sys_updated_by |
n |
string |
Updated by |
n |
n |
n |
RequestItem->Updates |
sys_mod_count |
n |
integer |
Updates |
n |
n |
n |
RequestItem->UponApproval |
upon_approval |
n |
string |
Upon approval |
y |
y |
y |
RequestItem->UponReject |
upon_reject |
n |
string |
Upon reject |
y |
y |
y |
RequestItem->Urgency |
urgency |
n |
integer |
Urgency |
y |
y |
y |
RequestItem->UserInput |
user_input |
n |
user_input |
User input |
y |
y |
y |
RequestItem->Variable->CartItem |
cart_item |
n |
reference |
Cart item |
y |
y |
y |
RequestItem->Variable->Created |
sys_created_on |
n |
Datetime |
Created |
n |
n |
n |
RequestItem->Variable->CreatedBy |
sys_created_by |
n |
string |
Created by |
n |
n |
n |
RequestItem->Variable->DependentItem |
sc_item_option |
n |
reference |
Dependent Item |
y |
y |
y |
RequestItem->Variable->Order |
order |
n |
integer |
Order |
y |
y |
y |
RequestItem->Variable->ParentItem |
request_item |
n |
reference |
Parent Item |
y |
y |
y |
RequestItem->Variable->Question |
item_option_new |
n |
reference |
Question |
y |
y |
y |
RequestItem->Variable->ScCatItemOption |
sc_cat_item_option |
n |
reference |
Sc cat item option |
y |
y |
y |
RequestItem->Variable->SysID |
sys_id |
n |
GUID |
Sys ID |
y |
y |
y |
RequestItem->Variable->Updated |
sys_updated_on |
n |
Datetime |
Updated |
n |
n |
n |
RequestItem->Variable->UpdatedBy |
sys_updated_by |
n |
string |
Updated by |
n |
n |
n |
RequestItem->Variable->Updates |
sys_mod_count |
n |
integer |
Updates |
n |
n |
n |
RequestItem->Variable->Value |
value |
n |
string |
Value |
y |
y |
y |
RequestItem->Variables |
variables |
n |
variables |
Variables |
y |
y |
y |
RequestItem->WatchList |
watch_list |
n |
string |
Watch list |
y |
y |
y |
RequestItem->WorkflowActivity |
wf_activity |
n |
reference |
Workflow activity |
y |
y |
y |
RequestItem->WorkNotes |
work_notes |
n |
string |
Work notes |
y |
y |
y |
RequestItem->WorkNotesList |
work_notes_list |
n |
string |
Work notes list |
y |
y |
y |
RequestState |
request_state |
n |
string |
Request state |
y |
y |
y |
ResolveTime |
calendar_stc |
n |
integer |
Resolve Time |
y |
y |
y |
Service |
business_service |
n |
reference |
Service |
y |
y |
y |
ServiceOffering |
service_offering |
n |
reference |
Service offering |
y |
y |
y |
ShortDescription |
short_description |
n |
string |
Short description |
y |
y |
y |
SLADue |
sla_due |
n |
due_date |
SLA due |
y |
y |
y |
SpecialInstructions |
special_instructions |
n |
string |
Special instructions |
y |
y |
y |
Stage |
stage |
n |
workflow |
Stage |
y |
y |
y |
State |
state |
n |
integer |
State |
y |
y |
y |
SysID |
sys_id |
n |
GUID |
Sys ID |
n |
y* |
y* |
TaskType |
sys_class_name |
n |
sys_class_name |
Task type |
y |
y |
y |
TimeWorked |
time_worked |
n |
timer |
Time worked |
y |
y |
y |
TransferReason |
route_reason |
n |
integer |
Transfer reason |
y |
y |
y |
UniversalRequest |
universal_request |
n |
reference |
Universal Request |
y |
y |
y |
Updated |
sys_updated_on |
n |
Datetime |
Updated |
n |
n |
n |
UpdatedBy |
sys_updated_by |
n |
string |
Updated by |
n |
n |
n |
Updates |
sys_mod_count |
n |
integer |
Updates |
n |
n |
n |
UponApproval |
upon_approval |
n |
string |
Upon approval |
y |
y |
y |
UponReject |
upon_reject |
n |
string |
Upon reject |
y |
y |
y |
Urgency |
urgency |
n |
integer |
Urgency |
y |
y |
y |
UserInput |
user_input |
n |
user_input |
User input |
y |
y |
y |
Variables |
variables |
n |
variables |
Variables |
y |
y |
y |
WatchList |
watch_list |
n |
string |
Watch list |
y |
y |
y |
WorkflowActivity |
wf_activity |
n |
reference |
Workflow activity |
y |
y |
y |
WorkNotes |
work_notes |
n |
string |
Work notes |
y |
y |
y |
WorkNotesList |
work_notes_list |
n |
string |
Work notes list |
y |
y |
y |
Data Format: Approval
The Incident data format is used to query approvals and add, modify and delete approvals in ServiceNow .
Complete List of Fields in the Approval Object
Attribute Name |
API Attribute Name |
MV |
Field Type |
Description |
Create |
Modify |
Delete |
ApprovalColumn |
approval_column |
n |
field_name |
Approval Column |
y |
y |
y |
ApprovalFor |
sysapproval |
n |
reference |
Approval for |
y |
y |
y |
ApprovalJournalColumn |
approval_journal_column |
n |
field_name |
Approval Journal Column |
y |
y |
y |
ApprovalSource |
approval_source |
n |
string |
Approval source |
y |
y |
y |
Approver |
approver |
n |
reference |
Approver |
y |
y |
y |
Approving |
document_id |
n |
string |
Approving |
y |
y |
y |
Comments |
comments |
n |
string |
Comments |
y |
y |
y |
Created |
sys_created_on |
n |
Datetime |
Created |
n |
n |
n |
CreatedBy |
sys_created_by |
n |
string |
Created by |
n |
n |
n |
DueDate |
due_date |
n |
Datetime |
Due date |
y |
y |
y |
ExpectedStart |
expected_start |
n |
Datetime |
Expected start |
y |
y |
y |
Group |
group |
n |
reference |
Group |
y |
y |
y |
Iteration |
iteration |
n |
integer |
Iteration |
y |
y |
y |
Order |
order |
n |
integer |
Order |
y |
y |
y |
ProcessStep |
process_step |
n |
reference |
Process step |
y |
y |
y |
SourceTable |
source_table |
n |
table_name |
Source table |
y |
y |
y |
State |
state |
n |
string |
State |
y |
y |
y |
StateBinding |
state_binding |
n |
reference |
State binding |
y |
y |
y |
SysID |
sys_id |
n |
GUID |
Sys ID |
n |
y* |
y* |
Updated |
sys_updated_on |
n |
Datetime |
Updated |
n |
n |
n |
UpdatedBy |
sys_updated_by |
n |
string |
Updated by |
n |
n |
n |
Updates |
sys_mod_count |
n |
integer |
Updates |
n |
n |
n |
WorkflowActivity |
wf_activity |
n |
reference |
Workflow activity |
y |
y |
y |
Data Format: Incident
The Incident data format is used to query incidents and add, modify and delete incidents in ServiceNow .
Complete List of Fields in the Incident Object
Attribute Name |
API Attribute Name |
MV |
Field Type |
Description |
Create |
Modify |
Delete |
Active |
active |
n |
boolean |
Active |
y |
y |
y |
ActivityDue |
activity_due |
n |
Date |
Activity due |
y |
y |
y |
ActualEnd |
work_end |
n |
Datetime |
Actual end |
y |
y |
y |
ActualStart |
work_start |
n |
Datetime |
Actual start |
y |
y |
y |
AdditionalAssigneeList |
additional_assignee_list |
n |
string |
Additional assignee list |
y |
y |
y |
AdditionalComments |
comments |
n |
string |
Additional comments |
y |
y |
y |
Approval |
approval |
n |
string |
Approval |
y |
y |
y |
ApprovalHistory |
approval_history |
n |
journal |
Approval history |
y |
y |
y |
ApprovalSet |
approval_set |
n |
Datetime |
Approval set |
y |
y |
y |
AssignedTo |
assigned_to |
n |
reference |
Assigned to |
y |
y |
y |
AssignmentGroup |
assignment_group |
n |
reference |
Assignment group |
y |
y |
y |
BusinessDuration |
business_duration |
n |
Timer |
Business duration |
y |
y |
y |
BusinessResolveTime |
business_stc |
n |
Integer |
Business resolve time |
y |
y |
y |
Caller |
caller_id |
n |
reference |
Caller |
y |
y |
y |
Category |
category |
n |
string |
Category |
y |
y |
y |
CausedByChange |
caused_by |
n |
reference |
Caused by Change |
y |
y |
y |
ChangeRequest |
rfc |
n |
reference |
Change Request |
y |
y |
y |
ChildIncidents |
child_incidents |
n |
integer |
Child Incidents |
y |
y |
y |
CloseCode |
close_code |
n |
string |
Close code |
y |
y |
y |
CloseNotes |
close_notes |
n |
string |
Close notes |
y |
y |
y |
Closed |
closed_at |
n |
Datetime |
Closed |
y |
y |
y |
ClosedBy |
closed_by |
n |
reference |
Closed by |
y |
y |
y |
CommentsAndWorkNotes |
comments_and_work_notes |
n |
string |
Comments and Work notes |
y |
y |
y |
Company |
company |
n |
reference |
Company |
y |
y |
y |
ConfigurationItem |
cmdb_ci |
n |
reference |
Configuration item |
y |
y |
y |
ContactType |
contact_type |
n |
string |
Contact type |
y |
y |
y |
Contract |
contract |
n |
reference |
Contract |
y |
y |
y |
CorrelationDisplay |
correlation_display |
n |
string |
Correlation display |
y |
y |
y |
CorrelationID |
correlation_id |
n |
string |
Correlation ID |
y |
y |
y |
Created |
sys_created_on |
n |
Datetime |
Created |
n |
n |
n |
CreatedBy |
sys_created_by |
n |
string |
Created by |
n |
n |
n |
DeliveryPlan |
delivery_plan |
n |
reference |
Delivery plan |
y |
y |
y |
DeliveryTask |
delivery_task |
n |
reference |
Delivery task |
y |
y |
y |
Description |
description |
n |
string |
Description |
y |
y |
y |
Domain |
sys_domain |
n |
string |
Domain |
y |
y |
y |
DomainPath |
sys_domain_path |
n |
string |
Domain Path |
y |
y |
y |
DueDate |
due_date |
n |
Datetime |
Due date |
y |
y |
y |
Duration |
calendar_duration |
n |
Number |
Duration |
y |
y |
y |
EffectiveNumber |
task_effective_number |
n |
string |
Effective number |
y |
y |
y |
Escalation |
escalation |
n |
integer |
Escalation |
y |
y |
y |
ExpectedStart |
expected_start |
n |
Datetime |
Expected start |
y |
y |
y |
FollowUp |
follow_up |
n |
Datetime |
Follow up |
y |
y |
y |
GroupList |
group_list |
n |
string |
Group list |
y |
y |
y |
Impact |
impact |
n |
integer |
Impact |
y |
y |
y |
IncidentState |
incident_state |
n |
integer |
Incident state |
y |
y |
y |
Knowledge |
knowledge |
n |
boolean |
Knowledge |
y |
y |
y |
LastReopenedAt |
reopened_time |
n |
Datetime |
Last reopened at |
y |
y |
y |
LastReopenedBy |
reopened_by |
n |
reference |
Last reopened by |
y |
y |
y |
Location |
location |
n |
reference |
Location |
y |
y |
y |
MadeSLA |
made_sla |
n |
boolean |
Made SLA |
y |
y |
y |
Notify |
notify |
n |
integer |
Notify |
y |
y |
y |
Number |
number |
n |
string |
Number |
y |
y |
y |
OnHoldReason |
hold_reason |
n |
integer |
On hold reason |
y |
y |
y |
Opened |
opened_at |
n |
Datetime |
Opened |
y |
y |
y |
OpenedBy |
opened_by |
n |
reference |
Opened by |
y |
y |
y |
Order |
order |
n |
integer |
Order |
y |
y |
y |
Parent |
parent |
n |
reference |
Parent |
y |
y |
y |
ParentIncident |
parent_incident |
n |
reference |
Parent Incident |
y |
y |
y |
Priority |
priority |
n |
integer |
Priority |
y |
y |
y |
Problem |
problem_id |
n |
reference |
Problem |
y |
y |
y |
ReassignmentCount |
reassignment_count |
n |
integer |
Reassignment count |
y |
y |
y |
RejectionGoto |
rejection_goto |
n |
reference |
Rejection goto |
y |
y |
y |
ReopenCount |
reopen_count |
n |
integer |
Reopen count |
y |
y |
y |
ResolveTime |
calendar_stc |
n |
integer |
Resolve time |
y |
y |
y |
Resolved |
resolved_at |
n |
Datetime |
Resolved |
y |
y |
y |
ResolvedBy |
resolved_by |
n |
reference |
Resolved by |
y |
y |
y |
SLADue |
sla_due |
n |
Date |
SLA due |
y |
y |
y |
Service |
business_service |
n |
reference |
Service |
y |
y |
y |
ServiceOffering |
service_offering |
n |
reference |
Service offering |
y |
y |
y |
Severity |
severity |
n |
integer |
Severity |
y |
y |
y |
ShortDescription |
short_description |
n |
string |
Short description |
y |
y |
y |
State |
state |
n |
integer |
State |
n |
y* |
y* |
Subcategory |
subcategory |
n |
string |
Subcategory |
y |
y |
y |
SysID |
sys_id |
n |
GUID |
Sys ID |
y |
y |
y |
TaskType |
sys_class_name |
n |
string |
Task type |
y |
y |
y |
TimeWorked |
time_worked |
n |
timer |
Time worked |
y |
y |
y |
TransferReason |
route_reason |
n |
integer |
Transfer reason |
y |
y |
y |
UniversalRequest |
universal_request |
n |
reference |
Universal Request |
y |
y |
y |
Updated |
sys_updated_on |
n |
Datetime |
Updated |
n |
n |
n |
UpdatedBy |
sys_updated_by |
n |
string |
Updated by |
n |
n |
n |
Updates |
sys_mod_count |
n |
integer |
Updates |
n |
n |
n |
UponApproval |
upon_approval |
n |
string |
Upon approval |
y |
y |
y |
UponReject |
upon_reject |
n |
string |
Upon reject |
y |
y |
y |
Urgency |
urgency |
n |
integer |
Urgency |
y |
y |
y |
UserInput |
user_input |
n |
string |
User input |
y |
y |
y |
Variables |
variables |
n |
variables |
Variables |
y |
y |
y |
WatchList |
watch_list |
n |
string |
Watch list |
y |
y |
y |
WorkNotes |
work_notes |
n |
string |
Work notes |
y |
y |
y |
WorkNotesList |
work_notes_list |
n |
string |
Work notes list |
y |
y |
y |
WorkflowActivity |
wf_activity |
n |
reference |
Workflow activity |
y |
y |
y |