Standard ABO: Assets REST APIs

Oracle CPQ 26B introduces the following enhancements to existing Standard ABO Assets REST API v19.

Get All Assets

Oracle CPQ 26B has added support for a grouping query by attribute, setting a maximum number of grouping results to retrieve and display. The following groupBy query fields are supported: startDate, endDate, subscriptionNumber, soldToPartyName, shipToPartyName, billToAccountName, and billToAddress.

Notes:

  • startDate and endDate grouping includes both date and time
  • Grouping queries respect all existing filters such as, q, finder, and keywords
  • Grouping operations only consider the root asset (where parent_asset_id is null)
  • The grouping query respects all assets. When the enableHierarchy parameter is true the asset hierarchy from root to child is returned. When the enableHierarchy parameter is false only the matching assets are returned.
  • The groupGranularity parameter is supported for date-based grouping, for example, you may specify grouping values such as day, month, quarter, and year.

Steps to enable and configure

Review the REST service definition in the REST API guides to leverage (available from the Oracle Help Center > your apps service area of interest > APIs & Schema). If you are new to Oracle's REST services you may want to begin with the Quick Start section.