Get all interactions

get

/crmRestApi/resources/11.13.18.05/interactions

Request

Query Parameters
  • When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
  • This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.

    Format: ?fields=Attribute1,Attribute2

    Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2
  • Used as a predefined finder to search the collection.

    Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>

    The following are the available finder names and corresponding finder variables:

    • InteractionRowFinderById: Finds an interactions with the interaction identifier.
      Finder Variables:
      • BindInteractionId; integer; The unique interaction identifier.
      • BindStripeCd; string; The interactions stripe code.
    • InteractionRowFinderByMediaItemId: Finds an interaction by the media item identifier
      Finder Variables:
      • BindMediaItemId; string; The media item identifier of the interaction.
    • InteractionRowFinderByObject: Finds interactions associated with an object.
      Finder Variables:
      • ObjectId; integer; The unique identifier of the object.
      • ObjectTypeCd; string; The code indicating the type of the object.
    • InteractionRowFinderByOwnerCustomerTime: Finds interactions by Owner Identifier, Customer Identifier and Time.
      Finder Variables:
      • BindAccountPartyId; integer.
      • BindContactPartyId; integer.
      • BindCreationDate; string.
      • BindInteractionId; integer.
      • BindLastUpdateDate; string.
      • BindOwnerResourceId; integer.
      • BindStatusCd; string.
    • InteractionRowFinderByOwnerCustomerTimeObject: Finds child interactions with the specified primary key, such as Owner Identifier, Customer Identifier, Time and Object
      Finder Variables:
      • BindAccountPartyId; integer.
      • BindContactPartyId; integer.
      • BindCreationDate; string.
      • BindInteractionId; integer.
      • BindLastUpdateDate; string.
      • BindOwnerResourceId; integer.
      • BindStatusCd; string.
      • ObjectId; integer.
      • ObjectTypeCd; string.
    • OpenChildInteractionRowFinderByChannelCustomerOwner: Finds interactions by Channel and Customers.
      Finder Variables:
      • BindAccountPartyId; integer; The unique identifier of the account associated with the interaction.
      • BindChannelId; integer; The unique identifier of the interaction channel.
      • BindContactPartyId; integer; The unique identifier of the contact associated with the interaction.
      • BindOwnerResourceId; integer; The unique identifier of the owner of the interaction.
      • BindParentInteractionId; integer; The unique identifier of the parent interaction.
    • PrimaryKey: Finds an interaction with the specified primary key.
      Finder Variables:
      • InteractionId; integer; The unique identifier of the interaction.
  • This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
  • This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>

    Example:
    self,canonical
  • Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
  • The resource item payload will be filtered in order to contain only data (no links section, for example).
  • This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
  • This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY

    Format: ?q=expression1;expression2

    You can use these queryable attributes to filter this collection resource using the q query parameter:
    • AccountPartyId; integer; The unique identifier of the account associated with the interaction.
    • AccountPartyNumber; string; The alternate key for the account identifier.
    • AccountPartyUniqueName; string; The unique account name of the account associated with the interaction.
    • AgentHTTPSessionId; string; The unique identifier for the http session.
    • ChannelDisplayName; string; The name of the interaction channel.
    • ChannelId; integer; The unique identifier of the interaction channel.
    • ChannelShortName; string; The interaction channel short name.
    • ChannelTypeCd; string; The code indicating the type of the interaction channel.
    • ContactPartyId; integer; The unique identifier of the contact associated with the interaction.
    • ContactPartyNumber; string; The alternate key identifier for the contact party.
    • ContactPartyUniqueName; string; The unique contact name of the contact associated with the interaction.
    • CreatedBy; string; The user who created the interaction.
    • CreationDate; string; The date and time when the interaction was created.
    • Description; string; The description of the child interaction.
    • DirectionCd; string; The code indicating whether the interaction is inbound or outbound. The default value is ORA_SVC_INBOUND, indicating inbound interactions. The value is ORA_SVC_OUTBOUND for outbound interactions.
    • EndTime; string; The time when the interaction ended.
    • InteractionId; integer; The unique identifier of the interaction.
    • InteractionNumber; string; The alternate key identifier for the interaction.
    • LastUpdateDate; string; The date when the interaction was last updated.
    • LastUpdateLogin; string; The session login of the user who last updated the interaction.
    • LastUpdatedBy; string; The user who last updated the interaction.
    • ManuallyLoggedFlag; boolean; Indicates whether the interaction was manually created. If manually created, the value is Y, else the value is N.
    • MarketingReferenceId; integer; A unique identifier used to store a reference to a marketing system deployment number.
    • MediaItemId; string; The unique identifier for the media item.
    • OriginalSystemReference; string; The system reference used by the interaction.
    • OwnerResourceId; integer; The unique identifier of the owner of the interaction.
    • OwnerResourcePartyNumber; string; The alternate key identifier of the owner of the interaction.
    • OwnerResourcePartyUniqueName; string; The unique name of the owner of the interaction.
    • ParentInteractionId; integer; The unique identifier of the parent interaction.
    • ParentInteractionNumber; string; The alternate key identifier of the parent interaction.
    • QueueId; integer; The unique identifier of the interaction queue.
    • QueueName; string; The name of the interaction queue.
    • QueueNumber; string; The alternate key identifier for the queue.
    • SourceCd; string; A unique identifier used to store a source code reference within the child interaction object.
    • StartTime; string; The time when the interaction started.
    • StatusCd; string; The code indicating the current status of the interaction. A list of valid values is defined in the lookup ORA_SVC_IM_STATUS_CD.
    • StripeCd; string; The code indicating the stripe of the interaction. A list of valid values is defined in the lookup ORA_SVC_STRIPE_CD.
    • SubstatusCd; string; The code indicating the sub-status of the interaction. A list of valid values is defined in the lookup ORA_SVC_IM_CLOSED_SUBSTATUS_CD.
    • TopLevelFlag; boolean; Indicates whether an interaction is top level or not. An interaction is top level if the parent interaction identifier is the same as the interaction identifier.
  • The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.

