Using the ServiceNow REST Import Wizard
By using the ServiceNow REST Import Wizard, you browse your object definitions in real time, based on the action you specified, to get any fields you have defined.
Procedure
-
Create or open a ServiceNow REST operation.
-
In the Connector Action field select Get, Create, Update, Delete, Query, or Advanced Query.
-
Click the Import button.
The ServiceNow REST Import Wizard opens.
-
Choose the runtime and ServiceNow REST connection that connects to the ServiceNow account instance.
A runtime must be deployed to browse the object definitions.
-
Complete one of the follow options that corresponds to the connector action selected.
-
If you selected Get:
-
Select a value in the Display Value drop-down list.
Display Value determines what value the database returns for fields (the Display Value, the Actual Value, or Both). For example, a field may represent the task status as Not Started, In Progress, or Done. The database, however, represents the task status as 1, 2, and 3.
-
Select Display Value to have the database return the display value for all fields. In this example, the database returns the task status as Not Started.
-
Select Actual Value to have the database return the actual value for all fields. In this example, the database returns the task status as 1.
-
Select Both to have the database return both the display value and actual value for all fields. In this example, the database returns task status as both 1 and Not Started.
-
In the View field, optionally enter the UI view to determine the fields that the response returns. This field is optional, and if you do not enter a view, all fields are returned.
-
In the Filter field, enter a filter to reduce the number of returned fields by entering the introduced text contained in the display name for tables.
-
Click Next.
-
Select an object type in the Object Type drop-down list.
-
When the operation has loaded, review the information and click Finish.
Once the import of the JSON profiles and the setup of the connector operation has completed, your imported JSON profiles are populated in the Options tab.
-
-
If you selected Create:
-
Select a value in the Display Value drop-down list.
Display Value determines what value is inserted into the database for fields (the Value, the Display value, or Both). For example, a field may represent the task status as Not Started, In Progress, or Done. The database, however, represents the task status as 1, 2, and 3.
-
Select Value to have the database store the actual value for all fields. In this example, the database stores the task status as 1.
-
Select Display value to have the database store the display value for all fields. In this example, the database stores the task status as Not Started.
-
Select Both to have the database store both the display value and actual value for all fields. In this example, the database stores the task status as both 1 and Not Started.
We recommend that you choose Value, instead of Display value, so the database treats the values as actual values and stores them in the database without manipulation. This setting only applies when you clear No response body. If No response body is selected, ServiceNow does not provide a response to the connector.
-
In the View field, enter the UI view to determine the fields that the response returns. This field is optional, and if you do not enter a view, all fields are returned.
-
Select No response body to suppress the response body content from ServiceNow and not include information about the new record.
-
Select Input display value to treat input values as display values and manipulate them so they can be stored properly in the database. Clear this check box to treat input values as actual values and store them in the database without manipulation.
-
In the Filter field, enter a filter to reduce the number of returned fields by entering the introduced text contained in the display name for tables.
-
Click Next.
-
Select an object type in the Object Type drop-down list.
-
When the operation has loaded, review the information and click Finish.
Once the import of the JSON profiles and the setup of the connector operation has completed, your imported JSON profiles are populated in the Options tab.
-
-
If you selected Update:
-
Select a value in the Display Value drop-down list.
Display Value determines what value is updated in the database for fields (the Value, the Display value, or Both). For example, a field may represent the task status as Not Started, In Progress, or Done. The database, however, represents the task status as 1, 2, and 3.
-
Select Value to have the database update the actual value for all fields. In this example, the database updates the task status as 1.
-
Select Display value to have the database update the display value for all fields. In this example, the database updates the task status as Not Started.
-
Select Both to have the database update both the display value and actual value for all fields. In this example, the database updates the task status as both 1 and Not Started.
We recommend that you choose Value, instead of Display value, so the database treats the values as actual values and stores them in the database without manipulation. This setting only applies when you clear No response body. If No response body is selected, ServiceNow does not provide a response to the connector.
-
In the View field, enter the UI view to determine the fields that the response returns. This field is optional, and if you do not enter a view, all fields are returned.
-
Select No response body to suppress the response body content from ServiceNow and not include information about the new record.
-
Select Input display value to treat input values as display values and manipulate them so they can be stored properly in the database. Clear this check box to treat input values as actual values and store them in the database without manipulation.
-
In the Filter field, enter a filter to reduce the number of returned fields by entering the introduced text contained in the display name for tables.
-
Click Next.
-
Select an object type in the Object Type drop-down list.
-
When the operation has loaded, review the information and click Finish.
Once the import of the JSON profiles and the setup of the connector operation has completed, your imported JSON profiles are populated in the Options tab.
-
-
If you selected Delete:
-
In the Filter field, enter a filter to reduce the number of returned fields by entering the introduced text contained in the display name for tables.
-
Click Next.
-
Select an object type in the Object Type drop-down list.
-
When the operation has loaded, review the information and click Finish.
Once the import of the JSON profiles and the setup of the connector operation has completed, your imported JSON profiles are populated in the Options tab.
-
-
If you selected Query or Advanced Query:
-
Select a value in the Display Value drop-down list.
Display Value determines what value the database returns for fields (the Display Value, the Actual Value, or Both). For example, a field may represent the task status as Not Started, In Progress, or Done. The database, however, represents the task status as 1, 2, and 3.
-
Select Display value to have the database return the display value for all fields. In this example, the database returns the task status as Not Started.
-
Select Actual Value to have the database return the actual value for all fields. In this example, the database returns the task status as 1.
-
Select Both to have the database return both the display value and actual value for all fields. In this example, the database returns task status as both 1 and Not Started.
-
In the View field, enter the UI view to determine the fields that the response returns. This field is optional, and if you do not enter a view, all fields are returned.
-
In the Filter field, enter a filter to reduce the number of returned fields by entering the introduced text contained in the display name for tables.
-
Click Next.
-
Select an object type in the Object Type drop-down list.
-
When the operation has loaded, review the information and click Finish.
Once the import of the JSON profiles and the setup of the connector operation has completed, your imported JSON profiles are populated in the Options tab.
-
-
Click Save.