Pricing Matrix and Pricing Matrix Template REST APIs

Overview

These endpoints enable administration of Pricing Matrices and Pricing Matrix Templates using REST API services.

Administration

Pricing Matrices

ClosedAdd Pricing Matrix

Add Pricing Matrix POST method

Description

Use this endpoint to add a pricing matrix.

URI Endpoint

/rest/v17/pricingSetup/matrixes

Endpoint Parameters

None

HTTP Method

POST

Request Body Parameters

active

Indicates if the pricing matrix is active

allowedChargeDefinitions

The list of charge definitions that this pricing matrix will apply to

allowedUsageUOM

The usage UOM lookup code that this pricing matrix will apply to

data

An array of pricing matrix data

description

Description of the pricing matrix

name

Name of the pricing matrix

template

The name and variable name of the pricing matrix template object

templateVariableName

The variable name of the pricing matrix template

variableName

Variable name of the pricing matrix

Response Body Parameters

JSON data for the pricing matrix.

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixes


ClosedSample Request Body

{ "name": "NA Internet Data Usage Rate", "variableName": "nAInternetDataUsageRate", "templateVariableName": "internetDataTemplate", "description": "U.S. Enterprise Discount" }


ClosedSample Response Body

{ "name": "NA Internet Data Usage Rate", "variableName": "nAInternetDataUsageRate", "description": "U.S. Enterprise Discount", "active": true, "templateVariableName": "internetDataTemplate", "dateAdded": "2023-01-19T16:46:46Z", "dateModified": "2023-01-19T16:46:46Z" }


ClosedDelete Pricing Matrix

Delete Pricing MatrixDELETE method

Description

Use this endpoint to delete a pricing matrix.

URI Endpoint

/rest/v17/pricingSetup/matrixes/{pricingMatrixVariableName}

Endpoint Parameters

pricingMatrixVariableName

The variable name of the pricing matrix.

HTTP Method

DELETE

Request Body Parameters

None

Success Response

204


ClosedGet Pricing Matrices

Get Pricing Matrices GET Method

Description

Use this endpoint to retrieve all pricing matrices.

URI Endpoint

/rest/v17/pricingSetup/matrixes

Endpoint Parameters

None

(Optional) This endpoint supports the following query specifications: expand, fields, finder, limit, offset, onlyData, orderby, and totalResults.

For more information, see Manage Collections.

HTTP Method

GET

Request Body Parameters

None

Response Body Parameters

A collection of pricing matrices.

active

Indicates if the pricing matrix is active

allowedChargeDefinitions

The list of charge definitions that this pricing matrix will apply to

allowedUsageUOM

The usage UOM lookup code that this pricing matrix will apply to

createdBy

The details of the user who created the record.

data

An array of pricing matrix data

dateAdded

Creation date of the pricing matrix

dateModified

Last modified date of the pricing matrix

description

Description of the pricing matrix

lastModifiedBy

The details of the user who modified the record.

name

Name of the pricing matrix

priceModelCount

The count of pricing models linked to this pricing matrix

template

The name and variable name of the pricing matrix template object

templateVariableName

The variable name of the pricing matrix template

variableName

Variable name of the pricing matrix

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixes

ClosedSample Response Body

{ "items": [{ "name": "NA Phone Call Rate Card", "variableName": "naPhoneRateCard", "description": "", "active": true, "template": { "name": "Zoom Phone Call Template", "variableName": "zoomPhoneCallTemplate" }, "priceModelCount": 3 }, { "name": "APAC Phone Call Rate Card", "variableName": "apacPhoneRateCard", "description": "", "active": true, "template": { "name": "Zoom Phone Call Template", "variableName": "zoomPhoneCallTemplate" }, "priceModelCount": 0 }, { "name": "Enterprise Data Usage Rate Card", "variableName": "enterpriseDataUsageRateCard", "description": "", "active": true, "template": { "name": "Data Usage Rate Template", "variableName": "dataUsageRateTemplate" }, "priceModelCount": 2 } ], "offset": 0, "limit": 25, "count": 3, "totalResults": 3, "hasMore": false, "links": [{ "rel": "string", "href": "string" } ] }


ClosedGet Pricing Matrix

Get Pricing MatrixGET Method

Description

Use this endpoint to retrieve the specified pricing matrix.

URI Endpoint

/rest/v17/pricingSetup/matrixes/{pricingMatrixVariableName}

Endpoint Parameters

pricingMatrixVariableName

The variable name of the pricing matrix

(Optional) This endpoint supports the following query specifications: expand and fields.

For more information, see Manage Collections.

HTTP Method

GET

Request Body Parameters None
Response Body Parameters