There's no request body for this operation.

Back to Top

Response

Supported Media Types

Default Response

The following table describes the default response for this task.
Headers
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Body ()
Root Schema : interactions
Type: object
Show Source
Nested Schema : Items
Type: array
Title: Items
The items in the collection.
Show Source
Nested Schema : interactions-item-response
Type: object
Show Source
  • Title: Account ID
    The unique identifier of the account associated with the interaction.
  • Title: Account Number
    Read Only: true
    Maximum Length: 30
    The alternate key for the account identifier.
  • Title: Account
    Read Only: true
    Maximum Length: 900
    The unique account name of the account associated with the interaction.
  • Title: Session ID
    Maximum Length: 100
    The unique identifier for the http session.
  • Title: Channel Display Name
    Read Only: true
    Maximum Length: 400
    The name of the interaction channel.
  • Title: Channel ID
    The unique identifier of the interaction channel.
  • Title: Channel Code
    Read Only: true
    Maximum Length: 450
    The interaction channel short name.
  • Title: Channel Type
    Maximum Length: 30
    The code indicating the type of the interaction channel.
  • Child Interactions
    Title: Child Interactions
    The child interaction resource is used to view, create, and update all the child interactions associated with the current interaction.
  • Title: Contact ID
    The unique identifier of the contact associated with the interaction.
  • Title: Contact Number
    Read Only: true
    Maximum Length: 30
    The alternate key identifier for the contact party.
  • Title: Contact
    Read Only: true
    Maximum Length: 900
    The unique contact name of the contact associated with the interaction.
  • Title: Created By
    Read Only: true
    Maximum Length: 64
    The user who created the interaction.
  • Title: Creation Date
    Read Only: true
    The date and time when the interaction was created.
  • Read Only: true
    Indicates if the interaction can be deleted by the current user. The default value is false.
  • Title: Description
    Maximum Length: 1000
    The description of the child interaction.
  • Title: Direction
    Maximum Length: 30
    Default Value: ORA_SVC_INBOUND
    The code indicating whether the interaction is inbound or outbound. The default value is ORA_SVC_INBOUND, indicating inbound interactions. The value is ORA_SVC_OUTBOUND for outbound interactions.
  • Title: End Interaction
    This will set the Endtime attribute ( to the current time) without changing the interaction status to closed. The default value is false.
  • Title: End Time
    The time when the interaction ended.
  • Title: Interaction ID
    Read Only: true
    The unique identifier of the interaction.
  • Title: Interaction Number
    Maximum Length: 30
    The alternate key identifier for the interaction.
  • Interaction Participants
    Title: Interaction Participants
    The interaction participant resource is used to view, create, and update participants in an interaction, usually a web conference.
  • Interaction References
    Title: Interaction References
    The interaction references resource is used to view, create, and update the association between an interaction and another business object, for example Service Requests. The supported business objects and their codes are Activities (ZMM_ACTIVITIES), Opportunities (MOO_OPTY), Work Orders (SVC_WORK_ORDERS), Service Requests (SVC_SERVICE_REQUESTS), and Leads (MKL_LM_LEADS).
  • Title: Last Updated Date
    Read Only: true
    The date when the interaction was last updated.
  • Title: Last Updated By
    Read Only: true
    Maximum Length: 64
    The user who last updated the interaction.
  • Title: Last Update Login
    Read Only: true
    Maximum Length: 32
    The session login of the user who last updated the interaction.
  • Links
  • Maximum Length: 1
    Indicates whether the interaction was manually created. If manually created, the value is Y, else the value is N.
  • Title: Marketing Reference ID
    A unique identifier used to store a reference to a marketing system deployment number.
  • Title: Media Item ID
    Maximum Length: 255
    The unique identifier for the media item.
  • Title: Original System
    Maximum Length: 255
    The system reference used by the interaction.
  • Title: Owner Resource ID
    The unique identifier of the owner of the interaction.
  • Title: Resource Number
    Read Only: true
    Maximum Length: 30
    The alternate key identifier of the owner of the interaction.
  • Title: Resource Name
    Read Only: true
    Maximum Length: 900
    The unique name of the owner of the interaction.
  • Title: Parent Interaction ID
    The unique identifier of the parent interaction.
  • Title: Interaction Number
    Read Only: true
    Maximum Length: 30
    The alternate key identifier of the parent interaction.
  • Title: Payload
    The payload associated with the interaction.
  • Title: Queue ID
    The unique identifier of the interaction queue.
  • Title: Queue Name
    Read Only: true
    Maximum Length: 400
    The name of the interaction queue.
  • Title: Queue Number
    Maximum Length: 30
    The alternate key identifier for the queue.
  • Smart Actions
    Title: Smart Actions
    This VO stores the endpoint and security details for every user action.
  • Title: Source CD
    Maximum Length: 30
    A unique identifier used to store a source code reference within the child interaction object.
  • Title: Start Interaction
    Default Value: true
    Indicates if the interaction should be started if it hasn???t already been started. The default value is True.
  • Title: Start Time
    The time when the interaction started.
  • Title: Status
    Maximum Length: 30
    Default Value: ORA_SVC_OPEN
    The code indicating the current status of the interaction. A list of valid values is defined in the lookup ORA_SVC_IM_STATUS_CD.
  • Title: Stripe Code
    Maximum Length: 30
    The code indicating the stripe of the interaction. A list of valid values is defined in the lookup ORA_SVC_STRIPE_CD.
  • Title: Substatus Code
    Maximum Length: 30
    The code indicating the sub-status of the interaction. A list of valid values is defined in the lookup ORA_SVC_IM_CLOSED_SUBSTATUS_CD.
  • Title: Top Level
    Read Only: true
    Indicates whether an interaction is top level or not. An interaction is top level if the parent interaction identifier is the same as the interaction identifier.
  • Read Only: true
    Indicates if the interaction can be updated by the current user. The default value is true if the user has access to update the interaction.
