1. REST API for Sales and Fusion Service in Oracle Fusion Cloud Customer Experience
  2. Tasks
  3. Service Requests
  4. Service Requests v1
  5. Messages

Get all messages using advanced query

post

/api/boss/data/objects/ora/cxServiceCore/srMgmt/v1/serviceRequests/{serviceRequests_id}/messages/$query

Request

Path Parameters
  • This path parameter maps to the following field defined in the Service Requests REST resource:
    1. number: The unique number that's used to identify a service request. You can edit the service request number to a format that's best suitable to your organizational requirements.
Supported Media Types
Request Body - application/json ()
Root Schema : schema
Match All
Show Source
Nested Schema : schema
Type: object
Show Source
  • accessors
    Maps accessor names to query objects specific to corresponding accessors. Query object for each accessor supports query capabilities similar to the base.
  • fields
    Restricts the resource fields. Only the specified fields and mandatory system fields are returned.
  • subTypes
    Maps discriminator values (as defined in subtypes) to query objects specific to corresponding subtypes. Subtype-specific query objects support a subset(fields,accessors,filter) of the query capabilities when compared to the base.
Nested Schema : type
Type: object
Show Source
Nested Schema : accessors
Type: object
Maps accessor names to query objects specific to corresponding accessors. Query object for each accessor supports query capabilities similar to the base.
Nested Schema : fields
Type: array
Restricts the resource fields. Only the specified fields and mandatory system fields are returned.
Show Source
Nested Schema : subTypes
Type: object
Maps discriminator values (as defined in subtypes) to query objects specific to corresponding subtypes. Subtype-specific query objects support a subset(fields,accessors,filter) of the query capabilities when compared to the base.
Nested Schema : collection
Type: object
Defines query criteria that can be applied on a resource collection.
Show Source
  • The resource collection will be queried using the specified filter condition.
  • Restricts the number of resource items returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resource items.
  • Defines the starting position of the resource collection. If offset exceeds the resource count then no resource items are returned.
  • Represents the privilege or action required to check for while serving a request to access a resource.
  • sortBy
    Orders a resource collection based on the specified fields.
Nested Schema : sortBy
Type: array
Orders a resource collection based on the specified fields.
Show Source
Nested Schema : items
Match One Schema
Show Source
  • Name of field based on which sorting will happen. Order is ascending.
  • type
    Object with single entry. Key must be name of field based on which sorting will happen. Value must be either asc or desc to decide the sort order.
Nested Schema : type
Type: object
Object with single entry. Key must be name of field based on which sorting will happen. Value must be either asc or desc to decide the sort order.
Back to Top

Response

Default Response

