Invoke Operations Page

Select the operation and the application and module on which to perform the operation in the ServiceNow application. The fields that appear are based on the option that you selected on the Action page.

Create, Update, or Delete Information

Note:

Ensure that the Integration User has the appropriate permissions (such as, can query, can create, can update, and can delete) on the table on which to perform the operation in the ServiceNow application.

If you selected Create, Update, or Delete Information on the Action page, the following options are displayed:

Element	Description
Select Application	Use the scrolling list to select an application within the selected operation. Note: This field is not displayed when you create a ServiceNow Adapter connection with minimal accesses to the tables. See Prerequisites for Creating a Connection.
Filter By Application Name	Enter the initial letters of the application name to filter the display of names in the list.
Select Module	Use the scrolling list to select a module within the selected operation.
Filter By Module Name	Enter the initial letters of the module name to filter the display of names in the list. You can also select a filter type: All: Displays all modules. Standard: Displays standard modules delivered as part of the ServiceNow application. Custom: Displays custom modules created.
Display Table Names instead of Module Names	Select this check box to switch to display the table names instead of module names in the list.
Select an Operation	Select one of the following operations to perform in the ServiceNow application: Create a new record in the selected module/table. Update an existing record in the selected module/table identified by the mandatory sys_id field. Delete a single record from the selected module/table based on the sys_id field or other supplied values. The following descriptions are applicable for Oracle Integration releases prior to 23.04. Select one of the following operations to perform in the ServiceNow application: Create new records in the selected module/table. Update an existing record in the selected module/table identified by the primary key (sys_id) field. Delete single/multiple records from the selected module/ table based on the primary key (sys_id) field or other supplied values.
Search Module/Table Tab	Search For Module or Table: Enter the initial letters of the module or table name to filter the display of names in the module list along with the corresponding application. Select Module: Select a module from the list of modules you have filtered.

Query Information

If you selected Query Information on the Action page, the following options are displayed:

Element	Description
Select an Operation	Aggregate Operation: Query a table/module using an aggregate function such as SUM, COUNT, MIN, MAX, or AVG. Get Operation: Query the selected table/module by example values and return the matching records and their fields.
Display Table Names instead of Module Names	Select this check box to switch to display the table names instead of module names in the list.
Get keys (Displayed only if the Get operation is selected)	If this check box is checked, the Get operation returns a list of `sys_ids` and the count of matching records.
Extended Query Parameters (Displayed only if the Get operation is selected)	Invokes the Extended Query Parameters page. Use this page to configure event criteria and extended query parameters used to filter the returned results. See Invoke Extended Query Page for a description.
Test Get Operation (Displayed only if the Get operation is selected)	Test Get Operation is enabled when the user selects the Get operation. Enables you to test the operation based on the parameters you selected.
Select Application	Use the scrolling list to select an application within the selected operation. Note: This field is not displayed when you create a ServiceNow Adapter connection with minimal accesses to the tables. See Prerequisites for Creating a Connection.
Search Module/Table Tab	Search For Module or Table: Enter the initial letters of the module or table name to filter the display of names in the module list along with the corresponding application. Select Module: Select a module from the list of modules you have filtered.
Filter By Application Name	Enter the initial letters of the application name to filter the display of names in the list.
Select Module	Use the scrolling list to select a module within the selected operation.
Filter By Module Name	Enter the initial letters of the module name to filter the display of names in the list.

Retrieve, Upload, Download or Delete Attachment(s)

If you selected Retrieve, Upload, Download or Delete Attachment(s) on the Action page, the following options are displayed:

Element	Description
Select an Operation	Select one of the following operations to perform in the ServiceNow application: Retrieve attachment(s) metadata of a record(s) The following operations are supported: Single Attachment Metadata: Fetches metadata of an attachment such as file name, content-type, and so on. Multiple Attachments Metadata: Fetches metadata (file name, content-type, and so on) of all the attachments that a record contains. Download attachment of a specific record from the module/table Upload attachment to a specific record of the module/table Delete attachment from a specific record of the module/table

Element

Description

Select an Operation

Select one of the following operations to perform in the ServiceNow application:

Retrieve attachment(s) metadata of a record(s)
The following operations are supported:
- Single Attachment Metadata: Fetches metadata of an attachment such as file name, content-type, and so on.
- Multiple Attachments Metadata: Fetches metadata (file name, content-type, and so on) of all the attachments that a record contains.
Download attachment of a specific record from the module/table
Upload attachment to a specific record of the module/table
Delete attachment from a specific record of the module/table

If you selected the Upload attachment to a specific record of the module/table operation, the following options are displayed:

Element	Description
Select Application	Scroll through the list to select an application within the selected operation. Note: This field is not displayed when you create a ServiceNow Adapter connection with minimal accesses to the tables. See Prerequisites for Creating a Connection.
Filter By Application Name	Enter the initial letters of the application name to filter the display of names in the list.
Select Module	Use the scrolling list to select a module within the selected operation.
Filter By Module Name	Enter the initial letters of the module name to filter the display of names in the list.
Display Table Names instead of Module Names	Select this check box to show the table names instead of the module names in the list.

Batch Operation

If you selected Batch Operation on the Action page, the following option is displayed. You can add or remove the batch operations to perform.

Element	Description
Click to add an Operation to the list	Select to configure an operation. A new page appears when you click this option.

Operation Page

The Operation page appears when you select the Click to add an Operation to the list option.

Element	Description
Select an Operation Type	Select one of the following operation types to perform in the ServiceNow application: CRUD File Attachment
Select an Operation	Select one of the following operations to perform in the ServiceNow application. The operations available for selection depend upon the operation type you selected. If you select the CRUD operation type, the following operations are displayed for selection. Create Update Get Delete If you select the File Attachment operation type, the following operations are displayed for selection. Download Attachment Upload Attachment Retrieve Attachment Delete Attachment
Select Application	Use the scrolling list to select an application within the selected operation.
Filter By Application Name	Enter the initial letters of the application name to filter the display of names in the list.
Display Table Names instead of Module Names	Select this check box to switch to display the table names instead of module names in the list.
Select Module	Use the scrolling list to select a module within the selected operation.
Filter By Module Name	Enter the initial letters of the module name to filter the display of names in the list. You can also select a filter type: All: Displays all modules. Standard: Displays the standard modules delivered as part of the ServiceNow application. Custom: Displays the custom modules created.