Nested Schema : Child Interactions
Type: array
Title: Child Interactions
The child interaction resource is used to view, create, and update all the child interactions associated with the current interaction.
Show Source
Nested Schema : Interaction Participants
Type: array
Title: Interaction Participants
The interaction participant resource is used to view, create, and update participants in an interaction, usually a web conference.
Show Source
Nested Schema : Interaction References
Type: array
Title: Interaction References
The interaction references resource is used to view, create, and update the association between an interaction and another business object, for example Service Requests. The supported business objects and their codes are Activities (ZMM_ACTIVITIES), Opportunities (MOO_OPTY), Work Orders (SVC_WORK_ORDERS), Service Requests (SVC_SERVICE_REQUESTS), and Leads (MKL_LM_LEADS).
Show Source
Nested Schema : Smart Actions
Type: array
Title: Smart Actions
This VO stores the endpoint and security details for every user action.
Show Source
Nested Schema : interactions-childInteractions-item-response
Type: object
Show Source
Nested Schema : interactions-InteractionParticipants-item-response
Type: object
Show Source
Nested Schema : interactions-interactionReferences-item-response
Type: object
Show Source
  • Title: Created By
    Read Only: true
    Maximum Length: 64
    The user who created the reference.
  • Title: Creation Date
    Read Only: true
    The date and time when the reference was created.
  • Read Only: true
    Indicates if the interaction reference can be deleted by the current user. The default value is false.
  • Title: Interaction ID
    The unique identifier of the interaction reference.
  • Title: Interaction Number
    Maximum Length: 30
    The alternate key identifier for the interaction.
  • Title: Last Updated Date
    Read Only: true
    The date and time when the reference was last updated.
  • Title: Last Updated By
    Read Only: true
    Maximum Length: 64
    The user who last updated the reference.
  • Title: Last Update Login
    Read Only: true
    Maximum Length: 32
    The session login of the user who last updated the reference.
  • Links
  • Title: Object ID
    The unique identifier of the object associated with the interaction reference.
  • Title: Reference Number
    Read Only: true
    Maximum Length: 255
    The alternate key identifier of the object associated with the interaction reference.
  • Title: Object Type
    Maximum Length: 30
    The code indicating the type of the object present in the interaction reference. A list of valid values is defined in the lookup ORA_SVC_IM_REF_OBJECT_TYPE_CD.
  • Title: Reference ID
    Read Only: true
    The unique identifier used for integration with external systems.
  • Read Only: true
    Indicates if the interaction reference can be updated by the current user. The default value is true if the user has access to update the interaction reference.