active

Indicates if the pricing matrix is active

allowedChargeDefinitions

The list of charge definitions that this pricing matrix will apply to

allowedUsageUOM

The usage UOM lookup code that this pricing matrix will apply to

createdBy

The details of the user who created the record.

data

An array of pricing matrix data

dateAdded

Creation date of the pricing matrix

dateModified

Last modified date of the pricing matrix

description

Description of the pricing matrix

lastModifiedBy

The details of the user who modified the record.

name

Name of the pricing matrix

priceModelCount

The count of pricing models linked to this pricing matrix

template

The name and variable name of the pricing matrix template object

templateVariableName

The variable name of the pricing matrix template

variableName

Variable name of the pricing matrix

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixes/naPhoneRateCard?expand=data


ClosedSample Response Body

{ "name": "NA Phone Call Rate Card", "variableName": "naPhoneRateCard", "description": "", "active": true, "priceModelCount": 3, "dateAdded": "", "dateModified": "", "data": { "items": [{ "fromCountry": "US", "toCountry": "Canada", "rate": [{ "currencyCode": "USD", "value": 1.20 }, { "currencyCode": "CAD", "value": 1.35 } ] }, { "fromCountry": "US", "toCountry": "Mexico", "rate": [{ "currencyCode": "USD", "value": 1.20 }, { "currencyCode": "CAD", "value": 1.35 } ] }, "template": { "name": "test4", "variableName": "test4" } } }


ClosedGet Pricing Matrix Data

Get Pricing Matrix Data GET Method

Description

Use this endpoint to retrieve data for the specified pricing matrix.

URI Endpoint

/rest/v17/pricingSetup/matrixes/{pricingMatrixVariableName}/data

Endpoint Parameters

pricingMatrixVariableName

The variable name of the pricing matrix

(Optional) This endpoint supports the following query specifications: fields, finder, limit, offset, onlyData, orderby, and totalResults.

For more information, see Manage Collections.

HTTP Method

GET

Request Body Parameters

None

Response Body Parameters

An array of pricing matrix data items

createdBy

The details of the user who created the record.

dateAdded

Creation date of the pricing matrix data item

dateModified

Last modified date of the pricing matrix data item

id

The unique identifier of the pricing matrix data item

lastModifiedBy

The details of the user who modified the record.

...

Additional fields as specified in the associated pricing matrix template

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixes/naPhoneRateCard/data


ClosedSample Response Body


ClosedUpdate Pricing Matrix

Update Pricing Matrix PATCH method

Description

Use this endpoint to update the specified pricing matrix.

URI Endpoint

/rest/v17/pricingSetup/matrixes/{pricingMatrixVariableName}

Endpoint Parameters

pricingMatrixVariableName

The variable name of the pricing matrix.

HTTP Method

PATCH

Request Body Parameters

The array of pricing patch operations.

active

Indicates if the pricing matrix is active

allowedChargeDefinitions

The list of charge definitions that this pricing matrix will apply to

allowedUsageUOM

The usage UOM lookup code that this pricing matrix will apply to

data

An array of pricing matrix data

description

Description of the pricing matrix

name

Name of the pricing matrix

template

The name and variable name of the pricing matrix template object

templateVariableName

The variable name of the pricing matrix template

variableName

Variable name of the pricing matrix

Success Response

204

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixes/newCallRateCard


ClosedSample Request Body

{ "name": "NA Internet Data Usage Rate", "active": false, "description": "U.S. Enterprise Discount" }


ClosedUpdate Pricing Matrix Data

Update Pricing Matrix Data PATCH method

Description

Use this endpoint to add, update, or delete pricing matrix data.

URI Endpoint

/rest/v17/pricingSetup/matrixes/{pricingMatrixVariableName}/data

Endpoint Parameters

pricingMatrixVariableName

The variable name of the pricing matrix.

HTTP Method

PATCH

Request Body Parameters

The array of pricing patch operations.

op

The operation to be performed. Allowed values: "add", "remove", and "replace".

path

The JSON pointer string for "path" property.

value

The target value for the pricing matrix data items as specified in the associated pricing matrix template. Refer to Get Pricing Matrix Data

Success Response

204

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixes/naPhoneRateCard/data


ClosedSample Request Body

[{ "op": "add", "path": "/", "value": { "fromCountry": "US", "toCountry": "Canada", "itemPrice": [{ "currencyCode": "USD", "value": 0.10 }, { "currencyCode": "CAD", "value": 0.20 } ], "id": -1 } }, { "op": "add", "path": "/", "value": { "fromCountry": "US", "toCountry": "UK", "itemPrice": [{ "currencyCode": "USD", "value": 0.15 }, { "currencyCode": "CAD", "value": 0.30 } ], "id": -2 } }, { "op": "remove", "path": "/12345" }, { "op": "replace", "path": "/12346", "value": { "fromCountry": "US", "toCountry": "India", "itemPrice": [{ "currencyCode": "USD", "value": 0.10 }, { "currencyCode": "CAD", "value": 0.30 } ] } } ]


Pricing Matrix Templates

ClosedAdd Pricing Matrix Template

Add Pricing Matrix Template POST method

Description

Use this endpoint to add a pricing matrix template.

URI Endpoint

/rest/v17/pricingSetup/matrixTemplates

Endpoint Parameters

None

HTTP Method

POST

Request Body Parameters

active

Indicates if the pricing matrix is active

allowedChargeDefinitions

The list of charge definitions that this pricing matrix will apply to

columns

List of columns for the pricing matrix template.

This field is Ignored for pricing matrix templates.

description

Description of the pricing matrix

name

Name of the pricing matrix

template

The name and variable name of the pricing matrix template object

templateType

The type of this pricing matrix template.

Allowed Values:"rateCard", "attributeBasedCharge", "scriptingPriceModel"

variableName

Variable name of the pricing matrix template

Response Body Parameters

JSON data for the newly added pricing matrix template.

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixTemplates


ClosedSample Request Body

{ "name": "testMatrixABC1", "variableName": "testMatrixABC1", "templateType": "attributeBasedCharge", "description": "ABC matrix 1" }


ClosedSample Response Body

{ "name": "testMatrixABC1", "variableName": "testMatrixABC1", "active": true, "description": "ABC matrix 1", "dateAdded": "2023-11-21T23:00:39Z", "dateModified": "2023-11-21T23:00:39Z", "templateType": "attributeBasedCharge" }


ClosedAdd Pricing Matrix Template Column

Add Pricing Matrix Template Column POST method

Description

Use this endpoint to add a column to the specified pricing matrix template.

URI Endpoint

/rest/v17/pricingSetup/matrixTemplates/{templateVariableName}/columns

Endpoint Parameters

templateVariableName

The variable name of the pricing matrix template

HTTP Method

POST

Request Body Parameters

active

Indicates if the pricing matrix template is active

dataType

Data type of the pricing matrix template column.

Allowed Values: "Boolean", "Currency", "String", "Decimal", "Date", or "Integer"

defaultOverridable

Indicates if the default value is overridable

defaultValue

Default value of the pricing matrix template column

description

Description of the pricing matrix template column

id

The unique identifier of the pricing matrix template column

integrationId

Identifier for the corresponding entity in Fusion Pricing.

ioType

The Input/Output type of the pricing matrix column.

Allowed Values: "input" or "output"

key

Indicates if the pricing matrix template column is a key

lookupType

Lookup type of the pricing matrix template column

lookupTypeLabel

The lookup type display label of the pricing matrix template column

name

Name of the pricing matrix template column.

negotiable

Indicates if the value stores in this pricing matrix template column is negotiable

operator

The operator to be applied on this pricing matrix column.

Allowed Values: "none", "<", "<=", "Not =", "=", ">", ">=", "Contains", "Not Contains", "Starts With", "Not Starts With", "Ends With", or "Not Ends With"

orderNumber

The sequence number of the column in the template

pricingAttribute

The pricing attribute referenced to for this pricing matrix column

required

Indicates if the value of this pricing matrix template column is required

templateType

The type of this pricing matrix template.

Allowed Values: "rateCard", "attributeBasedCharge", "scriptingPriceModel"

variableName

Variable name of the pricing matrix template column

wildCardSupported

Indicates if this column supports wild card values

Response Body Parameters

JSON data for the newly added pricing matrix template column.

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixTemplates/testMatrixTemp1/columns


ClosedSample Request Body

{ "name": "To Country", "variableName": "toCountry", "dataType": "String", "defaultOverridable": false, "description": "To country.", "active": true, "negotiable": false, "required": false, "ioType": "input", "lookupType": "custom1_c", "pricingAttribute": "pricingEngineMainString", "operator": "=" }


ClosedSample Response Body

{ "id": 3023092501, "name": "To Country", "variableName": "toCountry", "key": false, "dataType": "String", "lookupType": "custom1_c", "defaultOverridable": false, "description": "To country.", "active": true, "negotiable": false, "required": false, "dateAdded": "2023-11-27T15:30:25Z", "dateModified": "2023-11-27T15:30:25Z", "ioType": "input", "operator": "=", "pricingAttribute": "pricingEngineMainString" }


ClosedDelete Pricing Matrix Template

Delete Pricing Matrix TemplateDELETE method

Description

Use this endpoint to delete the specified pricing matrix template.

URI Endpoint

/rest/v17/pricingSetup/matrixTemplates/{templateVariableName}

Endpoint Parameters

templateVariableName

The variable name of the pricing matrix template

HTTP Method

DELETE

Request Body Parameters

None

Success Response

204


ClosedDelete Pricing Matrix Template Column

Delete Pricing Matrix Template ColumnDELETE method

Description

Use this endpoint to delete a pricing matrix template column.

URI Endpoint

/rest/v17/pricingSetup/matrixTemplates/{templateVariableName}/columns/{id}}

