Product Search REST APIs

Overview

This REST API is used to retrieve and search for Oracle CPQ products. Products consist of both stand-alone parts and product structures (i.e. BOM hierarchies).

Administration

ClosedGet a Product

Get a ProductGET Method

Description

Use this endpoint to retrieve the specified CPQ product.

URI Endpoint

/rest/v17/products/{productId}

Endpoint Parameters

productId

The unique identifier for the product

HTTP Method

GET

Request Body Parameters

None

Response Body Parameters

bomItemVariableName

The variable name of the BOM item

description

Description of the Product

id

Resource ID

label

Product label

model

Name of the model

modelPath

The variable name of the Model Path

partNumber

Part number of the Product

productIdentifier

Uniquely identifies a Product

productType

Type of The Product

status

Workflow status of this product

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/products/PART_255


ClosedResponse Body Sample

{ "productIdentifier": "PART_255", "modelPath": null, "description": "License/Applications/Vertical ERP Applications/Oracle Other Applications/Other Applications/Tutor for Applications/Tutor General Ledger", "label": "Tutor General Ledger", "bomItemVariableName": null, "model": null, "partNumber": "255", "id": 37641510, "productType": { "displayValue": "Part", "lookupCode": "0", "links": [{ "rel": "domain", "href": "https://sitename.oracle.com/rest/v17/lookupValues?q=%7B%22lookupType%22%3A%7B%22%24eq%22%3A%22BM_CONFIG_PRODUCT_TYPE%22%7D%7D" } ] }, "status": { "displayValue": "Created", "lookupCode": "ORA_CREATED", "links": [{ "rel": "domain", "href": "https://sitename.oracle.com/rest/v17/lookupValues?q=%7B%22lookupType%22%3A%7B%22%24eq%22%3A%22BM_CONFIG_PRODUCT_SETUP_STATUS%22%7D%7D" } ] } }


ClosedGet Products

Get ProductsGET Method

Description

Use this endpoint to retrieve CPQ products, endpoint query parameters must be provided to filter results.

URI Endpoint

/rest/v17/products

Endpoint Parameters None
Query Parameters

This endpoint supports the following optional parameters: fields, limit, offset, orderby, q, and totalResults.
Refer to Manage Collections for additional information.

HTTP Method

GET

Request Body Parameters

None

Response Body Parameters

A list of Oracle CPQ products, both stand-alone parts and product structures (i.e. BOM hierarchies).

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/products?limit=5&keywords=GEN&orderby=label:DESC&q={"$and":[{"productType":{"$eq":"Part", "$options":"I"}}]}


ClosedResponse Body Sample

