Jump to

• Request
• Response
• Examples

Get a Saved Search

get

/rest/v19/searchResources/{resourceVarName}/{searchId}

Use this endpoint to retrieve the specified saved search.

Request

Path Parameters

• resourceVarName(required): string
  The unique variable name to identify the process.
• searchId(required): number
  The unique id of the search.

Back to Top

Response

200 Response

The response for getting a single saved search.

Body ()

Root Schema : savedSearchItem

Type: object

Show Source

• active: boolean
• aggregations: object SavedSearchGroupByModel
• default: boolean
• deletable: string
• description: string
  Example: This is a dummy description
• fields: array fields
• hidden: boolean
• links: array links
• mongoQuery: object mongoQuery
  Additional Properties Allowed: additionalProperties
• name: string
  Example: savedSearchDummy
• orderBy: array orderBy
• queryUuid: number
• savedSearchNumber: number
• searchType: string
  Allowed Values: [ "_user_defined_search", "_my_quotes_search", "_my_approval_search" ]
• shared: boolean
• siteLevelDefault: boolean
• updatable: boolean
• userId: number
• userKey: string
• userLevelDefault: boolean
• userName: string

{
    "type":"object",
    "properties":{
        "name":{
            "type":"string",
            "example":"savedSearchDummy"
        },
        "description":{
            "type":"string",
            "example":"This is a dummy description"
        },
        "queryUuid":{
            "type":"number"
        },
        "savedSearchNumber":{
            "type":"number"
        },
        "default":{
            "type":"boolean"
        },
        "updatable":{
            "type":"boolean"
        },
        "userId":{
            "type":"number"
        },
        "userName":{
            "type":"string"
        },
        "fields":{
            "type":"array",
            "items":{
                "type":"string"
            }
        },
        "shared":{
            "type":"boolean"
        },
        "active":{
            "type":"boolean"
        },
        "searchType":{
            "type":"string",
            "enum":[
                "_user_defined_search",
                "_my_quotes_search",
                "_my_approval_search"
            ]
        },
        "mongoQuery":{
            "type":"object",
            "additionalProperties":{
            }
        },
        "orderBy":{
            "type":"array",
            "items":{
                "type":"string",
                "example":"_id:desc"
            }
        },
        "siteLevelDefault":{
            "type":"boolean"
        },
        "userLevelDefault":{
            "type":"boolean"
        },
        "hidden":{
            "type":"boolean"
        },
        "userKey":{
            "type":"string"
        },
        "deletable":{
            "type":"string"
        },
        "aggregations":{
            "$ref":"#/definitions/SavedSearchGroupByModel"
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/link"
            }
        }
    }
}

Nested Schema : SavedSearchGroupByModel

Type: object

Show Source

• attribute: string
• sort: string
  Default Value: desc

  Allowed Values: [ "asc", "desc" ]

{
    "type":"object",
    "properties":{
        "attribute":{
            "type":"string"
        },
        "sort":{
            "type":"string",
            "enum":[
                "asc",
                "desc"
            ],
            "default":"desc"
        }
    }
}

Nested Schema : fields

Type: array

Show Source

• Array of: string

{
    "type":"array",
    "items":{
        "type":"string"
    }
}

Nested Schema : links

Type: array

Show Source

• Array of: object reference links
  Title: reference links

  Reference links for the Parent, Self, Children and Related as applicable

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/link"
    }
}

Nested Schema : mongoQuery

Type: object

Additional Properties Allowed

Show Source

{
    "type":"object",
    "additionalProperties":{
    }
}

Nested Schema : orderBy

Type: array

Show Source

• Array of: string
  Example: _id:desc

{
    "type":"array",
    "items":{
        "type":"string",
        "example":"_id:desc"
    }
}

Nested Schema : reference links

Type: object

Title: reference links

Reference links for the Parent, Self, Children and Related as applicable

Show Source

• href: string
  Title: URL to the related object

  URL to the related object
• rel: string
  Title: Link Relationship to the current object

  Link Relationship to the current object

{
    "type":"object",
    "properties":{
        "rel":{
            "type":"string",
            "description":"Link Relationship to the current object",
            "title":"Link Relationship to the current object"
        },
        "href":{
            "type":"string",
            "description":"URL to the related object",
            "title":"URL to the related object"
        }
    },
    "title":"reference links",
    "description":"Reference links for the Parent, Self, Children and Related as applicable"
}

404 Response

Search with id not be found

Back to Top

Examples

The following example shows how to retrieve the specified saved search by submitting a GET request to the REST resource using cURL. For more information about cURL, see Use cURL.

curl -X GET -H "Authorization: Bearer <token>" -H "Accept: application/json"
https://sitename.oracle.com/rest/v19/searchResources/commerceDocumentsOraclecpqoTransaction/38678835

Response Body Sample

{
  "_entity": "Quote",
  "name": "Vision Quotes In Process",
  "description": "",
  "updatable": true,
  "deletable": true,
  "queryUuid": 38678835,
  "savedSearchNumber": 38678835,
  "default": false,
  "shared": false,
  "active": true,
  "userId": 4119220,
  "userName": "superuser",
  "userKey": "ecde4a3c-1924-488f-821c-d4defcfafce3",
  "fields": [
    "transactionID_t",
    "version_t",
    "version_number_versionTransaction_t",
    "_customer_t_company_name",
    "transactionName_t",
    "status_t",
    "totalContractValue_t",
    "owner_t",
    "createdDate_t",
    "lastUpdatedDate_t",
    "totalAnnualValue_t"
  ],
  "orderBy": [
    "lastUpdatedDate_t:desc"
  ],
  "mongoQuery": {
    "$and": [{
        "_customer_t_company_name": {
          "$regex": "Vision"
        }
      }, {
        "status_t": {
          "$eq": "OPEN"
        }
      }
    ]
  },
  "searchType": "user_defined_search",
  "siteLevelDefault": false,
  "userLevelDefault": false,
  "hidden": false,
  "links": [{
      "rel": "self",
      "href": "http://sitename.oracle.comrest/v16/searchResources/commerceDocumentsOraclecpqoTransaction/38678835",
      "name": "self"
    }, {
      "rel": "canonical",
      "href": "http://sitename.oracle.comrest/v16/searchResources/commerceDocumentsOraclecpqoTransaction/38678835",
      "name": "canonical"
    }, {
      "rel": "parent",
      "href": "http://sitename.oracle.comrest/v16/searchResources/commerceDocumentsOraclecpqoTransaction",
      "name": "parent"
    }
  ]
}

Back to Top