Endpoint Parameters

templateVariableName

The variable name of the pricing matrix template

id

The unique identifier of the pricing matrix template column

HTTP Method

DELETE

Request Body Parameters

None

Success Response

204


ClosedGet Pricing Matrix Templates

Get Pricing Matrix Templates GET Method

Description

Use this endpoint to retrieve all pricing matrix templates.

URI Endpoint

/rest/v17/pricingSetup/matrixTemplates

Endpoint Parameters

None

(Optional) This endpoint supports the following query specifications: expand, fields, finder, limit, offset, onlyData, orderby, and totalResults.

For more information, see Manage Collections.

HTTP Method

GET

Request Body Parameters

None

Response Body Parameters

A collection of pricing matrix template items

active

Indicates if the pricing matrix is active

allowedChargeDefinitions

The list of charge definitions that this pricing matrix will apply to

columns

List of columns for the pricing matrix template.

This field is Ignored for pricing matrix templates.

createdBy

The details of the user who created the record.

dateAdded

Creation date of the pricing matrix

dateModified

Last modified date of the pricing matrix

description

Description of the pricing matrix

lastModifiedBy

The details of the user who modified the record.

name

Name of the pricing matrix

pricingMatrixCount

The count of pricing matrices linked to this template

rateCardCount

The count of pricing matrices linked to this template