An array of items response
Body ()
Root Schema : serviceRequests-messages
Type: object
Show Source
Nested Schema : Items
Type: array
Title: Items
The items in the collection.
Show Source
Nested Schema : serviceRequests-messages-item-response
Type: object
Show Source
  • Title: AI Log Level Code
    Maximum Length: 30
    Default Value: ORA_SVC_NONE
    Indicates the AI log level that the SR Message was captured at, such as NONE, INFO, and FINE.
  • Attachments
    Title: Attachments
    The attachments resource is used to view, create, update, and delete attachments associated with a message. An attachment includes additional information about a message.
  • Channel Communications
    Title: Channel Communications
    The channel communications resource is used to view, create, update, and delete channel communications. Channel communication is information about the communication between support agents and their customers. For example, the type of communication information that is recorded includes message identifiers, contact identifiers, and contact point identifiers.
  • Title: Channel
    The unique identifier of the channel.
  • Title: Channel Type
    Maximum Length: 30
    The code indicating the channel type. For example, email, phone, social, and so on. A list of accepted values is defined in the lookup ORA_SVC_CHANNEL_TYPE_CD.
  • Title: Collaboration Resource
    This field is reserved for internal use only.
  • Title: Created By
    Read Only: true
    Maximum Length: 64
    The user who created the message.
  • Title: Created by Email ID
    Read Only: true
    Maximum Length: 320
    The e-mail address of the person who created the service request message.
  • Title: Created by Party ID
    Read Only: true
    Maximum Length: 80
    The unique identifier of the party of the user who created the service request message.
  • Title: Creation Date
    Read Only: true
    The date and time when the message was created.
  • Title: Can Delete
    Read Only: true
    Indicates if the message has been deleted.
  • Title: Feed Flag
    Maximum Length: 1
    Default Value: true
    Indicates whether the SR Message should be pushed to the SR Feed. Values are Y and N.
  • Title: Last Updated Date
    Read Only: true
    The date and time when the message was last updated.
  • Title: Last Updated By
    Read Only: true
    Maximum Length: 64
    The user who last updated the message.
  • Title: Last Update Login
    Read Only: true
    Maximum Length: 32
    The session login associated with the user who last updated the message.
  • Links
  • Title: Message Content
    The content of the message encoded in base 64 format. Any attachment associated with the message is not the content of the message.
  • Title: Created By
    Maximum Length: 64
    The user who created the message in the original source system. This is applicable if the service request message was imported from another system.
  • Title: Message Expand State
    Indicates the message expanding state.
  • Title: Message ID
    The unique identifier of the service request message.
  • Title: Last Updated Date
    The last updated date of the message in the original source system. This is applicable if the service request message was imported from another system.
  • Title: Last Updated By
    Maximum Length: 64
    The user who last update the message in the original source system. This is applicable if the service request message was imported from another system.
  • Title: Last Update Login
    Maximum Length: 32
    The login of the user who last update the message in the original source system. This is applicable if the service request message was imported from another system.
  • Title: Message Number
    Maximum Length: 30
    The public unique identifier of the service request message.
  • Title: Message Subtype
    Maximum Length: 30
    The service request message subtype.
  • Title: Message Type Code
    Maximum Length: 30
    The code indicating the message type. The accepted values are Response, Customer Entry, System Note, System Response, and Internal Note. A list of accepted values is defined in the lookup ORA_SVC_MESSAGE_TYPE_CD.
  • Title: Network
    Read Only: true
    Maximum Length: 30
    The code indicating the social network of the post. For example, Facebook, Twitter. A list of accepted values is defined in the lookup HZ_INSTANT_MESSENGER_TYPE.
  • Title: Notification Processing Status Code
    Maximum Length: 30
    The code indicating the status of the response notification. For example, Error, Success. A list of accepted values is defined in the lookup ORA_SVC_MESSAGE_PROCESS_CD.
  • Title: Notification Retry Count
    The number of times the system tried to send the SR message notification.
  • Title: Object ID
    The unique identifier of the object. Depending on the object type, indicates the service request id or the service request message id associated with the channel communication.
  • Title: Object Type Code
    Maximum Length: 30
    Default Value: SVC_SR_MESSAGES
    This field is reserved for internal use only.
  • Title: Original System
    Maximum Length: 255
    The identifier of the message record in the original source system from where the message was imported. This is applicable if the service request message was imported from another system.
  • Title: Origination Date
    The date the message was created in the original source system. This is applicable if the service request message was imported from another system.
  • Title: Parent Message ID
    The unique identifier of the parent service request message.
  • Title: Posted By
    Read Only: true
    Maximum Length: 360
    The Party name of the user who the posted the message. The user can be an internal resource or a customer contact.
  • Title: Posted by ID
    The unique identifier of the user who the posted the message. The user can be an internal resource or a customer contact.
  • Title: Posted by Party Number
    Read Only: true
    Maximum Length: 30
    The public unique identifier of the person posting the message on the service request.
  • Title: Contains PII Data
    Maximum Length: 1
    Indicates whether the message contains personally identifiable information.
  • Title: Processing ID
    Read Only: true
    The unique identifier of the processing.
  • Title: Processing Status
    Maximum Length: 30
    Default Value: ORA_SVC_READY
    The code indicating the processing status of the message. The accepted values are Ready, Processing, Error, and Success.A list of accepted values is defined in the lookup ORA_SVC_MESSAGE_PROCESS_CD .
  • Title: Reply to Message ID
    Read Only: true
    The unique identifier of the message that is being replied to by the agent.
  • Title: Rich Text
    Maximum Length: 1
    Default Value: true
    Indicates whether the message content is in rich text format. If the format is rich text, then the value is Y, else the value is N.
  • Title: Root Message Identifier
    Read Only: true
    The identifier of the root message in the message hierarchy.
  • Title: Root Message Thread Count
    Read Only: true
    The number of messages under a root message in a service request.
  • Title: Root Message Thread Last Updated Date
    Read Only: true
    The latest updated date for all messages under the root message in a service request.
  • Title: Root Thread Message Last Updated Date
    Read Only: true
    The date when all messages under the root message in a service request were last updated.
  • Title: Sent Date
    The date and time when the message was sent.
  • Title: Private Message
    Maximum Length: 1
    Indicates whether the message was created from a private social post.
  • Title: Source Code
    Maximum Length: 30
    The code indicating the source of the message. For example, Agent UI, Customer UI, and API. A list of accepted values is defined in the lookup ORA_SVC_SOURCE_CD.
  • Title: Service Request Business Unit
    Read Only: true
    The identifier of the business unit associated with the service request.
  • Title: Service Request ID
    The unique identifier of the service request to which the message is associated.
  • Title: Inline Attachment Identifiers
    Maximum Length: 1000
    The list of inline attachment identifiers associated with the service request
  • Title: Service Request Number
    Maximum Length: 30
    The public unique number of the a service request.
  • Title: Service Request Application Stripe
    Read Only: true
    Maximum Length: 30
    The application stripe of the service request.
  • Title: Status Code
    Maximum Length: 30
    The code indicating the status of the message. The accepted values are Draft, Committed, and Corrected.
  • Title: Subject
    Maximum Length: 1000
    The subject of the service request message.
  • Title: Template Name
    Maximum Length: 240
    The name of the template used to send an email response to a customer.
  • Title: Thread Count
    Read Only: true
    The number of threads in a service request message.
  • Title: Thread Hierarchy Level
    Read Only: true
    The level of the thread in the message hierarchy.
  • Title: Thread Identifier
    Read Only: true
    The unique ID of the service request message thread.
  • Title: Thread Last Updated Date
    Read Only: true
    The date when the message was last updated.
  • Title: Thread Message Last Updated Date
    Read Only: true
    The date when the thread message was last updated.
  • Title: Can Update
    Read Only: true
    Indicates if the message has been updated.
  • Title: Visibility Code
    Maximum Length: 30
    The code indicating the privacy level of the message. The accepted values are Internal and External. Null value indicates that the message is External. A list of accepted values is defined in the lookup ORA_SVC_MESSAGE_VISIBILITY_CD.
