Get All Pricing Rules

get

/rest/v19/pricingSetup/rules

Use this endpoint to retrieve all pricing rules.

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=ruleModels,customerSpecificConditions. 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>;<variableName>=<variableValue>
    The following are the available finder names and corresponding finder variables:

    • findByKeyword: Find pricing rules using name,variableName and description.
      Finder Variable:
      • keyword;string: The search text.
    • findRelatedRulesForModel: Find pricing rules using pricing model variable name.This excludes any models that are already linked to the pricing rule.
      Finder Variable:
      • modelVariableName;string: The variableName of the model.
  • 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_PricingRule
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
The details of the user who created the record.
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
The details of the user who modified the record.
Show Source
Nested Schema : UserDetails
Type: object
Show Source
Nested Schema : PricingRule
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
The details of the user who created the record.
Show Source
Nested Schema : Customer Specific Conditions
Title: Customer Specific Conditions
Read Only: true
The collection of Customer specific conditions for the Pricing Rule.Note this is a child resource.
Match All
The collection of Customer specific conditions for the Pricing Rule.Note this is a child resource.
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
The details of the user who modified the record.
Show Source
Nested Schema : Linked Pricing Models
Title: Linked Pricing Models
Read Only: true
The collection of linked Price Models. Note this is a child resource.
Match All
The collection of linked Price Models. Note this is a child resource.
Show Source
Nested Schema : Simple Conditions
Title: Simple Conditions
The collection of simple conditions for the Pricing Rule of simple type. This is optional for other condition type.
Match All
The collection of simple conditions for the Pricing Rule of simple type. This is optional for other condition type.
Show Source
Nested Schema : PricingResourceCollection_PricingCustomerSpecificCondition
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
The details of the user who created the record.
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
The details of the user who modified the record.
Show Source
Nested Schema : PricingCustomerSpecificCondition
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
The details of the user who created the record.
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
The details of the user who modified the record.
Show Source
Nested Schema : PricingResourceCollection_PricingRuleModel
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
The details of the user who created the record.
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
The details of the user who modified the record.
Show Source
Nested Schema : PricingRuleModel
Type: object
Show Source
  • Title: The Adjustment Type of pricing model
    Read Only: true
    Allowed Values: [ "discountPercent", "discountAmount", "markupPercent", "markupAmount" ]
    Adjustment Type.
  • Created By
    Title: Created By
    Read Only: true
    The details of the user who created the record.
  • Title: Date Added
    Read Only: true
    Creation Date of the Pricing Model to Pricing Rule link.
  • Title: Date Modified
    Read Only: true
    Last modified date of the Pricing Model to Pricing Rule link.
  • Title: Description
    Read Only: true
    The description of the linked Pricing Model.
  • Title: Dynamic Pricing Type
    Read Only: true
    Allowed Values: [ "static", "advanced", "volume", "tiered", "rateCard", "attributeBasedCharge" ]
    The type of dynamic pricing applied by the linked Pricing Model.
  • Title: Edit Restriction
    Read Only: true
    Allowed Values: [ "UNRESTRICTED", "ONLY_REORDERABLE", "RESTRICTED" ]
    Pricing Edit Restriction.
  • Title: Has BOM Item
    Read Only: true
    Indicates whether this model has prices defined for BOM Items.
  • Title: Has Charge Support
    Read Only: true
    Indicates whether this model has charge support.
  • Last Modified By
    Title: Last Modified By
    Read Only: true
    The details of the user who modified the record.
  • Links
  • Title: The List Type for the pricing model
    Read Only: true
    Allowed Values: [ "priceList", "discountList", "advanced", "markupList", "advancedByTemplate" ]
    List Type.
  • Title: Name
    Read Only: true
    The name of the linked Pricing Model.
  • Title: Order Number
    The position(starting from 1) of the linked Pricing Model within the Pricing Rule.
  • Title: Linked Pricing Rules Count
    Read Only: true
    The count of pricing rules linked to this model.
  • Title: Value Type
    Read Only: true
    Allowed Values: [ "absolutePrice", "discountAmount", "discountPercent", "markupAmount", "markupPercent", "advancedByTemplate" ]
    The type of discount applied by the linked Pricing Model.
  • Title: Variable Name
    The Unique Variable Name of the linked Pricing Model.
Nested Schema : Created By
Title: Created By
Read Only: true
The details of the user who created the record.
Match All
The details of the user who created the record.
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
The details of the user who modified the record.
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 pricing rules in Pricing Engine by submitting a GET request to the REST resource using cURL. For more information about cURL, see Use cURL.

