Get Price Models

get

/rest/v16/pricingSetup/models

Use this endpoint retrieve all price models.

Request

Query Parameters
  • When this parameter is provided, the specified children are included in the resource payload (instead of just a link). More than one child can be specified using comma as a separator. Example: ?expand=priceModelItems,data. To include all the children and grandchildren, specify the value of this query parameter to be "all".
  • This parameter filters the resource attributes. Only the specified attributes are returned, which means that if no attributes are specified, all attributes are returned.
  • Used as a predefined finder to search the collection.
    Format: ?finder=<finderName>;<VarName>=<variableValue>
    The following are the available finder names and corresponding finder variables:
    • findByKeyword: Find pricing rules using name,VarName and description.
      Finder Variable:
      • keyword;string: The search text. The character '%' if present will be treated as a wild card otherwise, the default is 'contains' search
    • findLinkableModelsForRule: Find price models available for linking with pricing rule.This excludes any models that are already linked to the pricing rule.
      Finder Variable:
      • ruleVarName;string: The VarName of the rule.
    • findByRateCardVarName: Find price models linked to a given rate card.
      Finder Variable:
      • rateCardVarName;string: The VarName of the rate card
    • findModelsByTemplateVarName: Find price models linked to a given pricing matrix template.
      Finder Variable:
      • templateVarName;string: The VarName of the pricing matrix template.
    • findListTypeForModel: Find list type in price models.
      Finder Variable:
      • listTypeCode;string: The ListTypeCode, advanced, priceList or discountList
  • This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
  • Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
  • The resource item payload will be filtered in order to contain only data (no links section, for example).
  • This parameter orders a resource collection based on the specified attributes. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "ASC" or "DESC". Specify "ASC" for ascending and "DESC" for descending. The default value is "ASC". For example, ?orderby=field1:ASC,field2:DESC.
  • The resource collection representation will include the total row count when "?totalResults=true", otherwise the count is not included. The default value is "false".
Back to Top

Response

Supported Media Types

200 Response

Success
Body ()
Root Schema : PricingResourceCollection_PricingModel
Type: object
Show Source
  • Title: Count
    Read Only: true
    The number of resource instances returned in the current range.
  • Created By
    Title: Created By
    Read Only: true
    The details of the user who created the record.
  • Title: HasMore
    Read Only: true
    Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
  • items
  • Last Modified By
    Title: Last Modified By
    Read Only: true
    The details of the user who modified the record.
  • Title: Limit
    Read Only: true
    The actual paging size used by the server.
  • Links
  • Title: OffSet
    Read Only: true
    The offset value used in the current page.
  • Title: Total Results
    Read Only: true
    Captures the total count of the resource instances, which not only includes the instances in the current range, but all instances on the server that satisfy the request.
Nested Schema : Created By
Title: Created By
Read Only: true
The details of the user who created the record.
Match All
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : Last Modified By
Title: Last Modified By
Read Only: true
The details of the user who modified the record.
Match All
Show Source
Nested Schema : UserDetails
Type: object
Show Source
Nested Schema : PricingModel
Type: object
Show Source
Nested Schema : Created By
Title: Created By
Read Only: true
The details of the user who created the record.
Match All
Show Source
Nested Schema : Model Data
Title: Model Data
Read Only: true
List of data for the Price Model.
Match All
Show Source
Nested Schema : Last Modified By
Title: Last Modified By
Read Only: true
The details of the user who modified the record.
Match All
Show Source
Nested Schema : Model Items
Title: Model Items
Read Only: true
List of model items for the Price Model.
Match All
Show Source
Nested Schema : Simple Conditions
Title: Simple Conditions
A collection of simple Type conditions applied by the Price Model. This is optional for other condition type.
Match All
Show Source
Nested Schema : PricingResourceCollection_PricingModelData
Type: object
Show Source
  • Title: Count
    Read Only: true
    The number of resource instances returned in the current range.
  • Created By
    Title: Created By
    Read Only: true
    The details of the user who created the record.
  • Title: HasMore
    Read Only: true
    Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
  • items
  • Last Modified By
    Title: Last Modified By
    Read Only: true
    The details of the user who modified the record.
  • Title: Limit
    Read Only: true
    The actual paging size used by the server.
  • Links
  • Title: OffSet
    Read Only: true
    The offset value used in the current page.
  • Title: Total Results
    Read Only: true
    Captures the total count of the resource instances, which not only includes the instances in the current range, but all instances on the server that satisfy the request.
