Get all conversation messages

get

/crmRestApi/resources/11.13.18.05/conversationMessages

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

    • AllInquiryMessages Finds conversation messages associated with a channel for inquiry.
      Finder Variables
      • AllUnlinkedSalesMessages Finds conversation messages associated with a sales channel but not associated with any sales objects such as leads or activities.
        Finder Variables
        • MessageByNumber Finds a conversation message with the specified message number.
          Finder Variables
          • MessageNumber; string; The alternate key identifier of the message.
        • MyInboundMessages Finds inbound conversation messages with the specified finder variable.
          Finder Variables
          • BindRecipientPartyId; string; The party identifier of the recipient to search for.
        • MyInboundMessagesToReply Finds new inbound conversation messages where the logged in user is one of the recipients.
          Finder Variables
          • BindRecipientPartyId; string; The party identifier of the recipient to search for.
        • MyMessages Finds conversation messages where the logged in user is one of the recipients.
          Finder Variables
          • BindRecipientPartyId; string; The party identifier of the recipient to search for.
        • MyMessagesToReply Finds new conversation messages where the logged in user is one of the recipients.
          Finder Variables
          • BindRecipientPartyId; string; The party identifier of the recipient to search for.
        • PastMessages Finds past messages in the conversation thread of a given message.
          Finder Variables
          • BindMessageId; string; The unique identifier of the message for which to find past messages.
        • PrimaryKey Finds a conversation message with the specified primary key.
          Finder Variables
          • MessageId; integer; The unique identifier of the conversation message.
      • 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:
        • AssignedToPartyId; integer; The unique identifier of the resource party to whom the conversation message is assigned. This isn't used currently and reserved for future.
        • AssignedToPartyNumber; string; The alternate key identifier of the resource party to whom the conversation message is assigned. This isn't used currently and reserved for future.
        • AssignedToPersonName; string; The name of the resource assigned to the conversation message. This isn't used currently and reserved for future.
        • ChannelId; integer; The unique identifier of the channel associated with the conversation message.
        • ChannelTypeCd; string; The code indicating the type of channel associated with the conversation message.
        • ChannelTypeCdMeaning; string; The name of the channel type associated with the conversation message, such as Email or Social.
        • ConversationBUOrgId; integer; The unique identifier of the business unit organization associated with the conversation.
        • ConversationId; integer; The unique identifier of the conversation to which the message is associated.
        • ConversationNumber; string; The alternate key identifier of the conversation to which the message is associated.
        • ConversationStripeCd; string; The code indicating the application stripe of the conversation, such as CRM, HRHD, or ISR.
        • ConversationTypeCd; string; The code indicating the type of the conversation, such as Customer or Collaboration.
        • CreatedBy; string; The user who created the conversation message.
        • CreationDate; string; The date when the conversation message was created.
        • InboundStatusCd; string; The status code of an inbound or internal collaboration message.
        • InboundStatusCdMeaning; string; The display value of the status of an inbound or internal collaboration message
        • LastUpdateDate; string; The date when the conversation message was last updated.
        • LastUpdateLogin; string; The login details of the user who last updated the conversation message.
        • LastUpdatedBy; string; The user who last updated the conversation message.
        • MessageAlternateId; string; The alternate identifier of the message.
        • MessageCount; string; The total number of messages associated with a conversation.
        • MessageId; integer; The unique identifier of the conversation message.
        • MessageNumber; string; The alternate key identifier of the conversation message.
        • MessageSendDate; string; The date when an outbound message should be sent.
        • MessageStatusCd; string; The status code of a message, such as DRAFT or COMMITTED.
        • MessageTemplate; string; The name of the template associated with the conversation message.
        • MessageTemplateObjTypeCd; string; The object type for which the conversation message was created, such as Service Request, Opportunities, Sales Lead.
        • MessageTitle; string; The title of the conversation message.
        • MessageTypeCd; string; The code indicating the type of the conversation message, such as INBOUND or OUTBOUND.
        • MessageTypeCdMeaning; string; The value of conversation message type, such as Inbound, Outbound, Internal Note, System Response, or System Note.
        • MsgTemplateObjectId; integer; The unique identifier of the object associated with the message template.
        • OriginalSystemReference; string; The original application reference of an imported conversation message.
        • ParentMessageId; integer; The unique identifier of the parent message of the current conversation message. When a user replies to a message the original message becomes the parent message of the reply.
        • ParentMessageNumber; string; The alternate key identifier of the parent message.
        • ProcessingAPPCd; string; The code indicating the application that will be processing the message such as Oracle Marketing Cloud or CX Sales. Typically, this is used for outbound messages.
        • ProcessingAPPContentReferenceId; string; The reference ID of the message's content in the application processing the message. This is used when an application other than CX Sales processes the outbound message such as Oracle Marketing Cloud.
        • ProcessingAPPMsgId; string; The processing application's message identifier. This is used when an application other than CX Sales processes the outbound message such as Oracle Marketing Cloud.
        • ProcessingStatusCd; string; The code indicating the processing status of the conversation message, such as WAITING, READY, ERROR, or SUCCESS.
        • ProcessingStatusDetail; string; The details of the conversation message processing status.
        • QueueId; integer; The unique identifier of the queue that the conversation message is assigned to. This isn't used currently and reserved for future.
        • QueueName; string; The name of the queue that the conversation message is assigned to. This isn't used currently and reserved for future.
        • QueueNumber; string; The alternate key identifier of the queue that the conversation message is assigned to. This isn't used currently and reserved for future.
        • ReportedDate; string; The date when the conversation message was reported. Typically this date would be the same as the created date unless the message was imported.
        • SenderAlternateId; integer; The alternate identifier of the message sender.
        • SenderFreeFormAddress; string; The free form address of the sender of the message. For example, the email address of the sender.
        • SenderPartyId; integer; The unique identifier of the sender party.
        • SenderPartyName; string; The name of the sender party.
        • SenderPartyNumber; string; The alternate key identifier of the sender party.
        • SenderPartyTypeCd; string; The party type code of the message sender such as ORA_SVC_BUSINESS_CONTACT, ORA_SVC_RESOURCE.
        • SentDate; string; The date when the message was sent by the sender. This field isn't populated when a message is automatically created via channels like email, social, and so on.
        • SourceCd; string; The code indicating the source of the conversation message, such as ORA_SVC_AGENT_UI, API, or ORA_SVC_INBOUND_MSG.
      • 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 : conversationMessages
      Type: object
      Show Source
      Nested Schema : Items
      Type: array
      Title: Items
      The items in the collection.
      Show Source
      Nested Schema : conversationMessages-item-response
      Type: object
      Show Source
      • Title: Assigned To
        The unique identifier of the resource party to whom the conversation message is assigned. This isn't used currently and reserved for future.
      • Title: Assigned to Party Number
        Read Only: true
        Maximum Length: 30
        The alternate key identifier of the resource party to whom the conversation message is assigned. This isn't used currently and reserved for future.
      • Title: Assigned to Party Name
        Read Only: true
        Maximum Length: 360
        The name of the resource assigned to the conversation message. This isn't used currently and reserved for future.
      • Attachments
        Title: Attachments
        The attachments resource is used to view, create, and update attachments.
      • Title: Channel ID
        The unique identifier of the channel associated with the conversation message.
      • Title: Channel Type Code
        Maximum Length: 30
        The code indicating the type of channel associated with the conversation message.
      • Title: Channel Type Value
        Read Only: true
        Maximum Length: 255
        The name of the channel type associated with the conversation message, such as Email or Social.
      • Title: Conversation Business Unit
        The unique identifier of the business unit organization associated with the conversation.
      • Title: Conversation ID
        The unique identifier of the conversation to which the message is associated.
      • Title: Conversation Number
        Maximum Length: 30
        The alternate key identifier of the conversation to which the message is associated.
      • Title: Conversation Stripe Code
        Maximum Length: 255
        The code indicating the application stripe of the conversation, such as CRM, HRHD, or ISR.
      • Title: Conversation Type
        Maximum Length: 255
        The code indicating the type of the conversation, such as Customer or Collaboration.
      • Title: Created By
        Read Only: true
        Maximum Length: 64
        The user who created the conversation message.
      • Title: Creation Date
        Read Only: true
        The date when the conversation message was created.
      • Title: Inbound Message Status Code
        Maximum Length: 30
        The status code of an inbound or internal collaboration message.
      • Title: Status
        Read Only: true
        Maximum Length: 255
        The display value of the status of an inbound or internal collaboration message
      • Title: Last Updated Date
        Read Only: true
        The date when the conversation message was last updated.
      • Title: Last Updated By
        Read Only: true
        Maximum Length: 64
        The user who last updated the conversation message.
      • Title: Last Update Login
        Read Only: true
        Maximum Length: 32
        The login details of the user who last updated the conversation message.
      • Links
      • Title: Message Alternate ID
        Maximum Length: 100
        The alternate identifier of the message.
      • Title: Message Content
        The content of the conversation message, such as the contents of an email.
      • Title: Message Count
        Read Only: true
        Maximum Length: 80
        The total number of messages associated with a conversation.
      • Title: Message ID
        Read Only: true
        The unique identifier of the conversation message.
      • Title: Message Number
        Maximum Length: 30
        The alternate key identifier of the conversation message.
      • Title: Message Send Date
        The date when an outbound message should be sent.
      • Title: Message Status Code
        Maximum Length: 30
        The status code of a message, such as DRAFT or COMMITTED.
      • Title: Message Template
        Maximum Length: 320
        The name of the template associated with the conversation message.
      • Title: Message Template Object Type
        Maximum Length: 30
        The object type for which the conversation message was created, such as Service Request, Opportunities, Sales Lead.
      • Title: Subject
        Maximum Length: 1000
        The title of the conversation message.
      • Title: Message Type Code
        Maximum Length: 30
        The code indicating the type of the conversation message, such as INBOUND or OUTBOUND.
      • Title: Message Type
        Read Only: true
        Maximum Length: 255
        The value of conversation message type, such as Inbound, Outbound, Internal Note, System Response, or System Note.
      • Title: Message Template Object ID
        The unique identifier of the object associated with the message template.
      • Title: Original Application Reference
        Maximum Length: 1000
        The original application reference of an imported conversation message.
      • Title: Parent Message ID
        The unique identifier of the parent message of the current conversation message. When a user replies to a message the original message becomes the parent message of the reply.
      • Title: Parent Message Number
        Maximum Length: 30
        The alternate key identifier of the parent message.
      • Title: Processing Application Code
        Maximum Length: 30
        The code indicating the application that will be processing the message such as Oracle Marketing Cloud or CX Sales. Typically, this is used for outbound messages.
      • Title: Processing Application Content Reference ID
        Maximum Length: 30
        The reference ID of the message's content in the application processing the message. This is used when an application other than CX Sales processes the outbound message such as Oracle Marketing Cloud.
      • Title: Processing Application Message ID
        Maximum Length: 30
        The processing application's message identifier. This is used when an application other than CX Sales processes the outbound message such as Oracle Marketing Cloud.
      • Title: Processing Status Code
        Maximum Length: 30
        The code indicating the processing status of the conversation message, such as WAITING, READY, ERROR, or SUCCESS.
      • Title: Processing Status Detail
        Maximum Length: 1000
        The details of the conversation message processing status.
      • Title: Queue ID
        The unique identifier of the queue that the conversation message is assigned to. This isn't used currently and reserved for future.
      • Title: Queue Name
        Read Only: true
        Maximum Length: 400
        The name of the queue that the conversation message is assigned to. This isn't used currently and reserved for future.
      • Title: Queue Number
        Read Only: true
        Maximum Length: 30
        The alternate key identifier of the queue that the conversation message is assigned to. This isn't used currently and reserved for future.
      • Conversation Message Recipients
        Title: Conversation Message Recipients
        Message recipients.
      • Title: Reported Date
        The date when the conversation message was reported. Typically this date would be the same as the created date unless the message was imported.
      • Title: Sender Alternate ID
        The alternate identifier of the message sender.
      • Title: Sender Free Form Address
        Maximum Length: 320
        The free form address of the sender of the message. For example, the email address of the sender.
      • Title: Sender Party ID
        The unique identifier of the sender party.
      • Title: Sender
        Read Only: true
        Maximum Length: 360
        The name of the sender party.
      • Title: Sender Party Number
        Read Only: true
        Maximum Length: 30
        The alternate key identifier of the sender party.
      • Title: Sender Party Type Code
        Maximum Length: 30
        The party type code of the message sender such as ORA_SVC_BUSINESS_CONTACT, ORA_SVC_RESOURCE.
      • Title: Sent Date
        The date when the message was sent by the sender. This field isn't populated when a message is automatically created via channels like email, social, and so on.
      • Smart Actions
        Title: Smart Actions
        This VO stores the endpoint and security details for every user action.
      • Title: Source Code
        Maximum Length: 30
        The code indicating the source of the conversation message, such as ORA_SVC_AGENT_UI, API, or ORA_SVC_INBOUND_MSG.
      Nested Schema : Attachments
      Type: array
      Title: Attachments
      The attachments resource is used to view, create, and update attachments.
      Show Source
      Nested Schema : Conversation Message Recipients
      Type: array
      Title: Conversation Message Recipients
      Message recipients.
      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 : conversationMessages-attachments-item-response
      Type: object
      Show Source
      Nested Schema : conversationMessages-recipients-item-response
      Type: object
      Show Source
      • Title: Created By
        Read Only: true
        Maximum Length: 64
        The user who created the conversation message recipient.
      • Title: Creation Date
        Read Only: true
        The date when the conversation message recipient was created.
      • Title: Free Form Address
        Maximum Length: 320
        The free form address of the conversation message recipient. E.g. the email address of the sender.
      • Title: Last Updated Date
        Read Only: true
        The date when the conversation message recipient was last updated.
      • Title: Last Updated By
        Read Only: true
        Maximum Length: 64
        The user who last updated the conversation message recipient.
      • Title: Last Update Login
        Read Only: true
        Maximum Length: 32
        The login details of the user who last updated the conversation message recipient.
      • Links
      • Title: Message ID
        The unique identifier of the conversation message.
      • Title: Message Number
        Maximum Length: 30
        The alternate key identifier of the conversation message.
      • Title: Person ID
        The unique identifier of the recipient. This is populated if the recipient is an internal person such as an employee and contingent worker.
      • Title: Recipient Alternate ID
        The alternate identifier of the recipient such as the identifier of the recipient in an external system.
      • Title: Message Alternate ID
        Maximum Length: 1000
        The alternate identifier of the message in an external system.
      • Title: Recipient ID
        Read Only: true
        The unique identifier of the conversation message recipient.
      • Title: Recipient Number
        Maximum Length: 30
        The public unique identifier of the conversation message recipient.
      • Title: Recipient Party ID
        The unique identifier of the party of the conversation message recipient.
      • Title: Recipient Name
        Read Only: true
        Maximum Length: 360
        The name of the party of the conversation message recipient.
      • Title: Recipient Party Number
        Read Only: true
        Maximum Length: 30
        The alternate key identifier of the party of the conversation message recipient.
      • Title: Recipient Party Type Code
        Maximum Length: 30
        The party type code of the message recipient such as ORA_SVC_BUSINESS_CONTACT, ORA_SVC_RESOURCE.
      • Title: Recipient Type Code
        Maximum Length: 30
        The code indicating the type of the recipient in the conversation message, such as TO, CC, or BCC.
      Nested Schema : conversationMessages-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 : conversationMessages-smartActions-UserActionNavigation-item-response
      Type: object
      Show Source
      Nested Schema : conversationMessages-smartActions-UserActionRequestPayload-item-response
      Type: object
      Show Source
      Nested Schema : conversationMessages-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 conversation messages by submitting a GET request on the REST resource using cURL.

      cURL Command

      curl --location --request GET 'https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/conversationMessages' \

      Example of Response Body

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

      {
          "items": [
              {
                  "MessageId": 300100547269629,
                  "MessageNumber": "CDRM_0000000001",
                  "CreatedBy": "autoapisladmin",
                  "CreationDate": "2021-09-22T01:22:01+00:00",
                  "LastUpdatedBy": "FUSION_APPS_CRM_ESS_APPID",
                  "LastUpdateDate": "2021-09-22T01:22:17+00:00",
                  "LastUpdateLogin": "CC7437C06434B335E0532048F70A1E8A",
                  "MessageTypeCd": "ORA_SVC_OUTBOUND",
                  "MessageTitle": null,
                  "SourceCd": null,
                  "ChannelTypeCd": "ORA_SVC_MSTEAMS",
                  "ChannelTypeCdMeaning": "Microsoft Teams",
                  "InboundStatusCd": null,
                  "InboundStatusCdMeaning": null,
                  "MessageStatusCd": "ORA_SVC_COMMITTED",
                  "ProcessingStatusCd": "ORA_SVC_ERROR",
                  "ProcessingStatusDetail": "Message in collaboration channel could not be created",
                  "SentDate": "2021-09-22T01:22:01+00:00",
                  "MessageSendDate": null,
                  "OriginalSystemReference": null,
                  "ConversationId": 300100547269630,
                  "ConversationNumber": "CDRM_0000000001",
                  "ConversationTypeCd": "ORA_SVC_COLLABORATION",
                  "ConversationStripeCd": "ORA_SVC_CRM",
                  "ConversationBUOrgId": 204,
                  "ParentMessageId": null,
                  "ParentMessageNumber": null,
                  "ChannelId": 300100547072940,
                  "QueueId": null,
                  "QueueNumber": null,
                  "QueueName": null,
                  "AssignedToPartyId": null,
                  "AssignedToPartyNumber": null,
                  "AssignedToPersonName": null,
                  "ProcessingAPPCd": "ENGAGEMENT_CENTER",
                  "ProcessingAPPMsgId": null,
                  "ProcessingAPPContentReferenceId": null,
                  "MessageTemplateObjTypeCd": "ORA_SVC_SERVICE_REQUESTS",
                  "MessageTemplate": null,
                  "SenderPartyId": 300100078385877,
                  "SenderPartyNumber": "CDRM_326167",
                  "SenderPartyName": "autoapisladmin svc",
                  "SenderPartyTypeCd": "ORA_SVC_RESOURCE",
                  "ReportedDate": "2021-09-22T01:22:01+00:00",
                  "SenderFreeFormAddress": null,
                  "MessageCount": "1",
                  "MsgTemplateObjectId": 300100547269602,
                  "SenderAlternateId": null,
                  "MessageAlternateId": null,
                  "MessageTypeCdMeaning": "Outbound",
                  "links": [
                      {
      ...
      }
      Back to Top