{ "offset": 0, "limit": 5, "count": 5, "hasMore": true, "links": [{ "rel": "canonical", "href": "https://sitename.oracle.com/rest/v17/products" }, { "rel": "next", "href": "https://sitename.oracle.com/rest/v17/products?limit=5&keywords=GEN&orderby=label%3ADESC&q=%7B%22%24and%22%3A%5B%7B%22productType%22%3A%7B%22%24eq%22%3A%22Part%22%2C%20%22%24options%22%3A%22I%22%7D%7D%5D%7D&offset=5" }, { "rel": "self", "href": "https://sitename.oracle.com/rest/v17/products?limit=5&keywords=GEN&orderby=label%3ADESC&q=%7B%22%24and%22%3A%5B%7B%22productType%22%3A%7B%22%24eq%22%3A%22Part%22%2C%20%22%24options%22%3A%22I%22%7D%7D%5D%7D&offset=0" } ], "items": [{ "productIdentifier": "PART_MFG-PLG-PROD4", "modelPath": null, "description": null, "label": "shelf life and generation parent and child", "bomItemVariableName": null, "model": null, "partNumber": "MFG-PLG-PROD4", "id": 37805108, "productType": { "displayValue": "Part", "lookupCode": "0", "links": [{ "rel": "domain", "href": "https://sitename.oracle.com/rest/v17/lookupValues?q=%7B%22lookupType%22%3A%7B%22%24eq%22%3A%22BM_CONFIG_PRODUCT_TYPE%22%7D%7D" } ] }, "status": { "displayValue": "Created", "lookupCode": "ORA_CREATED", "links": [{ "rel": "domain", "href": "https://sitename.oracle.com/rest/v17/lookupValues?q=%7B%22lookupType%22%3A%7B%22%24eq%22%3A%22BM_CONFIG_PRODUCT_SETUP_STATUS%22%7D%7D" } ] } }, { "productIdentifier": "PART_A60", "modelPath": null, "description": "License/Applications/ERP Applications/Oracle ERP Applications/Order Management/iStore/eCommerce Business Intelligence", "label": "eCommerce Business Intelligence", "bomItemVariableName": null, "model": null, "partNumber": "A60", "id": 37641084, "productType": { "displayValue": "Part", "lookupCode": "0", "links": [{ "rel": "domain", "href": "https://sitename.oracle.com/rest/v17/lookupValues?q=%7B%22lookupType%22%3A%7B%22%24eq%22%3A%22BM_CONFIG_PRODUCT_TYPE%22%7D%7D" } ] }, "status": { "displayValue": "Created", "lookupCode": "ORA_CREATED", "links": [{ "rel": "domain", "href": "https://sitename.oracle.com/rest/v17/lookupValues?q=%7B%22lookupType%22%3A%7B%22%24eq%22%3A%22BM_CONFIG_PRODUCT_SETUP_STATUS%22%7D%7D" } ] } }, { "productIdentifier": "PART_STL", "modelPath": null, "description": "License/Database Technology/Database and Collaboration/Applications and Systems Management/Application Testing/Load Testing for Web Applications Controller/e-Load Professional Option: Generic Data Parser ServerStats", "label": "e-Load Professional Option: Generic Data Parser ServerStats", "bomItemVariableName": null, "model": null, "partNumber": "STL", "id": 37649152, "productType": { "displayValue": "Part", "lookupCode": "0", "links": [{ "rel": "domain", "href": "https://sitename.oracle.com/rest/v17/lookupValues?q=%7B%22lookupType%22%3A%7B%22%24eq%22%3A%22BM_CONFIG_PRODUCT_TYPE%22%7D%7D" } ] }, "status": { "displayValue": "Created", "lookupCode": "ORA_CREATED", "links": [{ "rel": "domain", "href": "https://sitename.oracle.com/rest/v17/lookupValues?q=%7B%22lookupType%22%3A%7B%22%24eq%22%3A%22BM_CONFIG_PRODUCT_SETUP_STATUS%22%7D%7D" } ] } }, { "productIdentifier": "PART_RT00005", "modelPath": null, "description": null, "label": "Washing Detergent Powder w/bleach 117oz", "bomItemVariableName": null, "model": null, "partNumber": "RT00005", "id": 37278894, "productType": { "displayValue": "Part", "lookupCode": "0", "links": [{ "rel": "domain", "href": "https://sitename.oracle.com/rest/v17/lookupValues?q=%7B%22lookupType%22%3A%7B%22%24eq%22%3A%22BM_CONFIG_PRODUCT_TYPE%22%7D%7D" } ] }, "status": { "displayValue": "Created", "lookupCode": "ORA_CREATED", "links": [{ "rel": "domain", "href": "https://sitename.oracle.com/rest/v17/lookupValues?q=%7B%22lookupType%22%3A%7B%22%24eq%22%3A%22BM_CONFIG_PRODUCT_SETUP_STATUS%22%7D%7D" } ] } }, { "productIdentifier": "PART_MFG-PLG-PROD3", "modelPath": null, "description": null, "label": "User defined exp and generation at parent", "bomItemVariableName": null, "model": null, "partNumber": "MFG-PLG-PROD3", "id": 37805109, "productType": { "displayValue": "Part", "lookupCode": "0", "links": [{ "rel": "domain", "href": "https://sitename.oracle.com/rest/v17/lookupValues?q=%7B%22lookupType%22%3A%7B%22%24eq%22%3A%22BM_CONFIG_PRODUCT_TYPE%22%7D%7D" } ] }, "status": { "displayValue": "Created", "lookupCode": "ORA_CREATED", "links": [{ "rel": "domain", "href": "https://sitename.oracle.com/rest/v17/lookupValues?q=%7B%22lookupType%22%3A%7B%22%24eq%22%3A%22BM_CONFIG_PRODUCT_SETUP_STATUS%22%7D%7D" } ] } } ] }


