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:
objectMaps 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:
arrayRestricts the resource fields. Only the specified fields and mandatory system fields are returned.
Show Source
Nested Schema : subTypes
Type:
objectMaps 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 ByRead Only:trueThe resource who has created the SR. -
serviceRequestsAgentReassign: string
(big-integer)
Title:
Agent Reassignment TodayRead Only:trueThe count of all SRs reassigned to a different agent on a specific date. -
serviceRequestsAllAwaitingCustomer: string
(big-integer)
Title:
Awaiting responseRead Only:trueThe count of all SRs awaiting customer response. -
serviceRequestsAllClosed: string
(big-integer)
Title:
All ClosedRead Only:trueThe count of all closed SRs. -
serviceRequestsAllDeleted: string
(big-integer)
Title:
All DeletedRead Only:trueThe count of all deleted SRs. -
serviceRequestsAllInProgress: string
(big-integer)
Title:
All in ProgressRead Only:trueThe count of all SRs in In Progress status. -
serviceRequestsAllNew: string
(big-integer)
Title:
All NewRead Only:trueThe count of all SRs in New status. -
serviceRequestsAllOpen: string
(big-integer)
Title:
All OpenRead Only:trueThe count of all SRs in Open status. -
serviceRequestsAllOpenCritical: string
(big-integer)
Title:
All Open CriticalRead Only:trueThe count of all SRs that are critical, reopened, and still open as of a specific date. -
serviceRequestsAllPendingAgent: string
(big-integer)
Title:
All Pending AgentRead Only:trueThe count of all SRs awaiting action by the agent. -
serviceRequestsAllPurged: string
(big-integer)
Title:
All PurgedRead Only:trueThe count of all SRs in Purged status. -
serviceRequestsAllReopen: string
(big-integer)
Title:
All ReopenedRead Only:trueThe count of all SRs that are critical, reopened and still open on a specific date. -
serviceRequestsAllReopenCritical: string
(big-integer)
Title:
All Reopened CriticalRead Only:trueThe count of all SRs that were reopened and still open on a specific date. -
serviceRequestsAllResolved: string
(big-integer)
Title:
All ResolvedRead Only:trueThe count of all resolved SRs but not yet closed. -
serviceRequestsAllUnassigned: string
(big-integer)
Title:
All UnassignedRead Only:trueThe count of all SRs not yet assigned to a specific agent, including those in queues. -
serviceRequestsAllUnclaim: string
(big-integer)
Title:
All UnclaimedRead Only:trueThe count of SRs across all queues that haven't been claimed. -
serviceRequestsAllUnresolved: string
(big-integer)
Title:
All UnresolvedRead Only:trueThe count of all unresolved SRs. -
serviceRequestsAllWaiting: string
(big-integer)
Title:
All WaitingRead Only:trueThe count of all SRs in Waiting status. -
serviceRequestsClosed: string
(big-integer)
Title:
Closed TodayRead Only:trueThe count of all SRs closed on a specific date. -
serviceRequestsCreated: string
(big-integer)
Title:
Created TodayRead Only:trueThe count of all SRs created on a specific date. -
serviceRequestsCriticalCreated: string
(big-integer)
Title:
Created Critical TodayRead Only:trueThe count of critical SRs created on a specific date. -
serviceRequestsDeleted: string
(big-integer)
Title:
Deleted TodayRead Only:trueThe count of critical SRs deleted on a specific date. -
serviceRequestsInitialAgentAssign: string
(big-integer)
Title:
Initial Agent Assignment TodayRead Only:trueThe count of all SRs assigned to a queue for the first time on a specific date. -
serviceRequestsInitialQueueAssign: string
(big-integer)
Title:
Initial Queue Assignment TodayRead Only:trueThe count of all SRs assigned to a named resource for the first time. -
serviceRequestsOpen: string
(big-integer)
Title:
Opened TodayRead Only:trueThe count of all SRs opened on a specific date. -
serviceRequestsOpenCritical: string
(big-integer)
Title:
Opened Critical TodayRead Only:trueThe count of critical SRs opened on a specific date. -
serviceRequestsPurged: string
(big-integer)
Title:
Purged TodayRead Only:trueThe count of critical SRs purged on a specific date. -
serviceRequestsQueueReassign: string
(big-integer)
Title:
Queue Reassignment TodayRead Only:trueThe count of all SRs reassigned to a different queue on a specific date. -
serviceRequestsReopen: string
(big-integer)
Title:
Reopened TodayRead Only:trueThe count of all SRs reopened on a specific date. -
serviceRequestsReopenCritical: string
(big-integer)
Title:
Reopened Critical TodayRead Only:trueThe count of critical SRs reopened on a specific date. -
serviceRequestsResolved: string
(big-integer)
Title:
Resolved TodayRead Only:trueThe count of all SRs resolved on a specific date. -
serviceRequestsSummarizationId: string
(big-integer)
Title:
Summarization IDRead Only:trueThe unique identifier of the service request summarization. -
serviceRequestsUpdated: string
(big-integer)
Title:
Updated TodayRead Only:trueThe count of all SRs that were updated on a specific date. -
stripeCode:
stripeCode
-
summarizationDate: string
(date-time)
Title:
Summarization DateRead Only:trueThe date on which the summarization data is captured. -
timeCreated: string
(date-time)
Title:
Created DateRead Only:trueThe date and time at which the record was created. -
timeUpdated: string
(date-time)
Title:
Updated DateRead Only:trueThe date and time at which the record was updated. -
updatedBy: string
Title:
Updated ByRead Only:trueThe resource who has updated the record.
Nested Schema : Service Request Summarization
Type:
objectTitle:
Service Request SummarizationLinks
- $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"
}
}
}
}