1. Using the OData Adapter with Oracle Integration 3
  2. Add the OData Adapter Connection to an Integration
  3. Invoke Operations Page

Invoke Operations Page

Select the operation type to perform.

  • Single Operation: Enables you to execute one operation at a time.
  • Batch Operation: Enables you to execute more than one operation as a batch.

Single Operation

If you select Single Operation, the following options are displayed.

Element Description

Select Operation

Displays the list of operations to select.

  • Create: Creates a new record for the selected entity.
  • Update: Updates the existing record for the selected entity.
  • Delete: Deletes a record for the selected entity.
  • Get: Retrieves a specific record for the selected entity.
  • Query: Retrieves all records for the selected entity.
  • Replace: Replaces the existing record for the selected entity.

Select Entity

Displays a list of entities to select.
Request and Response Media Type

(Displays if you select OData Version 4 on the Connections page.)
  • JSON: Select to represent the records using the JavaScript Object Notation (JSON) format.
  • ATOM-XML: Select to represent the records for OData requests and responses using the Atom-XML format.

Add custom request headers

Select this check box to add custom request headers on the Request Headers page.

Add custom response headers

Select this check box to add custom response headers on the Response Headers page.

Perform operation on contained Entity

Select this check box to perform operations on a contained entity on the Navigation page.

Note:

The Deep Insert operation and Operations on Contained Entity operation can be performed only under the Single Operation option.

Batch Operation

If you select Batch Operation, the following options are displayed.

The list of batch operations is displayed. You can add or remove the batch operations to perform.

Note:

  • A maximum of five operations can be executed per batch operation.
  • A minimum of two operations must be selected to perform a batch.
  • Within a single modification operation, a maximum of five operations (such as create, update, replace, or delete) can be selected.
Element Description

Click to add an Operation to the List

Select to configure an operation. A new page appears when you click this option.
Add custom request headers

Select this check box to add custom request headers on the Request Headers page.

Add custom response headers

Select this check box to add custom response headers on the Response Headers page.

Note:

Based on the selections made on this page, separate tabbed pages are shown in the Request Header page and/or Response Header page for configuring the headers.

Click to Add an Operation to the List

This 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:
  • Retrieve Operation
  • Modification Operation
Select Operation

Select one of the following operations to perform in the target application.

The operations available for selection depend upon the operation type you selected.

If you select Retrieve Operation, the following operations are displayed for selection.
  • Get: Retrieves a specific record for the selected entity.
  • Query: Retrieves all records for the selected entity.
If you select Modification Operation, the following operations are displayed for selection:
  • Create: Creates a new record for the selected entity.
  • Update: Updates the existing record for the selected entity.
  • Delete: Deletes a record for the selected entity.
  • Replace: Replaces the existing record for the selected entity.
Select Entity

Displays a list of entities to select.

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:

  • Retrieve Operation
  • Modification Operation

Select 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 Retrieve Operation, the following operations are displayed for selection.
  • Get: Retrieves specific record for the selected entity.
  • Query: Retrieves all records for the selected entity.
If you select Modification Operation, the following operations are displayed for selection:
  • Create: Creates a new record for the selected entity.
  • Update: Updates the existing record for the selected entity.
  • Delete: Deletes a record for the selected entity.
  • Replace: Replaces the existing record for the selected entity.

Select Entity

Displays a list of entities to select.

Navigation Property Page

The Navigation Property page appears when you select Create under Single Operation on the Operation page.

Deep Insert Operation

Element Description

Select child navigation property

Select or deselect the child navigation properties for an entity selected on the Operation page. Select the required navigation properties on which you want to perform the deep insert operation.

Operation on Contained Entity

The Navigation Property page appears when you select the Perform operation on contained Entity check box under Single Operation on the Operation page.

Note:

To use an operation on a contained entity, ensure that you select V4 in the OData Version field on the Connections page.
Element Description

Perform operation on contained entity by selecting any one navigation property

Select or deselect the child navigation property for an entity selected on the operation page. Select the required any one navigation property on which you want to perform the operation.