Nested Schema : Created By
Title: Created By
Read Only: true
The details of the user who created the record.
Match All
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : Last Modified By
Title: Last Modified By
Read Only: true
The details of the user who modified the record.
Match All
Show Source
Nested Schema : PricingModelData
Type: object
Show Source
Nested Schema : Block Prices
Type: array
Title: Block Prices
The block price.
Show Source
Nested Schema : Created By
Title: Created By
Read Only: true
The details of the user who created the record.
Match All
Show Source
Nested Schema : Last Modified By
Title: Last Modified By
Read Only: true
The details of the user who modified the record.
Match All
Show Source
Nested Schema : Prices
Type: array
Title: Prices
The item prices.
Show Source
Nested Schema : PricingCurrencyValues
Type: object
Show Source
Nested Schema : PricingResourceCollection_PriceModelItem
Type: object
Show Source
  • Title: Count
    Read Only: true
    The number of resource instances returned in the current range.
  • Created By
    Title: Created By
    Read Only: true
    The details of the user who created the record.
  • Title: HasMore
    Read Only: true
    Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
  • items
  • Last Modified By
    Title: Last Modified By
    Read Only: true
    The details of the user who modified the record.
  • Title: Limit
    Read Only: true
    The actual paging size used by the server.
  • Links
  • Title: OffSet
    Read Only: true
    The offset value used in the current page.
  • Title: Total Results
    Read Only: true
    Captures the total count of the resource instances, which not only includes the instances in the current range, but all instances on the server that satisfy the request.
Nested Schema : Created By
Title: Created By
Read Only: true
The details of the user who created the record.
Match All
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : Last Modified By
Title: Last Modified By
Read Only: true
The details of the user who modified the record.
Match All
Show Source
Nested Schema : PriceModelItem
Type: object
Show Source
Nested Schema : Associated Charges
Title: Associated Charges
Read Only: true
The standalone charges associated with this price model item.
Match All
Show Source
Nested Schema : Created By
Title: Created By
Read Only: true
The details of the user who created the record.
Match All
Show Source
Nested Schema : Last Modified By
Title: Last Modified By
Read Only: true
The details of the user who modified the record.
Match All
Show Source
Nested Schema : Associated Rate Plans
Title: Associated Rate Plans
Read Only: true
The rate plans linked to this price model item.
Match All
Show Source
Nested Schema : PricingResourceCollection_PricingCharge
Type: object
Show Source
  • Title: Count
    Read Only: true
    The number of resource instances returned in the current range.
  • Created By
    Title: Created By
    Read Only: true
    The details of the user who created the record.
  • Title: HasMore
    Read Only: true
    Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
  • items
  • Last Modified By
    Title: Last Modified By
    Read Only: true
    The details of the user who modified the record.
  • Title: Limit
    Read Only: true
    The actual paging size used by the server.
  • Links
  • Title: OffSet
    Read Only: true
    The offset value used in the current page.
  • Title: Total Results
    Read Only: true
    Captures the total count of the resource instances, which not only includes the instances in the current range, but all instances on the server that satisfy the request.
