Get All Price Model Items
get
/rest/v19/pricingSetup/models/{modelVariableName}/priceModelItems
Use this endpoint to retrieve all price model items for the specified price model.
Request
Path Parameters
Query Parameters
-
distinct: boolean
The items returned in the resource collection will have distinct field values when "?distinct=true".
-
expand: string
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=charges,ratePlans. To include all the children and grandchildren, specify the value of this query parameter to be "all".
-
fields: string
This parameter filters the resource attributes. Only the specified attributes are returned, which means that if no attributes are specified, all attributes are returned.
-
finder: string
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 model items using part number, BOM Item Name, and BOM Item Variable Name.
Finder Variable:- keyword;string:The search text. The character '%' if present will be treated as a wild card otherwise, the default is 'contains' search
- findByKeyword: Find pricing model items using part number, BOM Item Name, and BOM Item Variable Name.
-
limit: integer
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.
-
offset: integer
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.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderby: string
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.
-
q: string
Filter (a ???where???clause) to restrict the items returned in the collection. By default, no filtering is applied.
-
totalResults: boolean
The resource collection representation will include the total row count when "?totalResults=true", otherwise the count is not included. The default value is "false".
Response
Supported Media Types
- application/json
200 Response
Success
Root Schema : PricingResourceCollection_PriceModelItem
Type:
Show Source
object-
count:
integer()
Title:
CountRead Only:trueThe number of resource instances returned in the current range. -
createdBy:
Created By
Title:
Created ByRead Only:trueThe details of the user who created the record. -
groupAccessEnabled:
boolean()
Title:
Group Access EnabledRead Only:trueIndicates whether the user has access to the groups segment -
hasMore:
boolean()
Title:
HasMoreRead Only:trueIndicates 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:
array items
-
lastModifiedBy:
Last Modified By
Title:
Last Modified ByRead Only:trueThe details of the user who modified the record. -
limit:
integer()
Title:
LimitRead Only:trueThe actual paging size used by the server. -
links:
array Links
Title:
LinksRead Only:trueThe link relations associated with the resource instance. -
offset:
integer()
Title:
OffSetRead Only:trueThe offset value used in the current page. -
segmentLevelAccessType:
string()
Title:
Segment-level Access TypeRead Only:trueSegment-level Access Type -
totalResults:
integer()
Title:
Total ResultsRead Only:trueCaptures 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 ByRead Only:
trueThe 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 ByRead Only:
trueThe details of the user who modified the record.
Match All
The details of the user who modified the record.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksRead Only:
trueThe link relations associated with the resource instance.
Show Source
Nested Schema : UserDetails
Type:
Show Source
object-
emailId:
string()
Title:
Email IdEmail Id of the user -
firstName:
string()
Title:
First NameFirst Name of the user -
lastName:
string()
Title:
Last NameLast Name of the user
Nested Schema : PriceModelItem
Type:
Show Source
object-
bomItemName:
string()
Title:
BOM Item NameThe BOM item's display name. When clients sets field bomItemVariableName, this field should also be explicitly set in the request. -
bomItemVariableName:
string()
Title:
BOM Item Variable NameThe BOM Item's variable name. -
chargeCount:
integer()
Title:
Associated Charges CountRead Only:trueThe count of charges directly associated with this price model item. -
charges:
Associated Charges
Title:
Associated ChargesRead Only:trueThe standalone charges associated with this price model item. -
createdBy:
Created By
Title:
Created ByRead Only:trueThe details of the user who created the record. -
dateAdded:
string(yyyy-MM-dd'T'HH:mm:ss.SSS'Z')
Title:
Date AddedRead Only:trueCreation date of the Price Model Item. -
dateModified:
string(yyyy-MM-dd'T'HH:mm:ss.SSS'Z')
Title:
Date ModifiedRead Only:trueLast modified date of the Price Model Item. -
description:
string()
Title:
Part DescriptionRead Only:trueThe description of the Price Model Item. -
groupAccessEnabled:
boolean()
Title:
Group Access EnabledRead Only:trueIndicates whether the user has access to the groups segment -
hasRatePlanSupport:
boolean()
Title:
Has Rate Plan SupportRead Only:trueIndicates if the Price Model Item supports rate plans. -
id:
integer()
Title:
IdRead Only:trueThe Unique Identifier of the Price Model Data. -
integrationId:
string()
Title:
Integration IdPrice List Item ID from SCM. -
lastModifiedBy:
Last Modified By
Title:
Last Modified ByRead Only:trueThe details of the user who modified the record. -
links:
array Links
Title:
LinksRead Only:trueThe link relations associated with the resource instance. -
partNumber:
string()
Title:
Part NumberThe part Number of the Price Model Item.This should match the Part Lookup's lookupCode. -
priceModelIntegrationId:
string()
Title:
Price Model Integration IdThe parent Price Model Integration ID. -
ratePlanCount:
integer()
Title:
Associated Rate Plans CountRead Only:trueThe count of rate plans linked to this price model item. -
ratePlans:
Associated Rate Plans
Title:
Associated Rate PlansRead Only:trueThe rate plans linked to this price model item. -
rootBomItemName:
string()
Title:
Root BOM Item NameThe root BOM item's display name. -
rootBomItemVariableName:
string()
Title:
Root BOM Item Variable NameThe root BOM item's variable name. -
salesProductType:
string()
Title:
Sales Product TypeRead Only:trueThe sales product type of the Price Model Item. -
segmentLevelAccessType:
string()
Title:
Segment-level Access TypeRead Only:trueSegment-level Access Type -
serviceDuration:
integer()
Title:
Service DurationThe service duration of this price model item. This value is relevant only for parts with variable service duration type and is ignored for other types. -
serviceDurationPeriod:
string()
Title:
Service Duration PeriodThe service duration period code of this price model item. This value is relevant only for parts with variable service duration type and is ignored for other types. -
serviceDurationType:
string()
Title:
Service Duration TypeService duration type.
Nested Schema : Associated Charges
Title:
Associated ChargesRead Only:
trueThe standalone charges associated with this price model item.
Match All
The standalone charges associated with this price model item.
Show Source
Nested Schema : Created By
Title:
Created ByRead Only:
trueThe 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 ByRead Only:
trueThe details of the user who modified the record.
Match All
The details of the user who modified the record.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksRead Only:
trueThe link relations associated with the resource instance.
Show Source
Nested Schema : Associated Rate Plans
Title:
Associated Rate PlansRead Only:
trueThe rate plans linked to this price model item.
Match All
The rate plans linked to this price model item.
Show Source
Nested Schema : PricingResourceCollection_PricingCharge
Type:
Show Source
object-
count:
integer()
Title:
CountRead Only:trueThe number of resource instances returned in the current range. -
createdBy:
Created By
Title:
Created ByRead Only:trueThe details of the user who created the record. -
groupAccessEnabled:
boolean()
Title:
Group Access EnabledRead Only:trueIndicates whether the user has access to the groups segment -
hasMore:
boolean()
Title:
HasMoreRead Only:trueIndicates 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:
array items
-
lastModifiedBy:
Last Modified By
Title:
Last Modified ByRead Only:trueThe details of the user who modified the record. -
limit:
integer()
Title:
LimitRead Only:trueThe actual paging size used by the server. -
links:
array Links
Title:
LinksRead Only:trueThe link relations associated with the resource instance. -
offset:
integer()
Title:
OffSetRead Only:trueThe offset value used in the current page. -
segmentLevelAccessType:
string()
Title:
Segment-level Access TypeRead Only:trueSegment-level Access Type -
totalResults:
integer()
Title:
Total ResultsRead Only:trueCaptures 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 ByRead Only:
trueThe 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 ByRead Only:
trueThe details of the user who modified the record.
Match All
The details of the user who modified the record.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksRead Only:
trueThe link relations associated with the resource instance.
Show Source
Nested Schema : PricingCharge
Type:
Show Source
object-
blockPrices:
array Block Prices
Title:
Block PricesThe block price. -
blockSize:
number()
Title:
Block SizeThe block size. -
chargeDefinition:
string()
Title:
Charge DefinitionRead Only:trueDisplay Name of the Charge Definition. -
chargeDefinitionCode:
string()
Title:
Charge Definition CodeThe unique code of the Charge Definition. -
chargeDefinitionId:
integer()
Title:
Charge Definition IDRead Only:trueID of the Charge Definition. -
chargeType:
string()
Title:
Charge TypeThe category of charge. -
createdBy:
Created By
Title:
Created ByRead Only:trueThe details of the user who created the record. -
dateAdded:
string(yyyy-MM-dd'T'HH:mm:ss.SSS'Z')
Title:
Date AddedRead Only:trueCreation date. -
dateModified:
string(yyyy-MM-dd'T'HH:mm:ss.SSS'Z')
Title:
Date ModifiedRead Only:trueLast modified date. -
dynamicPricingType:
string()
Title:
Dynamic Pricing TypeAllowed Values:[ "static", "advanced", "volume", "tiered", "rateCard", "attributeBasedCharge" ]The dynamic pricing type of the charge. -
endDate:
string(yyyy-MM-dd'T'HH:mm:ss.SSS'Z')
Title:
End DateThe date at which the Charge will end. -
groupAccessEnabled:
boolean()
Title:
Group Access EnabledRead Only:trueIndicates whether the user has access to the groups segment -
id:
integer()
Title:
IdRead Only:trueThe Unique Identifier of the Charge. -
integrationId:
string()
Title:
Integration IdRate Plan Charge ID from SCM. -
lastModifiedBy:
Last Modified By
Title:
Last Modified ByRead Only:trueThe details of the user who modified the record. -
links:
array Links
Title:
LinksRead Only:trueThe link relations associated with the resource instance. -
pricePeriod:
string()
Title:
Price PeriodThe billing period. -
prices:
array Prices
Title:
PricesThe item prices. -
priceType:
string()
Title:
Price TypeThe type of charge. -
pricingMatrixVariableName:
string()
Title:
Pricing Matrix Variable NamePricing Matrix variable name (Preview only. Not available for use.) -
primaryCharge:
boolean()
Title:
Primary ChargeIndicates whether this is the primary charge. -
quantityAggregation:
boolean()
Title:
Quantity AggregationIndicates whether to use aggregated quantity when calculating unit price for tiered-pricing. -
rateCardName:
string()
Title:
Rate Card NameRead Only:trueRate Card name (Preview only. Not available for use.) -
rateCardVariableName:
string()
Title:
Rate Card Variable NameRate Card variable name (Preview only. Not available for use.) -
segmentLevelAccessType:
string()
Title:
Segment-level Access TypeRead Only:trueSegment-level Access Type -
startDate:
string(yyyy-MM-dd'T'HH:mm:ss.SSS'Z')
Title:
Start DateThe date from which the Charge will be applicable. -
templateVariableName:
string()
Title:
Pricing Matrix Template Variable NameThe pricing matrix emplate variable name. -
tiers:
array Tiers
Title:
TiersThe charge tiers. -
usageUOM:
string()
Title:
Usage UOMThe unit of measure for the charge.
Nested Schema : Created By
Title:
Created ByRead Only:
trueThe 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 ByRead Only:
trueThe details of the user who modified the record.
Match All
The details of the user who modified the record.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksRead Only:
trueThe link relations associated with the resource instance.
Show Source
Nested Schema : PricingCurrencyValues
Type:
Show Source
object-
currencyCode:
string()
Title:
Currency CodeThe currency code. -
value:
number()
Title:
ValueThe currency value.
Nested Schema : ChargeTier
Type:
Show Source
object-
blockPrices:
array Block Prices
Title:
Block PricesThe block price for the corresponding tier. -
blockSize:
number()
Title:
Block SizeThe block size for the corresponding tier. -
prices:
array Prices
Title:
PricesThe prices. -
rangeFrom:
number()
Title:
Range FromThe starting range of the Charge. -
rangeTo:
number()
Title:
Range ToRead Only:trueThe ending range of the Charge.
Nested Schema : Block Prices
Type:
arrayTitle:
Block PricesThe block price for the corresponding tier.
Show Source
Nested Schema : PricingResourceCollection_PricingRatePlan
Type:
Show Source
object-
count:
integer()
Title:
CountRead Only:trueThe number of resource instances returned in the current range. -
createdBy:
Created By
Title:
Created ByRead Only:trueThe details of the user who created the record. -
groupAccessEnabled:
boolean()
Title:
Group Access EnabledRead Only:trueIndicates whether the user has access to the groups segment -
hasMore:
boolean()
Title:
HasMoreRead Only:trueIndicates 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:
array items
-
lastModifiedBy:
Last Modified By
Title:
Last Modified ByRead Only:trueThe details of the user who modified the record. -
limit:
integer()
Title:
LimitRead Only:trueThe actual paging size used by the server. -
links:
array Links
Title:
LinksRead Only:trueThe link relations associated with the resource instance. -
offset:
integer()
Title:
OffSetRead Only:trueThe offset value used in the current page. -
segmentLevelAccessType:
string()
Title:
Segment-level Access TypeRead Only:trueSegment-level Access Type -
totalResults:
integer()
Title:
Total ResultsRead Only:trueCaptures 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 ByRead Only:
trueThe 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 ByRead Only:
trueThe details of the user who modified the record.
Match All
The details of the user who modified the record.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksRead Only:
trueThe link relations associated with the resource instance.
Show Source
Nested Schema : PricingRatePlan
Type:
Show Source
object-
chargeCount:
integer()
Title:
Associated Charges CountRead Only:trueThe count of charges directly associated with this price model item. -
charges:
Charges
Title:
ChargesRead Only:trueRate Plan charges -
createdBy:
Created By
Title:
Created ByRead Only:trueThe details of the user who created the record. -
dateAdded:
string(yyyy-MM-dd'T'HH:mm:ss.SSS'Z')
Title:
Date AddedRead Only:trueCreation Date of the Pricing Rate Plan. -
dateModified:
string(yyyy-MM-dd'T'HH:mm:ss.SSS'Z')
Title:
Date ModifiedRead Only:trueLast Modified date of the Pricing Rate Plan. -
description:
string()
Title:
DescriptionDescription of the Pricing Rate Plan. -
endDate:
string()
Title:
End DateThe date after which the Pricing Rate Plan will no longer be applicable. -
groupAccessEnabled:
boolean()
Title:
Group Access EnabledRead Only:trueIndicates whether the user has access to the groups segment -
integrationId:
string()
Title:
Integration IDThe integration ID of the Pricing rate plan. -
lastModifiedBy:
Last Modified By
Title:
Last Modified ByRead Only:trueThe details of the user who modified the record. -
links:
array Links
Title:
LinksRead Only:trueThe link relations associated with the resource instance. -
name:
string()
Title:
NameName of the Pricing Rate Plan. -
orderNumber:
integer()
Title:
Order NumberThe position in a ordered list of Rate Plan. -
priceModelItemId:
integer()
Title:
Price ModelItem IdRead Only:trueThe Price ModelItem Id. -
priceModelItemIntegrationId:
string()
Title:
Price Model Item Integration IDThe integration ID of the parent Price Model Item. -
ratePlanNumber:
string()
Title:
Rate Plan NumberUnique Variable Name of the Pricing Rate Plan. -
segmentLevelAccessType:
string()
Title:
Segment-level Access TypeRead Only:trueSegment-level Access Type -
startDate:
string()
Title:
Start DateThe date from which the Pricing Rate Plan will be applicable.
Nested Schema : Charges
Title:
ChargesRead Only:
trueRate Plan charges
Match All
Rate Plan charges
Show Source
Nested Schema : Created By
Title:
Created ByRead Only:
trueThe 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 ByRead Only:
trueThe details of the user who modified the record.
Match All
The details of the user who modified the record.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksRead Only:
trueThe link relations associated with the resource instance.
Show Source
Examples
The following example shows how to retrieve all Price Model Items for the specified Price Model 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/pricingSetup/models/testPriceModel/priceModelItems
Response Body Sample
{
"items": [{
"id": 3022984798,
"partNumber": "part12",
"description": "",
"bomItemName": "Name",
"rootBomItemName": "Name",
"bomItemVariableName": "ABOSampleChild",
"rootBomItemVariableName": "ABOSampleRoot",
"dateModified": "2023-04-18T10:02:14Z",
"dateAdded": "2023-04-18T05:18:59Z"
}, {
"id": 3022985793,
"partNumber": "part12",
"description": "",
"bomItemName": "Name",
"rootBomItemName": "Name",
"bomItemVariableName": "ABOSampleChild",
"rootBomItemVariableName": "ABOSampleRoot",
"dateModified": "2023-04-18T16:12:51Z",
"dateAdded": "2023-04-18T08:40:25Z"
}
]
}