How can I enable filtering of Price Books in Oracle Sales in the Redwood User Experience?

Price Books aren't enabled for Adaptive Search, the search technology used by Oracle Sales in the Redwood User Experience. However, you can use the Price Book REST API to search and filter using multiple terms. For example, a company that manages multiple price books organized in brands and sales groups can use this method to search for price books by brand and by sales group.

To access the REST URL for price books follow this pattern: https://fa-<podname>-saasfaprod1.fa.ocs.oraclecloud.com/crmRestApi/resources/latest/priceBookHeaders?q=<custom field name>_c=<bindVal>.

Here's the code to add to the API call headers:


REST-Framework-Version as 9

Payload to use -
getQueryStatus() {
  let retQuery = [
  {
  "type": "qbe",
  "provider": "adfRest",
  "q": "StatusCode='ACTIVE'"
  },
  {
  "type": "search",
  "provider": "adfRest",
  "params": [
  {
  "key": "<custom field name>_c",
  "operator": "contains"
  }
  ]
  }
  ];
  return retQuery;
  }