Nested Schema : Created By
Title: Created By
Read Only: true
The details of the user who created the record.
Match All
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : Last Modified By
Title: Last Modified By
Read Only: true
The details of the user who modified the record.
Match All
Show Source
Nested Schema : PricingCharge
Type: object
Show Source
Nested Schema : Block Prices
Type: array
Title: Block Prices
The block price.
Show Source
Nested Schema : Created By
Title: Created By
Read Only: true
The details of the user who created the record.
Match All
Show Source
Nested Schema : Last Modified By
Title: Last Modified By
Read Only: true
The details of the user who modified the record.
Match All
Show Source
Nested Schema : Prices
Type: array
Title: Prices
The item prices.
Show Source
Nested Schema : Tiers
Type: array
Title: Tiers
The charge tiers.
Show Source
Nested Schema : ChargeTier
Type: object
Show Source
Nested Schema : Block Prices
Type: array
Title: Block Prices
The block price for the corresponding tier.
Show Source
Nested Schema : Prices
Type: array
Title: Prices
The prices.
Show Source
Nested Schema : PricingResourceCollection_PricingRatePlan
Type: object
Show Source
  • Title: Count
    Read Only: true
    The number of resource instances returned in the current range.
  • Created By
    Title: Created By
    Read Only: true
    The details of the user who created the record.
  • Title: HasMore
    Read Only: true
    Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
  • items
  • Last Modified By
    Title: Last Modified By
    Read Only: true
    The details of the user who modified the record.
  • Title: Limit
    Read Only: true
    The actual paging size used by the server.
  • Links
  • Title: OffSet
    Read Only: true
    The offset value used in the current page.
  • Title: Total Results
    Read Only: true
    Captures the total count of the resource instances, which not only includes the instances in the current range, but all instances on the server that satisfy the request.
Nested Schema : Created By
Title: Created By
Read Only: true
The details of the user who created the record.
Match All
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : Last Modified By
Title: Last Modified By
Read Only: true
The details of the user who modified the record.
Match All
Show Source
Nested Schema : PricingRatePlan
Type: object
Show Source
Nested Schema : Charges
Title: Charges
Read Only: true
Rate Plan charges
Match All
Show Source
Nested Schema : Created By
Title: Created By
Read Only: true
The details of the user who created the record.
Match All
Show Source
Nested Schema : Last Modified By
Title: Last Modified By
Read Only: true
The details of the user who modified the record.
Match All
Show Source
Nested Schema : SimpleConditions
Type: object
Show Source
Nested Schema : Simple Condition Rows
Type: array
Title: Simple Condition Rows
A list of Simple Condition Rows.
Show Source
Nested Schema : SimpleConditionRow
Type: object
Show Source
  • Title: Display Name
    The display name of the Simple Condition Row.
  • Title: Index
    The index (starting from 1) of the Simple Condition Row.
  • Title: Operator
    Allowed Values: [ "NONE", "EQUAL_TO", "NOT_EQUAL_TO", "GREATER_THAN", "GREATER_THAN_EQUAL_TO", "LESS_THAN", "LESS_THAN_EQUAL_TO", "CONTAINS", "NOT_CONTAINS", "STARTS_WITH", "NOT_STARTS_WITH", "ENDS_WITH", "NOT_ENDS_WITH" ]
    The operation of the Simple Condition Row.
  • Title: Target Value
    The value to match.
  • Title: Simple Condition Row
    The variable name of the Simple Condition Row.
Back to Top

Examples

The following examples show how to retrieve all price models in Pricing Engine by submitting a GET request to the REST resource using cURL. For more information about cURL, see Use cURL.

The 'limit' query specification is used in the following example to limit the results to three models per page.

curl - X GET - i - H "Authorization: Basic dXNlcm5hbWU6cGFzc3dvcmQg" - H "Content-type: application/json"
https://sitename.oracle.com/rest/v16/pricingSetup/models?limit=3

Response Body Sample