template

The name and variable name of the pricing matrix template object

templateType

The type of this pricing matrix template.

Allowed Values: "rateCard", "attributeBasedCharge", "scriptingPriceModel"

variableName

Variable name of the pricing matrix template

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixTemplates


ClosedSample Response Body

{ "items": [{ "name": "t1", "variableName": "t1", "active": true, "description": "", "rateCardCount": 1, "pricingMatrixCount": 1, "dateAdded": "2023-11-08T05:42:17Z", "dateModified": "2023-11-08T05:42:17Z", "templateType": "rateCard" }, { "name": "testMatrixTemp1", "variableName": "testMatrixTemp1", "active": true, "description": "testMatrixTemp1", "pricingMatrixCount": 0, "dateAdded": "2023-11-08T06:01:08Z", "dateModified": "2023-11-08T06:01:08Z", "templateType": "attributeBasedCharge" } ], "offset": 0, "limit": 1000, "count": 2, "hasMore": false }


ClosedGet Pricing Matrix Template

Get Pricing Matrix TemplateGET Method

Description

Use this endpoint to retrieve the specified pricing matrix template.

URI Endpoint

/rest/v17/pricingSetup/matrixTemplates/{templateVariableName}

Endpoint Parameters

templateVariableName

The variable name of the pricing matrix template.

(Optional) This endpoint supports the following query specifications: expand and fields.

For more information, see Manage Collections.

HTTP Method

GET

Request Body Parameters None
Response Body Parameters

active

Indicates if the pricing matrix is active

allowedChargeDefinitions

The list of charge definitions that this pricing matrix will apply to

columns

List of columns for the pricing matrix template.

This field is Ignored for pricing matrix templates.

createdBy

The details of the user who created the record.

dateAdded

Creation date of the pricing matrix

dateModified

Last modified date of the pricing matrix

description

Description of the pricing matrix

lastModifiedBy

The details of the user who modified the record.

name

Name of the pricing matrix

pricingMatrixCount

The count of pricing matrices linked to this template

rateCardCount

The count of pricing matrices linked to this template

template

The name and variable name of the pricing matrix template object

templateType

The type of this pricing matrix template.

Allowed Values: "rateCard" or "attributeBasedCharge"

variableName

Variable name of the pricing matrix template

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixTemplates/testMatrixTemp1


ClosedSample Response Body

{ "name": "testMatrixTemp1", "variableName": "testMatrixTemp1", "active": true, "description": "testMatrixTemp1", "pricingMatrixCount": 0, "dateAdded": "2023-11-08T06:01:08Z", "dateModified": "2023-11-08T06:01:08Z", "templateType": "attributeBasedCharge" }


