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

Get all service request with resource members using advanced query

post

/api/boss/data/objects/ora/cxServiceCore/srMgmt/v1/serviceRequests/$views/serviceRequestResources/$query

Request

There are no request parameters for this operation.

Supported Media Types
Request Body - application/json ()
Root Schema : schema
Match All
Show Source
Nested 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 : 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.
Nested Schema : parameters
Type: object
Values to be applied in a parameterized filter specific to the view.
Back to Top

Response

Default Response

Successful response of retrieving view serviceRequestResources for resource Service Requests
Body ()
Root Schema : serviceRequests_view-serviceRequestResources
Match All
Show Source
Nested Schema : __collection_context
Type: object
Show Source
Nested Schema : serviceRequests_view-serviceRequestResources-allOf[1]
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : items
Match All
Show Source
Nested Schema : __busObj_context
Type: object
Show Source
Nested Schema : items-allOf[1]
Type: object
Show Source
Nested Schema : $context
Type: object
Show Source
Nested Schema : links
Type: object
Read Only: true
Show Source
Nested Schema : $self
Type: object
Show Source
Nested Schema : resourceMembers
Match All
Show Source
Nested Schema : resourceMembers-allOf[1]
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : items
Match All
Show Source
Nested Schema : items-allOf[1]
Type: object
Show Source
Nested Schema : objectTypeCode
Match All
Indicates whether the resource is an individual or a team.
Show Source
  • Title: Service Request Team Member Type Code
    Read Only: true
    Default Value: ORA_SVC_RESOURCE
    Indicates whether the resource is an individual or a team.
  • Allowed Values: [ "ORA_SVC_RESOURCE_TEAM", "ORA_SVC_RESOURCE" ]
Nested Schema : resourceMember
Match All
Show Source
Nested Schema : resourceMember-allOf[1]
Type: object
Show Source
Nested Schema : person
Match All
Show Source
Nested Schema : person-allOf[1]
Type: object
Show Source
Nested Schema : id
Match All
Show Source
Nested Schema : name
Match All
Show Source
  • Read Only: true
  • Title: Name
    The combination of title, first, middle, last, and suffix names of the person.
Nested Schema : registryId
Match All
Show Source
  • Title: Registry ID
    The alternate identifier of the contact.
Back to Top

Examples

The following example shows how to get all service requests with resource members using advanced query.

cURL Command

curl -X POST --location 'https://servername.fa.us2.oraclecloud.com/api/boss/data/objects/ora/cxServiceCore/srMgmt/v1/$en-US/serviceRequests/$views/serviceRequestResources/$query' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer <token>' \

Example of Request Body

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

{
    "fields": [
        "id",
        "number",
        "title"       
    ],
    "collection": {
        "sortBy": [{"timeUpdated": "desc"}],
        "filter": "number='\''SR0000070185'\''"
    },
    "accessors": {
        "resourceMembers": {
            "fields": ["memberId", "objectTypeCode"],
            "accessors" : {
                "resourceMember" : {
                    "fields" : ["id", "registryId"]
			    }
           }
        }
    }
}

Example of Response Body

The following shows an example of the response body in JSON format.
{
    "items": [
        {
            "id": "300100655112085",
            "number": "SR0000070185",
            "title": "Test CRM SR",
            "$id": "SR0000070185",
            "$context": {
                "etag": "7",
                "links": {
                    "$self": {
                        "href": "https://servername.fa.us2.oraclecloud.com/api/boss/data/objects/ora/cxServiceCore/srMgmt/v1/$en-US/serviceRequests/SR0000070185"
                    }
                }
            },
            "resourceMembers": {
                "items": [
                    {
                        "memberId": "300100655112108",
                        "objectTypeCode": "ORA_SVC_RESOURCE",
                        "$id": "300100655112108",
                        "$context": {
                            "etag": "1",
                            "links": {
                                "$self": {
                                    "href": "https://servername.fa.us2.oraclecloud.com/api/boss/data/objects/ora/cxServiceCore/srMgmt/v1/$en-US/serviceRequests/SR0000070185/resourceMembers/300100655112108"
                                }
                            }
                        },
                        "resourceMember": {
                            "id": "300100077629428",
                            "registryId": "CDRM_326027",
                            "$id": "CDRM_326027",
                            "$context": {
                                "etag": "23",
                                "links": {
                                    "$self": {
                                        "href": "https://servername.fa.us2.oraclecloud.com/api/boss/data/objects/ora/cxSalesCommon/resourceMgmt/v1/$en-US/resources/CDRM_326027"
                                    }
                                }
                            }
                        }
                    }
                ],
                "hasMore": false
            }
        }
    ],
    "hasMore": false
}
Back to Top