Get Price Agreement Pricing Matrix Grid Data
/rest/v19/pricingSetup/agreements/{agreementVariableName}/matrixGrid
Request
-
chargeq: string
Filter charges (a "where"clause) to restrict the items returned in the collection. The chargeq filtering is applied jointly ("AND") with the q parameter search. You can filter by searchable price model item columns and charge columns, for example, partNumber, bomItemVariableName, chargeType, priceType, and searchable custom charge attributes. You can't search by join fields like description, slaesProductType, ratePlanName or currency custom charge attributes. By default, no filtering is applied.
-
distinct: boolean
The items returned in the resource collection will have distinct field values when "?distinct=true".
-
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:- findByGridKeyword: Find matrix grid rows using pricing matrix fields, part number, BOM item name or variable name, Root BOM item name or 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
- findByGridKeyword: Find matrix grid rows using pricing matrix fields, part number, BOM item name or variable name, Root BOM item name or 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 matrix data (a "where"clause) to restrict the items returned in the collection. You can search by matrix data columns, for example, dateAdded, dateModified, and searchable matrix template columns. You can't search by createdBy, modifiedBy or currency matrix columns. Prefix "matrix" to the matrix template column variable name. For example, use "_matrix_region" for the matrix template column "region". 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
- application/json
200 Response
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.
Created BytrueLast Modified BytruearrayLinkstrueobject-
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
object-
_proxy_id:
integer()
Title:
Proxy IDRead Only:trueThe proxy identifier for the resource that was added. -
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. -
chargeDateAdded:
string(yyyy-MM-dd'T'HH:mm:ss.SSS'Z')
Title:
Charge Date AddedThe date from which the Charge is created. -
chargeDateModified:
string(yyyy-MM-dd'T'HH:mm:ss.SSS'Z')
Title:
Charge Date ModifiedThe date from which the Charge is modified. -
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 IDID of the Charge Definition. -
chargeEndDate:
string(yyyy-MM-dd'T'HH:mm:ss.SSS'Z')
Title:
Charge End DateThe date at which the Charge will end. -
chargeId:
integer()
Title:
Charge IDID of the Charge. -
chargeStartDate:
string(yyyy-MM-dd'T'HH:mm:ss.SSS'Z')
Title:
Charge Start DateThe date from which the Charge will be applicable. -
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 of the Pricing Matrix data. -
dateModified:
string(yyyy-MM-dd'T'HH:mm:ss.SSS'Z')
Title:
Date ModifiedRead Only:trueLast Modified date of the Pricing Matrix data. -
description:
string()
Title:
DescriptionThe description of the Price Model Data -
dynamicPricingType:
string()
Title:
Dynamic Pricing TypeAllowed Values:[ "static", "advanced", "volume", "tiered", "rateCard", "attributeBasedCharge" ]The dynamic pricing type of the charge. -
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 Pricing Matrix data. -
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 Data.This should match the Part Lookup's lookupCode. -
priceModelItemId:
integer()
Title:
Price Model Item IDID of the Price Model item. -
pricePeriod:
string()
Title:
Price PeriodThe billing period. -
priceType:
string()
Title:
Price TypeThe type of charge. -
primaryCharge:
boolean()
Title:
Primary ChargeIndicates whether this is the primary charge. -
ratePlanDescription:
string()
Title:
Rate Plan DescriptionRate Plan description. -
ratePlanEndDate:
string(yyyy-MM-dd'T'HH:mm:ss.SSS'Z')
Title:
Rate Plan End DateThe date at which the Rate Plan will end. -
ratePlanName:
string()
Title:
Rate Plan NameRate Plan name. -
ratePlanNumber:
string()
Title:
Rate Plan NumberRate Plan Number. -
ratePlanStartDate:
string(yyyy-MM-dd'T'HH:mm:ss.SSS'Z')
Title:
Rate Plan Start DateThe date from which the Rate Plan will be applicable. -
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 TypeSales Product type. -
segmentLevelAccessType:
string()
Title:
Segment-level Access TypeRead Only:trueSegment-level Access Type -
serviceDuration:
integer()
Title:
Service DurationService duration. -
serviceDurationPeriod:
string()
Title:
Service Duration PeriodService duration period code. -
serviceDurationType:
string()
Title:
Service Duration TypeService duration type. -
usageUOM:
string()
Title:
Usage UOMThe unit of measure for the charge.
Created BytrueLast Modified BytruearrayLinkstrueExamples
q and chargeq query parameters support to the following resources. The query expression should follow the MongoDB syntax.
- Supported comparison operators: $eq, $ne, $gt, $gte, $lt, $lte, $exists, $like, $in
- Supported logical operators: $and, $or
- When using the "%" wildcard with the $like operator, the wildcard must be encoded as "%25"
q Parameter Support
Supported Query Fields
- partNumber, bomItemVariableName, rootBomItemVariableName, chargeType, priceType, pricePeriod, primaryCharge, dynamicPricingType
- System fields, like chargeDateAdded, chargeDateModified
Not Supported Query Fields
- Inactive charge attribute and the charge attributes
- Currency data type attributes
- Parameters with joined fields, like createdBy, lastModifiedBy, description, salesProductType, bomItemName, rootBomItemName, serviceDurationType, ratePlanName, etc.
- The $like operator is not supported for "dynamicPricingType"
Examples
q={dateAdded: { $lte: "2025-02-01"}}q={dateModified: { $gte: "2025-02-01"}}q={_matrix_inputDateCol: { $eq: "2025-02-01"}}q={_matrix_inputBooleanCol: true}q={_matrix_inputBooleanCol: {$eq: true}}q={_matrix_inputDecimalCol: 1.5}q={_matrix_inputStringCol: { $in: ['test1', 'test3'] }, _matrix_outputStringCol: { $in: ['test2'] }}q={$and: [{_matrix_inputIntegerCol: {$lt: 100}}, {_matrix_outputIntegerCol: {$exists: true}}]}q={$or: [{_matrix_inputBooleanCol: {$eq: true}}, {_matrix_outputBooleanCol: {$eq: false}}]}q={_matrix_inputStringCol: {$like: "%25test%25"}}q={_matrix_inputStringCol: {$like: "test%25"}}q={_matrix_inputStringCol: {$like:"test%25", $options: "I"}}q={_matrix_inputStringCol: {$like: "%25test"}}q={_matrix_inputStringCol: {$like: "test"}}
chargeq Parameter Support
Supported Query Fields
- partNumber, bomItemVariableName, rootBomItemVariableName, chargeType, priceType, pricePeriod, primaryCharge, dynamicPricingType
- System fields, like chargeDateAdded, chargeDateModified
Not Supported Query Fields
- Inactive charge attribute and the charge attributes
- Currency data type attributes
- Parameters with joined fields, like createdBy, lastModifiedBy, description, salesProductType, bomItemName, rootBomItemName, serviceDurationType, ratePlanName, etc.
- The $like operator is not supported for "dynamicPricingType"
Examples
chargeq={partNumber: 'part1'}chargeq={bomItemVariableName: {'$in': ['defLineItemPart12', 'test123']}}chargeq={priceType: 'Recurring', chargeType: 'ORA_SALE'chargeq={primaryCharge: true}chargeq={dynamicPricingType: 'attributeBasedCharge'}chargeq={myStringCharge_c: "charge1"}chargeq={myBooleanCharge_c: true}chargeq={chargeDateModified: { $gte: "2025-02-01"}}chargeq={partNumber: 'part12', chargeDateAdded: { $gte: '2025-03-05'}}q={_matrix_inputBooleanCol: true}&chargeq={priceType: 'Recurring', chargeType: 'ORA_SALE'}
Note: When use q and chargeq together, we will use the logical operator '&' between the two filters
Endpoint Sample
The following example shows how to retrive all pricing matrix grid data by submitting a GET request to the REST resource using cURL. For more information about cURL, see Use cURL.
The matrix data input and output fields will be prefixed by the 'matrix' string in the response to distinguish from other charge or reference fields with the same name.
curl - X GET -H "Authorization: Bearer <token>" - H "Content-type: application/json" https://sitename.oracle.com/rest/v19/pricingSetup/agreements/mbpAgreement/matrixGrid
Response Body Sample
{
"items": [{
"id": 452345,
"partNumber": "part10",
"description": "Part 10",
"bomItemVariableName": "child",
"rootBomItemVariableName": "parent",
"bomItemName": "Child",
"rootBomItemName": "Parent",
"serviceDuration": 1,
"serviceDurationPeriod": "months",
"chargeType": "salesPrice",
"priceType": "oneTime",
"ratePlanName": "myRatePlan",
"ratePlanNumber": "RP10234",
"dynamicPricingType": "attributeBasedCharge",
"chargeDefinitionCode": "ONE_TIME_SALES_PRICE",
"chargeStartDate": "2024-11-08T00:0:00Z",
"chargeEndDate": "2025-10-07T23:59:59Z",
"dateAdded": "2023-11-08T05:42:17Z",
"dateModified": "2023-11-08T05:42:17Z",
"str1_c": "test",
"int1_c": 11,
"_matrix_str1": "testMatrix1",
"_matrix_int1": 102,
"_matrix_itemPrice": {
"currency": "USD",
"value": 20
}
}, {
"id": 452346,
"partNumber": "part10",
"description": "Part 10",
"bomItemVariableName": "child",
"rootBomItemVariableName": "parent",
"bomItemName": "Child",
"rootBomItemName": "Parent",
"serviceDuration": 1,
"serviceDurationPeriod": "months",
"chargeType": "salesPrice",
"priceType": "oneTime",
"ratePlanName": "myRatePlan",
"ratePlanNumber": "RP10234",
"dynamicPricingType": "attributeBasedCharge",
"chargeDefinitionCode": "ONE_TIME_SALES_PRICE",
"chargeStartDate": "2024-11-08T00:0:00Z",
"chargeEndDate": "2025-10-07T23:59:59Z",
"dateAdded": "2023-11-08T05:42:17Z",
"dateModified": "2023-11-08T05:42:17Z",
"str1_c": "test",
"int1_c": 11,
"_matrix_str1": "testMatrix2",
"_matrix_int1": 103,
"_matrix_itemPrice": {
"currency": "USD",
"value": 22
}
}
],
"offset": 0,
"limit": 1000,
"count": 2,
"hasMore": false
}