ClosedGet Pricing Matrix Template Columns

Get Pricing Matrix Template ColumnsGET Method

Description

Use this endpoint to retrieve all columns for the specified pricing matrix template.

URI Endpoint

/rest/v17/pricingSetup/matrixTemplates/{templateVariableName}/columns

Endpoint Parameters

templateVariableName

The variable name of the pricing matrix template

(Optional) This endpoint supports the following query specifications: fields, finder, limit, offset, onlyData, orderby, and totalResults.

For more information, see Manage Collections.

HTTP Method

GET

Request Body Parameters

None

Response Body Parameters

A collection of pricing matrix template column items.

active

Indicates if the pricing matrix template is active

createdBy

The details of the user who created the record.

dataType

Data type of the pricing matrix template column.

Allowed Values: "Boolean", "Currency", "String", "Decimal", "Date", or "Integer"

dateAdded

Creation date of the pricing matrix template column

dateModified

Last modified date of the pricing matrix template column

defaultOverridable

Indicates if the default value is overridable

defaultValue

Default value of the pricing matrix template column

description

Description of the pricing matrix template column

id

The unique identifier of the pricing matrix template column

integrationId

Identifier for the corresponding entity in Fusion Pricing.

ioType

The Input/Output type of the pricing matrix column.

Allowed Values: "input" or "output"

key

Indicates if the pricing matrix template column is a key

lastModifiedBy

The details of the user who modified the record.

lookupType

Lookup type of the pricing matrix template column

lookupTypeLabel

The lookup type display label of the pricing matrix template column

name

Name of the pricing matrix template column.

negotiable

Indicates if the value stores in this pricing matrix template column is negotiable

operator

The operator to be applied on this pricing matrix column.

Allowed Values: "none", "<", "<=", "Not =", "=", ">", ">=", "Contains", "Not Contains", "Starts With", "Not Starts With", "Ends With", or "Not Ends With"

orderNumber

The sequence number of the column in the template

pricingAttribute

The pricing attribute referenced to for this pricing matrix column

required

Indicates if the value of this pricing matrix template column is required

templateType

The type of this pricing matrix template.

Allowed Values: "rateCard" or "attributeBasedCharge"

variableName

Variable name of the pricing matrix template column

wildCardSupported

Indicates if this column supports wild card values

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixTemplates/testMatrixTemp1/columns


ClosedSample Response Body

{ "items": [{ "id": 3023105055, "orderNumber": 1, "name": "Item Price", "variableName": "itemPrice", "key": false, "dataType": "Currency", "defaultOverridable": true, "description": "The item price.", "active": true, "negotiable": true, "required": false, "dateAdded": "2023-11-08T06:01:09Z", "dateModified": "2023-11-08T06:01:09Z", "ioType": "output", "operator": "none", "wildCardSupported": false } ], "offset": 0, "limit": 1000, "count": 1, "hasMore": false }


ClosedGet Pricing Matrix Template Column

Get Pricing Matrix Template ColumnGET Method

Description

Use this endpoint to retrieve a pricing matrix template column.

URI Endpoint

/rest/v17/pricingSetup/matrixTemplates/{templateVariableName}/columns/{id}

Endpoint Parameters

templateVariableName

The variable name of the pricing matrix template.

id

The unique identifier of the pricing matrix template column.

(Optional) This endpoint supports the following query specifications: expand and fields.

For more information, see Manage Collections.

HTTP Method

GET

Request Body Parameters None
Response Body Parameters

active

Indicates if the pricing matrix template is active

createdBy

The details of the user who created the record.

dataType

Data type of the pricing matrix template column.

Allowed Values: "Boolean", "Currency", "String", "Decimal", "Date", or "Integer"

dateAdded

Creation date of the pricing matrix template column

dateModified

Last modified date of the pricing matrix template column

defaultOverridable

Indicates if the default value is overridable

defaultValue

Default value of the pricing matrix template column

description

Description of the pricing matrix template column

id

The unique identifier of the pricing matrix template column

integrationId

Identifier for the corresponding entity in Fusion Pricing.

ioType

The Input/Output type of the pricing matrix column.

Allowed Values: "input" or "output"

key

Indicates if the pricing matrix template column is a key

lastModifiedBy

The details of the user who modified the record.

lookupType

Lookup type of the pricing matrix template column

lookupTypeLabel

The lookup type display label of the pricing matrix template column

name

Name of the pricing matrix template column.

negotiable

Indicates if the value stores in this pricing matrix template column is negotiable

operator

The operator to be applied on this pricing matrix column.