Nested Schema : Attachments
Type: array
Title: Attachments
The attachments resource is used to view, create, update, and delete attachments associated with a message. An attachment includes additional information about a message.
Show Source
Nested Schema : Channel Communications
Type: array
Title: Channel Communications
The channel communications resource is used to view, create, update, and delete channel communications. Channel communication is information about the communication between support agents and their customers. For example, the type of communication information that is recorded includes message identifiers, contact identifiers, and contact point identifiers.
Show Source
Nested Schema : serviceRequests-messages-Attachment-item-response
Type: object
Show Source
Nested Schema : AttachmentsDFFVL
Type: array
Show Source
Nested Schema : Attachments Preview
Type: array
Title: Attachments Preview
The attachments preview resource is used to preview the attachment pages.
Show Source
Nested Schema : serviceRequests-messages-Attachment-AttachmentsDFFVL-item-response
Type: object
Show Source
Nested Schema : serviceRequests-messages-Attachment-AttachmentsPreview-item-response
Type: object
Show Source
Nested Schema : serviceRequests-messages-channelCommunication-item-response
Type: object
Show Source
  • Title: Account Name
    Read Only: true
    Maximum Length: 400
    The account name associated with the channel. For example, for email, an account name would be the inbound mailbox for support like support@abc.com.
  • Title: Display Name
    Maximum Length: 400
    The display name of the channel.
  • Title: Channel ID
    The unique identifier of the channel.
  • Title: Channel Short Name
    Maximum Length: 450
    The public unique identifier of the channel.
  • Title: Channel Type
    Read Only: true
    Maximum Length: 30
    The code indicating the channel type. For example, email, phone, social, and so on. A list of accepted values is defined in the lookup ORA_SVC_CHANNEL_TYPE_CD.
  • Title: Collaboration ID
    Read Only: true
    Maximum Length: 255
    The unique identifier of the collaboration network user in the corresponding network. An example of this is the slack user Id. of a user.
  • Title: Resource Name
    Read Only: true
    Maximum Length: 400
    The user name of the external user on the collaboration network.
  • Title: Collaboration Resource Identifier
    The unique identifier of the collaboration network user that the internal users are communicating with.
  • Title: Contact Point ID
    The unique identifier of the contact point record of the contact who is being communicated with. A contact point is a contact's identifier for a specific channel of communication. For example, the contact point for the email channel would be an email address and the contact point of a person for twitter would be the twitter handle.
  • Title: Created By
    Read Only: true
    Maximum Length: 64
    The user who created the communication channel.
  • Title: Creation Date
    Read Only: true
    The date and time when the communication channel was created.
  • Title: Inbound Message Object Identifier
    The unique identifier of the inbound object that resulted in the creation of the service request message.
  • Title: Last Updated Date
    Read Only: true
    The date and time when the communication channel was last updated.
  • Title: Updated By
    Read Only: true
    Maximum Length: 64
    The user who last updated the communication channel.
  • Title: Update Login
    Read Only: true
    Maximum Length: 32
    The session login associated to the user who last updated the communication channel.
  • Links
  • Title: Message Number
    Read Only: true
    Maximum Length: 30
    The public unique identifier of the service request message.
  • Title: Network
    Read Only: true
    Maximum Length: 30
    The code indicating the social network of the post. For example, Facebook, Twitter. A list of accepted values is defined in the lookup HZ_INSTANT_MESSENGER_TYPE.
  • Title: Object ID
    The unique identifier of the object. Depending on the object type, indicates the service request id or the service request message id associated with the channel communication.
  • Title: Object Type
    Read Only: true
    Maximum Length: 30
    Default Value: SVC_SR_MESSAGES
    The code indicating whether the channel communication record is associated to the service request or the service request message. A list of accepted values is defined in the lookup ORA_SVC_CHANNEL_OBJECT_TYPE_CD.
  • Title: Party ID
    The unique party identifier of the person who is being communicated with.
  • Title: Party Name
    Read Only: true
    Maximum Length: 360
    The party name of the person who is being communicated with. The user can be an internal resource or a customer contact.
  • Title: Party Number
    Read Only: true
    Maximum Length: 30
    The public unique identifier of the contact associated with the service request message.
  • Title: Party Endpoint
    Maximum Length: 1000
    The endpoint used to communicate with the Party_ID owner. For example, email address, phone number, and so on. When Party_ID is NULL and PartyViaEndPoint is not NULL, the endpoint belongs to an adhoc party.
  • Title: Person ID
    The unique identifier of the person who is a contact on the service request.
  • Title: Post Identifier
    Maximum Length: 1000
    The unique identifier of the social media post record that was used to create the service request or the service request message.
  • Title: Resource ID
    Read Only: true
    The unique identifier of the resource associated with the service request. This is a foreign key that can identify the collaboration network user the internal users are communicating with.
  • Title: Resource Type
    Read Only: true
    Maximum Length: 30
    The code indicating the type of the collaborative network user, such as USER, PUBLIC_CHANNEL, or PRIVATE_CHANNEL. A list of accepted values is defined in the lookup ORA_SVC_COLLAB_RES_TYPE_CD.
  • Title: Routing Code
    Maximum Length: 30
    The code indicating how the message was routed through the endpoint. For example, if the endpoint is email address the field indicates if the recipient was a TO, a CC, or a BCC recipient. A list of accepted values is defined in the lookup ORA_SVC_CHANNEL_ROUTING_CD.
  • Title: ID
    Read Only: true
    The unique identifier of the channel communication.
