Get a service request summarization using advanced query
post
/api/boss/data/objects/ora/cxServiceCore/analytics/v1/serviceRequestSummarizations/{serviceRequestSummarizations_id}/$query
Request
Path Parameters
-
serviceRequestSummarizations_id(required): string
This path parameter maps to the following field defined in the Service Request Summarizations REST resource:
- serviceRequestsSummarizationId: The unique identifier of the service request summarization.
Query Parameters
-
$effectiveDate: string(date)
The effective date value in ISO 8601 date format 'YYYY-MM-DD'. This date is required by business logic to search for effective-dated business objects.
Supported Media Types
- application/json
Root Schema : schema
Type:
Show Source
object
-
accessors: object
accessors
Maps accessor names to query objects specific to corresponding accessors. Query object for each accessor supports query capabilities similar to the base.
-
fields: array
fields
Restricts the resource fields. Only the specified fields and mandatory system fields are returned.
-
subTypes: object
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 : 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.
Response
Default Response
A single item response
Nested Schema : oraCxServiceCoreAnalytics.ServiceRequestSummarization_item
Match All
Show Source
-
object
oraCxServiceCoreAnalytics.ServiceRequestSummarization_item-fields
-
object
Service Request Summarization
Title:
Service Request Summarization
Nested Schema : oraCxServiceCoreAnalytics.ServiceRequestSummarization_item-fields
Type:
Show Source
object
-
createdBy: string
Title:
Created By
Read Only:true
The resource who has created the SR. -
serviceRequestsAgentReassign: string
(big-integer)
Title:
Agent Reassignment Today
Read Only:true
The count of all SRs reassigned to a different agent on a specific date. -
serviceRequestsAllAwaitingCustomer: string
(big-integer)
Title:
Awaiting response
Read Only:true
The count of all SRs awaiting customer response. -
serviceRequestsAllClosed: string
(big-integer)
Title:
All Closed
Read Only:true
The count of all closed SRs. -
serviceRequestsAllDeleted: string
(big-integer)
Title:
All Deleted
Read Only:true
The count of all deleted SRs. -
serviceRequestsAllInProgress: string
(big-integer)
Title:
All in Progress
Read Only:true
The count of all SRs in In Progress status. -
serviceRequestsAllNew: string
(big-integer)
Title:
All New
Read Only:true
The count of all SRs in New status. -
serviceRequestsAllOpen: string
(big-integer)
Title:
All Open
Read Only:true
The count of all SRs in Open status. -
serviceRequestsAllOpenCritical: string
(big-integer)
Title:
All Open Critical
Read Only:true
The count of all SRs that are critical, reopened, and still open as of a specific date. -
serviceRequestsAllPendingAgent: string
(big-integer)
Title:
All Pending Agent
Read Only:true
The count of all SRs awaiting action by the agent. -
serviceRequestsAllPurged: string
(big-integer)
Title:
All Purged
Read Only:true
The count of all SRs in Purged status. -
serviceRequestsAllReopen: string
(big-integer)
Title:
All Reopened
Read Only:true
The count of all SRs that are critical, reopened and still open on a specific date. -
serviceRequestsAllReopenCritical: string
(big-integer)
Title:
All Reopened Critical
Read Only:true
The count of all SRs that were reopened and still open on a specific date. -
serviceRequestsAllResolved: string
(big-integer)
Title:
All Resolved
Read Only:true
The count of all resolved SRs but not yet closed. -
serviceRequestsAllUnassigned: string
(big-integer)
Title:
All Unassigned
Read Only:true
The count of all SRs not yet assigned to a specific agent, including those in queues. -
serviceRequestsAllUnclaim: string
(big-integer)
Title:
All Unclaimed
Read Only:true
The count of SRs across all queues that haven't been claimed. -
serviceRequestsAllUnresolved: string
(big-integer)
Title:
All Unresolved
Read Only:true
The count of all unresolved SRs. -
serviceRequestsAllWaiting: string
(big-integer)
Title:
All Waiting
Read Only:true
The count of all SRs in Waiting status. -
serviceRequestsClosed: string
(big-integer)
Title:
Closed Today
Read Only:true
The count of all SRs closed on a specific date. -
serviceRequestsCreated: string
(big-integer)
Title:
Created Today
Read Only:true
The count of all SRs created on a specific date. -
serviceRequestsCriticalCreated: string
(big-integer)
Title:
Created Critical Today
Read Only:true
The count of critical SRs created on a specific date. -
serviceRequestsDeleted: string
(big-integer)
Title:
Deleted Today
Read Only:true
The count of critical SRs deleted on a specific date. -
serviceRequestsInitialAgentAssign: string
(big-integer)
Title:
Initial Agent Assignment Today
Read Only:true
The count of all SRs assigned to a queue for the first time on a specific date. -
serviceRequestsInitialQueueAssign: string
(big-integer)
Title:
Initial Queue Assignment Today
Read Only:true
The count of all SRs assigned to a named resource for the first time. -
serviceRequestsOpen: string
(big-integer)
Title:
Opened Today
Read Only:true
The count of all SRs opened on a specific date. -
serviceRequestsOpenCritical: string
(big-integer)
Title:
Opened Critical Today
Read Only:true
The count of critical SRs opened on a specific date. -
serviceRequestsPurged: string
(big-integer)
Title:
Purged Today
Read Only:true
The count of critical SRs purged on a specific date. -
serviceRequestsQueueReassign: string
(big-integer)
Title:
Queue Reassignment Today
Read Only:true
The count of all SRs reassigned to a different queue on a specific date. -
serviceRequestsReopen: string
(big-integer)
Title:
Reopened Today
Read Only:true
The count of all SRs reopened on a specific date. -
serviceRequestsReopenCritical: string
(big-integer)
Title:
Reopened Critical Today
Read Only:true
The count of critical SRs reopened on a specific date. -
serviceRequestsResolved: string
(big-integer)
Title:
Resolved Today
Read Only:true
The count of all SRs resolved on a specific date. -
serviceRequestsSummarizationId: string
(big-integer)
Title:
Summarization ID
Read Only:true
The unique identifier of the service request summarization. -
serviceRequestsUpdated: string
(big-integer)
Title:
Updated Today
Read Only:true
The count of all SRs that were updated on a specific date. -
stripeCode:
stripeCode
-
summarizationDate: string
(date-time)
Title:
Summarization Date
Read Only:true
The date on which the summarization data is captured. -
timeCreated: string
(date-time)
Title:
Created Date
Read Only:true
The date and time at which the record was created. -
timeUpdated: string
(date-time)
Title:
Updated Date
Read Only:true
The date and time at which the record was updated. -
updatedBy: string
Title:
Updated By
Read Only:true
The resource who has updated the record.
Nested Schema : Service Request Summarization
Type:
object
Title:
Service Request Summarization
Links
- $self
-
Parameters:
- serviceRequestSummarizations_id:
$request.path.serviceRequestSummarizations_id
- serviceRequestSummarizations_id:
Examples
The following example shows how to create an advanced query to get a service request summarization 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/analytics/v1/serviceRequestSummarizations/{serviceRequestSummarizations_id}/$query
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer <token>' -D @request.json
Example of Request Body
The following example shows the contents of the request body in JSON format.
{ "fields": [ "serviceRequestsSummarizationId", "stripeCode", "summarizationDate", "serviceRequestsAllOpen", "serviceRequestsAllInProgress", "serviceRequestsAllResolved", "serviceRequestsAllClosed" ] }
Example of Response Body
The following example shows the contents of the response body in JSON format.
{ "serviceRequestsSummarizationId": "10030", "stripeCode": "ORA_SVC_ISR", "summarizationDate": "2025-03-07T00:00:00Z", "serviceRequestsAllOpen": "3781", "serviceRequestsAllInProgress": "68", "serviceRequestsAllResolved": "65", "serviceRequestsAllClosed": "22", "$id": "10030", "$context": { "etag": "1", "links": { "$self": { "href": "https://servername.fa.us2.oraclecloud.com/api/boss/data/objects/ora/cxServiceCore/analytics/v1/serviceRequestSummarizations/10030" } } } }