Allowed Values: "none", "<", "<=", "Not =", "=", ">", ">=", "Contains", "Not Contains", "Starts With", "Not Starts With", "Ends With", or "Not Ends With"

orderNumber

The sequence number of the column in the template

pricingAttribute

The pricing attribute referenced to for this pricing matrix column

required

Indicates if the value of this pricing matrix template column is required

templateType

The type of this pricing matrix template.

Allowed Values: "rateCard" or "attributeBasedCharge"

variableName

Variable name of the pricing matrix template column

wildCardSupported

Indicates if this column supports wild card values

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixTemplates/testMatrixTemp1/columns/3023112345


ClosedSample Response Body

{ "id": 3023112345, "orderNumber": 1, "name": "Item Price", "variableName": "itemPrice", "key": false, "dataType": "Currency", "defaultOverridable": false, "description": "The item price.", "active": true, "negotiable": true, "required": false, "dateAdded": "2023-11-15T19:13:04Z", "dateModified": "2023-11-15T19:13:04Z", "ioType": "output", "operator": "none", "wildCardSupported": false }


ClosedUpdate Pricing Matrix Template

Update Pricing Matrix Template PATCH method

Description

Use this endpoint to update the specified pricing matrix template.

URI Endpoint

/rest/v17/pricingSetup/matrixTemplates/{templateVariableName}

Endpoint Parameters

templateVariableName

The variable name of the pricing matrix template

HTTP Method

PATCH

Request Body Parameters

active

Indicates if the pricing matrix is active

allowedChargeDefinitions

The list of charge definitions that this pricing matrix will apply to

columns

List of columns for the pricing matrix template.

This field is Ignored for pricing matrix templates.

description

Description of the pricing matrix

name

Name of the pricing matrix

template

The name and variable name of the pricing matrix template object

templateType

The type of this pricing matrix template.

Allowed Values: "rateCard" or "attributeBasedCharge"

variableName

Variable name of the pricing matrix template

Success Response

204

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixTemplates/testMatrixTemp1


ClosedSample Request Body

{ "active": false }


ClosedUpdate Pricing Matrix Template Columns

Update Pricing Matrix Template Columns PATCH method

Description

Use this endpoint to update columns for the specified pricing matrix template.

URI Endpoint

/rest/v17/pricingSetup/matrixTemplates/{templateVariableName}/columns

Endpoint Parameters

templateVariableName

The variable name of the pricing matrix template

HTTP Method

PATCH

Request Body Parameters

The array of pricing patch operations.

op

The operation to be performed. Allowed values: "add", "remove", and "replace".

path

The JSON pointer string for "path" property.

value

The target value. Refer to Update Pricing Matrix Template Column for more information.

Success Response

204

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixTemplates/testMatrixTemp1/columns


ClosedSample Request Body

[{ "op": "add", "path": "/", "value": { "orderNumber": 2, "name": "Post Code", "variableName": "postCode", "dataType": "String", "description": "The post code.", "active": true } }, { "op": "replace", "path": "/toCountry", "value": { "name": "Price", "description": "The To country.", "active": true } } ]


ClosedUpdate Pricing Matrix Template Column

Update Pricing Matrix Template Column PATCH method

Description

Use this endpoint to update the specified pricing matrix template column.

URI Endpoint

/rest/v17/pricingSetup/matrixTemplates/{templateVariableName}/columns/{id}

Endpoint Parameters

templateVariableName

The variable name of the pricing matrix template.

id

The unique identifier of the pricing matrix template column.

HTTP Method

PATCH

Request Body Parameters

active

Indicates if the pricing matrix template is active

dataType

Data type of the pricing matrix template column.

Allowed Values: "Boolean", "Currency", "String", "Decimal", "Date", or "Integer"

defaultOverridable

Indicates if the default value is overridable

defaultValue

Default value of the pricing matrix template column

description

Description of the pricing matrix template column

id

The unique identifier of the pricing matrix template column

integrationId

Identifier for the corresponding entity in Fusion Pricing.

ioType

The Input/Output type of the pricing matrix column.

Allowed Values: "input" or "output"

key

Indicates if the pricing matrix template column is a key

lookupType

Lookup type of the pricing matrix template column

lookupTypeLabel

The lookup type display label of the pricing matrix template column

name

Name of the pricing matrix template column.

negotiable

Indicates if the value stores in this pricing matrix template column is negotiable

operator

The operator to be applied on this pricing matrix column.

Allowed Values: "none", "<", "<=", "Not =", "=", ">", ">=", "Contains", "Not Contains", "Starts With", "Not Starts With", "Ends With", or "Not Ends With"

orderNumber

The sequence number of the column in the template

pricingAttribute