Nested Schema : interactions-smartActions-item-response
Type: object
Show Source
Nested Schema : Smart Action User Interface Definitions
Type: array
Title: Smart Action User Interface Definitions
UI navigation metadata striped by app usage.
Show Source
Nested Schema : Smart Action REST Payload Definitions
Type: array
Title: Smart Action REST Payload Definitions
If an LOV required for constructing a request payload needs to post data, the payload metadata is stored here.
Show Source
Nested Schema : Smart Action User Interface Definitions
Type: array
Title: Smart Action User Interface Definitions
Binding metadata for a variable in the URL.
Show Source
Nested Schema : interactions-smartActions-UserActionNavigation-item-response
Type: object
Show Source
Nested Schema : interactions-smartActions-UserActionRequestPayload-item-response
Type: object
Show Source
Nested Schema : interactions-smartActions-UserActionURLBinding-item-response
Type: object
Show Source
  • Title: URL Binding Type
    Maximum Length: 64
    This is a hint for processing the Url Binding runtime.
  • Links
  • Title: System Action
    Maximum Length: 1
    Default Value: false
    Boolean indicator.
  • Uniquely identifies the URL Bind for smart actions. For internal use.
  • Title: URL Binding Parameter Name
    Maximum Length: 50
    For action REST endpoints that require runtime binding, this is the key in the key value pair.
  • Title: URL Binding Parameter Value
    Maximum Length: 80
    For action REST endpoints that require runtime binding, this is the value in the key value pair.