ClosedSearch for Products

Search for Products POST method

Description

Use this endpoint to retrieve CPQ products using the specified search criteria.

URI Endpoint

/rest/v17/products/actions/search

Endpoint Parameters

None

HTTP Method

POST

Request Body Parameters

 

 

 

 

 

 

 

criteria

A top-level object in the payload used to specify the fields used to filter the parts or limit the number of parts returned in the response.

* Advanced query object “q” criteria is supported.

context

 

 

 

 

 

This object contains the context definition for the part search and can include:

  • pricebookVarName

  • config or commerce.

pricebookVarName

The string value that specifies the variable name of the active price book. If the site uses price books, this is required.

config

 

 

 

 

 

The Configuration data for the part search.

currencyCode

The code for the desired currency

allProducts

Attributes belonging to all products

segment

The variable name of a segment

productLine

The variable name of a Product Line

model

The variable name of the a Model

commerce

Provides the Commerce process ID to be used in the part query.

id

Current unique user-side ID. This is the internal identifier for a transaction within an Oracle CPQ site

cacheInstanceId

The cache instance ID

currencyCode

The code for the desired currency

process

The process variable name

mainDocument

The main document variable name

Response Body Parameters

Returns a list of product search results

ClosedURI Endpoint Sample

https://sitename.oracle.com/rest/v17/products/actions/search


ClosedRequest Body Sample

{ "criteria": { "totalResults": true, "limit": 3, "offset": 0, "q": "{'productType': {'$like': '%Part%'}}", "keywords": ["GEN"], "orderby": ["productType:ASC", "partNumber:DESC"] }, "context": { "pricebookVarName": "pricebook1", "commerce": { "id": "20587705" } } }


ClosedResponse Body Sample

{ "result": { "totalResults": 475, "offset": 0, "limit": 3, "count": 3, "hasMore": true, "items": [{ "productIdentifier": "PART_zREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD5555555555", "modelPath": null, "description": "zREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD5\nzREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD5\nzREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD5\nzREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD5\nProduct with Lot, Revision, Locator and Serial generation at WO issue with Supply Type of Push", "label": "Product with Lot, Revision, Locator and Serial generation at WO issue with Supply Type of Push", "bomItemVariableName": null, "model": null, "partNumber": "zREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD5555555555", "id": 37631912, "productType": { "displayValue": "Part", "lookupCode": "0" }, "status": { "displayValue": "Created", "lookupCode": "ORA_CREATED" } }, { "productIdentifier": "PART_zREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD1", "modelPath": null, "description": "zREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD1\nzREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD1\nzREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD1\nzREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD1\nzREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD1\nzREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD1\nzREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD1\nzREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD1\nzREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD1\nzREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD1\nzREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD1", "label": "Product with Lot, Revision, Locator and Serial generation at WO issue with Supply Type of Push", "bomItemVariableName": null, "model": null, "partNumber": "zREL11_BIAMFG-W-SER-LOT-REV-LOC-PROD1", "id": 37631918, "productType": { "displayValue": "Part", "lookupCode": "0" }, "status": { "displayValue": "Created", "lookupCode": "ORA_CREATED" } }, { "productIdentifier": "PART_zREL11_BIAMFG-W-SER-LOT-REV-LOC-COMP6666", "modelPath": null, "description": null, "label": "Component with Lot, Revision, Locator and Serial generation at WO issue with Supply Type of Push", "bomItemVariableName": null, "model": null, "partNumber": "zREL11_BIAMFG-W-SER-LOT-REV-LOC-COMP6666", "id": 37631911, "productType": { "displayValue": "Part", "lookupCode": "0" }, "status": { "displayValue": "Created", "lookupCode": "ORA_CREATED" } } ] } }


Related Topics

Related Topics Link IconSee Also