The pricing attribute referenced to for this pricing matrix column

required

Indicates if the value of this pricing matrix template column is required

templateType

The type of this pricing matrix template.

Allowed Values: "rateCard" or "attributeBasedCharge"

variableName

Variable name of the pricing matrix template column

wildCardSupported

Indicates if this column supports wild card values

Success Response

204

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixTemplates/testMatrixTemp1/columns/36991124


ClosedSample Request Body

{ "active": false }


Pricing Matrix & Pricing Matrix Template Translations

ClosedGet Pricing Matrix Translations

Get Pricing Matrix Translations GET Method

Description

Use this endpoint to retrieve translations for the specified pricing matrix.

URI Endpoint

/rest/v17/pricingSetup/matrixes/{pricingMatrixVariableName}/translations

Endpoint Parameters

pricingMatrixVariableName

The variable name of the pricing matrix.

(Optional) This endpoint supports the fields query specification.

For more information, see Manage Collections.

HTTP Method

GET

Request Body Parameters

None

Response Body Parameters

A collection of translations for the specified pricing matrix. See Get pricing matrix Translation for detailed response body parameters.

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixes/naPhoneRateCard/translations


ClosedSample Response Body

{ "items": [{ "languageCode": "en", "languageLabel": "English", "name": "NA Phone Call Rate Card", "description": "This is some sample text" }, { .... } ] }


ClosedGet Pricing Matrix Translation

Get Pricing Matrix Translation GET Method

Description

Use this endpoint to retrieve the specified language translation for a pricing matrix.

URI Endpoint

/rest/v17/pricingSetup/matrixes/{pricingMatrixVariableName}/translations/{languageCode}

Endpoint Parameters

pricingMatrixVariableName

The variable name of the pricing matrix.

(Optional) This endpoint supports the following query specifications: expand, fields, finder, limit, offset, onlyData, orderby, and totalResults.

For more information, see Manage Collections.

HTTP Method

GET

Request Body Parameters

None

Response Body Parameters

description

Display description of pricing matrix template column.

languageCode

Language code.

languageLabel

Display language label in the given language code.

name

Display name of pricing matrix template column.

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixes/naPhoneRateCard/translations/en


ClosedSample Response Body

{ "languageCode": "en", "languageLabel": "English", "name": "NA Phone Call Rate Card", "description": "This is some sample text" }


ClosedGet Pricing Matrix Template Translations

Get Pricing Matrix Template Translations GET Method

Description

Use this endpoint to retrieve translations for the specified pricing matrix template.

URI Endpoint

/rest/v17/pricingSetup/matrixTemplates/{templateVariableName}/translations

Endpoint Parameters

templateVariableName

The variable name of the pricing matrix template

(Optional) This endpoint supports the fields query specification.

For more information, see Manage Collections.

HTTP Method

GET

Request Body Parameters

None

Response Body Parameters

An array of pricing matrix template translations

description

Display description of pricing matrix template column

languageCode

Language code

languageLabel

Display language label in the given language code

name

Display name of pricing matrix template column

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixTemplates/zoomPhoneCallTemplate/translations


ClosedSample Response Body

{ "items": [{ "languageCode": "en", "languageLabel": "English", "name": "Zoom Phone Call Template", "description": "This is some sample text" }, { "languageCode": "de", "languageLabel": "German", "name": "Vorlage fur Zoom-Telefonanrufe", "description": "Dies ist ein Beispieltext" }, { "languageCode": "fr", "languageLabel": "French", "name": "Modele d'appel telephonique Zoom", "description": "Ceci est un exemple de texte" } ] }


ClosedGet Pricing Matrix Template Translation

Get Pricing Matrix Template TranslationGET Method

Description

Use this endpoint to retrieve the specified language translation for a pricing matrix template.

URI Endpoint

/rest/v17/pricingSetup/matrixTemplates/{templateVariableName}/translations/{languageCode}

Endpoint Parameters

templateVariableName

The variable name of the pricing matrix template

languageCode

The language code

(Optional) This endpoint supports the following query specifications: expand and fields.

For more information, see Manage Collections.

HTTP Method

GET

Request Body Parameters None
Response Body Parameters

description

Display description of pricing matrix template column

languageCode

Language code

languageLabel

Display language label in the given language code

name

Display name of pricing matrix template column

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixTemplates/zoomPhoneCallTemplate/translations/fr


ClosedSample Response Body

{ "languageCode": "fr", "languageLabel": "French", "name": "Modele d'appel telephonique Zoom", "description": "Ceci est un exemple de texte" }


ClosedGet Pricing Matrix Template Column Translations

Get Pricing Matrix Template Column Translations GET Method