{
  "items": [{
      "dateModified": "2021-09-17T11:42:19Z",
      "dateAdded": "2019-05-02T13:37:28Z",
      "name": "Subscription Charges",
      "variableName": "subscriptionCharges",
      "conditionType": "simple",
      "simpleConditions": {
        "ruleExpression": "1 OR 2 OR 3 OR 4 OR 5 OR 6 OR 7 OR 8",
        "simpleConditionRows": [{
            "index": 1,
            "variableName": "oRCL_pRC_partNumber",
            "displayName": "Part Number",
            "operator": "EQUAL_TO",
            "value": "Cloud Backup Service"
          }, {
            "index": 2,
            "variableName": "oRCL_pRC_partNumber",
            "displayName": "Part Number",
            "operator": "EQUAL_TO",
            "value": "Premium Cloud Backup Service"
          }, {
            "index": 3,
            "variableName": "oRCL_pRC_partNumber",
            "displayName": "Part Number",
            "operator": "EQUAL_TO",
            "value": "part10"
          }, {
            "index": 4,
            "variableName": "oRCL_pRC_partNumber",
            "displayName": "Part Number",
            "operator": "EQUAL_TO",
            "value": "part111"
          }, {
            "index": 5,
            "variableName": "oRCL_pRC_partNumber",
            "displayName": "Part Number",
            "operator": "EQUAL_TO",
            "value": "part1120"
          }, {
            "index": 6,
            "variableName": "oRCL_pRC_partNumber",
            "displayName": "Part Number",
            "operator": "EQUAL_TO",
            "value": "Surface Book 2"
          }, {
            "index": 7,
            "variableName": "oRCL_pRC_partNumber",
            "displayName": "Part Number",
            "operator": "EQUAL_TO",
            "value": "QP_Item3"
          }, {
            "index": 8,
            "variableName": "oRCL_pRC_productType",
            "displayName": "Product Type",
            "operator": "EQUAL_TO",
            "value": "subscription"
          }
        ]
      },
      "shared": false,
      "ruleCount": 1,
      "links": [{
          "rel": "self",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/models/subscriptionCharges"
        }, {
          "rel": "parent",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/models"
        }, {
          "rel": "child",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/models/subscriptionCharges/data"
        }
      ],
      "valueType": "absolutePrice",
      "dynamicPricingType": "advanced"
    }, {
      "dateModified": "2021-06-03T07:01:41Z",
      "dateAdded": "2019-07-22T11:41:51Z",
      "name": "CSP",
      "variableName": "cSP",
      "conditionType": "alwaysTrue",
      "shared": true,
      "ruleCount": 2,
      "links": [{
          "rel": "self",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/models/cSP"
        }, {
          "rel": "parent",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/models"
        }, {
          "rel": "child",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/models/cSP/data"
        }
      ],
      "valueType": "discountPercent",
      "dynamicPricingType": "static"
    }, {
      "dateModified": "2019-11-04T17:01:48Z",
      "dateAdded": "2019-11-04T15:02:18Z",
      "name": "CSP ABC Corp",
      "variableName": "cSPABCCorp",
      "conditionType": "simple",
      "simpleConditions": {
        "ruleExpression": "1 OR 2",
        "simpleConditionRows": [{
            "index": 1,
            "variableName": "companyName",
            "displayName": "Company Name",
            "operator": "EQUAL_TO",
            "value": "ABC Corp"
          }, {
            "index": 2,
            "variableName": "repeatCustomer",
            "displayName": "RepeatCustomer",
            "operator": "EQUAL_TO",
            "value": "true"
          }
        ]
      },
      "shared": false,
      "ruleCount": 1,
      "links": [{
          "rel": "self",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/models/cSPABCCorp"
        }, {
          "rel": "parent",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/models"
        }, {
          "rel": "child",
          "href": "https://sitename.oracle.com/rest/v16/pricingSetup/models/cSPABCCorp/data"
        }
      ],
      "valueType": "absolutePrice",
      "dynamicPricingType": "advanced"
    }
  ],
  "offset": 0,
  "limit": 3,
  "count": 3,
  "hasMore": true,
  "links": [{
      "rel": "canonical",
      "href": "https://sitename.oracle.com/rest/v16/pricingSetup/models"
    }, {
      "rel": "self",
      "href": "https://sitename.oracle.com/rest/v16/pricingSetup/models?offset=0&limit=3"
    }, {
      "rel": "next",
      "href": "https://sitename.oracle.com/rest/v16/pricingSetup/models?offset=3&limit=3"
    }
  ]
}
Back to Top