Back to Top

Examples

The following example shows how to get all interactions by submitting a GET request on the REST resource.

Request Header Example

The following shows an example of the request header.

GET /crmRestApi/resources/11.13.18.05/interactions

Response Header Example

The following shows an example of the response header.

HTTP/1.1 200: OK
Date: Fri, 03 Mar 2017 07:54:53 GMT
Server : Oracle-HTTP-Server-11g
Content-Type: application/vnd.oracle.adf.resourcecollection+json
Content-Language: en

Response Body Example

The following shows an example of the response body in JSON format.

{
  "items": [
    {
      "InteractionId": 300100096307925,
      "ParentInteractionId": 300100096307925,
      "TopLevelFlag": "true",
      "Description": "Sent SrMessage 300100096307628",
      "ChannelId": 300100092273686,
      "ChannelDisplayName": "ditdevacisvcfib_qa.extservice.incoming",
      "ChannelTypeCd": "ORA_SVC_EMAIL",
      "AccountPartyId": null,
      "AccountPartyUniqueName": null,
      "ContactPartyId": null,
      "ContactPartyUniqueName": null,
      "QueueId": null,
      "QueueName": null,
      "OwnerResourceId": null,
      "OwnerResourcePartyUniqueName": null,
      "StartTime": "2017-02-20T04:09:17-08:00",
      "EndTime": "2017-02-20T04:09:17-08:00",
      "StatusCd": "ORA_SVC_CLOSED",
      "OriginalSystemReference": null,
      "CreatedBy": "FUSION_APPS_CRM_ESS_APPID",
      "CreationDate": "2017-02-20T04:09:17-08:00",
      "LastUpdatedBy": "FUSION_APPS_CRM_ESS_APPID",
      "LastUpdateDate": "2017-02-20T04:09:17-08:00",
      "LastUpdateLogin": "48F584F941357435E05307B3F20AB8E8",
      "DirectionCd": "ORA_SVC_OUTBOUND",
      "StripeCd": "ORA_SVC_CRM",
      "MediaItemId": null,
      "SubstatusCd": null,
      "NotifyFlag": null,
      "UpdateFlag": "true",
      "DeleteFlag": "true",
      "links": [
        {
          "rel": "self",
          "href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/interactions/300100096307925",
          "name": "interactions",
          "kind": "item",
          "properties": {
            "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
          }
        },
        {
          "rel": "canonical",
          "href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/interactions/300100096307925",
          "name": "interactions",
          "kind": "item"
        },
        {
          "rel": "lov",
          "href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/interactions/300100096307925/lov/DirectionCdLookup",
          "name": "DirectionCdLookup",
          "kind": "collection"
        },
        {
          "rel": "lov",
          "href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/interactions/300100096307925/lov/StatusCdLookup",
          "name": "StatusCdLookup",
          "kind": "collection"
        },
        {
          "rel": "lov",
          "href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/interactions/300100096307925/lov/ChannelIdByChannelType",
          "name": "ChannelIdByChannelType",
          "kind": "collection"
        },
        {
          "rel": "child",
          "href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/interactions/300100096307925/child/childInteractions",
          "name": "childInteractions",
          "kind": "collection"
        },
        {
          "rel": "child",
          "href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/interactions/300100096307925/child/interactionReferences",
          "name": "interactionReferences",
          "kind": "collection"
        },
        {
          "rel": "enclosure",
          "href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/interactions/300100096307925/enclosure/Payload",
          "name": "Payload",
          "kind": "other"
        }
      ]
    }
...
}
Back to Top