Back to Top

Examples

The following example shows how to create an advanced query to get all messages by submitting a POST request on the REST resource.

cURL Command

curl -X POST --location 'https://servername.fa.us2.oraclecloud.com/api/boss/data/objects/ora/cxServiceCore/srMgmt/v1/serviceRequests/{serviceRequests_id}/messages/$query'\
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer <token>
--data @request.json

Example of Request Body

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

{
    "fields" : ["id","number","subject","messageContent"]
}

Example of Response Body

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

{
    "items": [
        {
            "id": "300100122471262",
            "number": "CDRM_11",
            "subject": null,
            "messageContent": "The printer in the Finance Department (Model: HP LaserJet Pro) is malfunctioning. It frequently jams and sometimes fails to print documents altogether. We have tried basic troubleshooting steps like clearing paper jams and restarting the printer, but the problem persists. Please send a technician to fix the issue.",
            "$id": "300100122471262",
            "$context": {
                "etag": "1",
                "links": {
                    "$self": {
                        "href": "https://servername.fa.us2.oraclecloud.com/api/boss/data/objects/ora/cxServiceCore/srMgmt/v1/serviceRequests/SR0000011001/messages/300100122471262"
                    }
                }
            }
        },
        {
            "id": "300100122471260",
            "number": "CDRM_10",
            "subject": null,
            "messageContent": "A contact could not be associated with the SR because no contact was available with the social handle 1139536692773011.",
            "$id": "300100122471260",
            "$context": {
                "etag": "1",
                "links": {
                    "$self": {
                        "href": "https://servername.fa.us2.oraclecloud.com/api/boss/data/objects/ora/cxServiceCore/srMgmt/v1/serviceRequests/SR0000011001/messages/300100122471260"
                    }
                }
            }
        }
    ],
    "hasMore": false
}
Back to Top