Description

Use this endpoint to retrieve translations for the specified pricing matrix template column.

URI Endpoint

/rest/v17/pricingSetup/matrixTemplates/{templateVariableName}/columns/{id}/translations

Endpoint Parameters

templateVariableName

The variable name of the pricing matrix template.

id

The unique identifier of the pricing matrix template column.

(Optional) This endpoint supports the fields query specification.

For more information, see Manage Collections.

HTTP Method

GET

Request Body Parameters

None

Response Body Parameters

A collection of pricing matrix template column translations. See Get pricing matrix template Column Translation for detailed response body parameters.

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixTemplates/testMatrixTemp1/columns/36991124


ClosedSample Response Body

{ "items": [{ "languageCode": "en", "languageLabel": "English", "name": "From Country", "description": "..." }, { "languageCode": "fr", "languageLabel": "French", "name": "Du pays", "description": "..." }, { .... } ] }


ClosedGet Pricing Matrix Template Column Translation

Get Pricing Matrix Template Column TranslationGET Method

Description

Use this endpoint to retrieve the specified language translation for a pricing matrix template column.

URI Endpoint

/rest/v17/pricingSetup/matrixTemplates/{templateVariableName}/columns/{id}/translations /{languageCode}

Endpoint Parameters

templateVariableName

The variable name of the pricing matrix template.

id

The unique identifier of the pricing matrix template column.

languageCode

The language code.

(Optional) This endpoint supports the following query specifications: expand and fields.

For more information, see Manage Collections.

HTTP Method

GET

Request Body Parameters None
Response Body Parameters

description

Display description of pricing matrix template column.

languageCode

Language code.

languageLabel

Display language label in the given language code.

name

Display name of pricing matrix template column.

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixTemplates/dataUsagePricingMatrixTemplate/columns/36991124/de


ClosedSample Response Body

{ "languageCode": "de", "languageLabel": "German", "name": "Vom Land", "description": "" }


ClosedUpdate Pricing Matrix Translations

Update Pricing Matrix TranslationsPUT method

Description

Use this endpoint to update pricing matrix translations.

URI Endpoint

/rest/v17/pricingSetup/matrixes/{pricingMatrixVariableName}/translations

Endpoint Parameters

pricingMatrixVariableName

The variable name of the pricing matrix

HTTP Method

PUT

Response Body Parameters An array of pricing matrix translations

description

Display description of the pricing matrix item

languageCode

Language code

languageLabel

Display language label in the given language code

name

Display name of pricing matrix item

Response Body Status

204 No Content

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixes/fromCountry


ClosedRequest Body Sample

[{ "languageCode": "en", "name": "From Country", "description": "...." }, { "languageCode": "de", "name": "Vom Land", "description": "...." }, ..... ]


ClosedUpdate Pricing Matrix Template Translations

Update Pricing Matrix Template TranslationsPUT method

Description

Use this endpoint to update pricing matrix template translations.

URI Endpoint

/rest/v17/pricingSetup/matrixTemplates/{templateVariableName}/translations

Endpoint Parameters

templateVariableName

The variable name of the pricing matrix template

HTTP Method

PUT

Response Body Parameters An array of pricing matrix template translations

description

Display description of pricing matrix template column

languageCode

Language code

languageLabel

Display language label in the given language code

name

Display name of pricing matrix template column

Response Body Status

204 No Content

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixTemplates/testMatrixTemp1/translations


ClosedRequest Body Sample

[{ "languageCode": "en", "name": "From Country", "description": "...." }, { "languageCode": "de", "name": "Vom Land", "description": "...." }, ..... ]


ClosedUpdate Pricing Matrix Template Column Translations

Update Pricing Matrix Template Column TranslationsPUT method

Description

Use this endpoint to update pricing matrix template column translations.

URI Endpoint

/rest/v17/pricingSetup/matrixTemplates/{templateVariableName}/columns/{id}/translations

Endpoint Parameters

templateVariableName

The variable name of the pricing matrix template

id

The unique identifier of the pricing matrix template column

HTTP Method

PUT

Request Body Parameters An array of pricing matrix template column translations

description

Display description of pricing matrix template column

languageCode

Language code

languageLabel

Display language label in the given language code

name

Display name of pricing matrix template column

Response Body Status

204 No Content

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/pricingSetup/matrixTemplates/testMatrixTemp1/columns/3023092501/translations


ClosedRequest Body Sample

[{ "languageCode": "en", "name": "From Country", "description": "...." }, { "languageCode": "de", "name": "Vom Land", "description": "...." }, ..... ]


 

Related Topics

Related Topics Link IconSee Also