ServiceNow OAuth Connector

About

ServiceNow is a software platform that supports IT service management and automates common business practices. You can combine your ServiceNow data with data from other systems in Domo, so you can see the end-to-end customer experience and fix any issues faster. Get a quick, interactive view of all your data, fully integrated, to help you spend less time gathering data and make faster, better business decisions.

You can connect to your ServiceNow OAuth account in the Data Center. This article explains the fields and menus that are specific to the ServiceNow OAuth Connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Data Connector.

Prerequisites

To connect to your ServiceNow OAuth account and create a DataSet, you must have the following:

• Instance Name
• Client ID
• Client Secret
• After the instance name, client ID, and client secret are entered, you are redirected to the ServiceNow sign‑in page, where you must enter your username and password.

Connecting to Your ServiceNow OAuth Account

This section lists the options in the Credentials and Details panes in the ServiceNow OAuth Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in great detail in Adding a DataSet Using a Data Connector.

Credentials Pane

This pane contains fields for entering credentials to connect to your ServiceNow OAuth account. The following table describes what is needed for each field:

Field	Description
Instance Name	Enter the ServiceNow instance name. For example, https://instance.service-now.com
Client ID	Enter the OAuth Application configured client id.
Client Secret	Enter the OAuth Application configured client secret.

Once you have entered valid ServiceNow OAuth credentials, you can use the same account to create a new ServiceNow OAuth DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

Details Pane

This pane contains a primary Reports menu, along with various other menus which may or may not appear depending on the report type you select.

Menu	Description
Report	Select the ServiceNow OAuth report you want to run. The following reports are available:				---	---		Report Name	Description		Standard Table	Select from a list of standard tables from Service Now.		Custom Query	Creates a custom query and includes the ability to select which fields can be returned to the DataSet.		Custom Table	Provides a custom table name to retrieve the data from.
Table					---	---		Table	Description		Incident	Retrieves all data from the incident table.		Change Request	Retrieves all data from the change request table.		Problem	Retrieves all data from the problem table.		User Groups	Retrieves all data from the user groups table.		Users	Retrieves all data from the users table.
Table Name	Enter the name of the table for which you want to retrieve the data.
Custom Query	Enter a custom query in this field. Include only the values that are directly related to sysparm_query. Do not include the parameters sysparm_limit or sysparm_offset. If you include the sys_created_on field, use the following date–time format: yyyy-MM-dd HH:mm:ss Example query: ORDERBYDESCsys_created_on^sys_created_on>2016-09-25+00:00:00^sys_created_on<2016-09-27+23:59:59 More Information: see the documentation.
Fields	Enter a comma‑separated list of fields to return with this DataSet. Example field list: parent,sys_updated_on,number
Data Date Format	Select the format in which you expect the ServiceNow API to return date fields. If you select String, Domo does not process the date and returns the exact string provided by the ServiceNow API.
Duration	Select the duration for the report (a Single Date or a Date Range).
Report Date	Select whether the report data is for a specific date or for a relative number of days back from today. Relative Date: Enter the number of days back from today. Specific Date: Use the date picker to select a precise date.
Select Specific Date	Select the date for the report using the date selector. The date cannot be before January 1, 2000, and must not be a future date.
Days Back	Specify the number of days before today for which you want to retrieve the data. Enter 0 for today, 1 for yesterday, or 7 for 7days ago, and so on
Start Date	Select the report start date using relative or specific dates. Relative indicates the number of days from today or a specific date using the date selector.
The specific start date for the report (date from)	Select the report start date using the date selector.
Days back to start from	The number of days back that you would like to get data from (start day). Specify either today or 0, yesterday or 1, or today-7 or 7 to get data for 7 days into the past.
End Date	Select the report end date using relative or specific dates. Relative indicates the umber of days from today or a specific date using the date selector
Select Specific End Date	Select the report date using the date selector. The date cannot be before January 1, 2000, and must not be a future date.
Days back to end at	The number of days back that you would like to get data to (end day). Specify either today or 0, yesterday or 1, or today-7 or 7 to get data for 7 days into the past.
Display Values	When this option is enabled, the connector returns human‑readable display values for reference fields, rather than internal sys_id values.

Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.