The following example includes the 'limit' query specification to limit the pricing rules in the results to five per page, and the 'orderby' query specification to order the results by order number in ascending order.

curl - X GET -H "Authorization: Bearer <token>" - H "Content-type: application/json"
https://sitename.oracle.com/rest/v19/pricingSetup/rules/?limit=5&orderby=orderNumber:ASC

Response Body Sample

{
  "items": [{
      "dateModified": "2022-06-27T23:17:09Z",
      "dateAdded": "2022-06-27T23:16:44Z",
      "name": "Base Pricing Rule",
      "variableName": "basePricingRule",
      "orderNumber": 1,
      "ruleConditionType": "advanced",
      "active": true,
      "ruleModelCount": 2,
      "productCount": 3,
      "links": [{
          "rel": "self",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules/basePricingRule"
        }, {
          "rel": "parent",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules"
        }, {
          "rel": "child",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules/basePricingRule/ruleModels"
        }, {
          "rel": "child",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules/basePricingRule/customerSpecificConditions"
        }
      ]
    }, {
      "dateModified": "2022-06-27T23:16:51Z",
      "dateAdded": "2022-06-22T20:37:40Z",
      "name": "Tier and Volume Pricing",
      "variableName": "tierAndVolumePricing",
      "orderNumber": 2,
      "ruleConditionType": "customerSpecific",
      "active": true,
      "ruleModelCount": 0,
      "productCount": 0,
      "links": [{
          "rel": "self",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules/tierAndVolumePricing"
        }, {
          "rel": "parent",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules"
        }, {
          "rel": "child",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules/tierAndVolumePricing/ruleModels"
        }, {
          "rel": "child",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules/tierAndVolumePricing/customerSpecificConditions"
        }
      ]
    }, {
      "dateModified": "2022-06-27T23:16:51Z",
      "dateAdded": "2019-05-02T13:37:28Z",
      "name": "oRCL_pRC_runAllProfiles",
      "variableName": "oRCLpRCrunAllProfiles",
      "orderNumber": 3,
      "ruleConditionType": "advanced",
      "active": true,
      "ruleModelCount": 2,
      "productCount": 0,
      "links": [{
          "rel": "self",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules/oRCLpRCrunAllProfiles"
        }, {
          "rel": "parent",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules"
        }, {
          "rel": "child",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules/oRCLpRCrunAllProfiles/ruleModels"
        }, {
          "rel": "child",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules/oRCLpRCrunAllProfiles/customerSpecificConditions"
        }
      ]
    }, {
      "dateModified": "2022-12-01T15:54:29Z",
      "dateAdded": "2019-11-04T14:56:12Z",
      "name": "CSP ABC Corp",
      "variableName": "cSPABCCorp",
      "orderNumber": 4,
      "ruleConditionType": "advanced",
      "active": true,
      "ruleModelCount": 1,
      "productCount": 0,
      "links": [{
          "rel": "self",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules/cSPABCCorp"
        }, {
          "rel": "parent",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules"
        }, {
          "rel": "child",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules/cSPABCCorp/ruleModels"
        }, {
          "rel": "child",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules/cSPABCCorp/customerSpecificConditions"
        }
      ]
    }, {
      "dateModified": "2022-12-01T15:54:29Z",
      "dateAdded": "2021-06-22T12:03:11Z",
      "name": "Banking Rule",
      "variableName": "bankingRule",
      "orderNumber": 5,
      "ruleConditionType": "customerSpecific",
      "active": true,
      "ruleModelCount": 1,
      "productCount": 3,
      "links": [{
          "rel": "self",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules/bankingRule"
        }, {
          "rel": "parent",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules"
        }, {
          "rel": "child",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules/bankingRule/ruleModels"
        }, {
          "rel": "child",
          "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules/bankingRule/customerSpecificConditions"
        }
      ]
    }
  ],
  "offset": 0,
  "limit": 5,
  "count": 5,
  "hasMore": true,
  "links": [{
      "rel": "canonical",
      "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules"
    }, {
      "rel": "self",
      "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules?offset=0&limit=5&orderby=orderNumber:ASC"
    }, {
      "rel": "next",
      "href": "https://sitename.oracle.com/rest/v19/pricingSetup/rules?offset=5&limit=5&orderby=orderNumber:ASC"
    }
  ]
}
Back to Top