Product REST API Total Results Issue (Doc ID 2277338.1)

Last updated on JULY 24, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

On : 11.1.11.1.0 version, Sales, Sales Catalog

REST API Total Results Issue

Attempting to pull down products through the REST API limits results to 500.

The initial request is the following:
https://<server>/salesApi/resources/11.1.11/products?limit=300&orderBy=Name&totalResults=true


Which provides the following information:
  "totalResults": 2460,
  "count": 300,
  "hasMore": true,
  "limit": 300,

Adding an offset to call the next 300 records results in the following:
https://<server>/salesApi/resources/11.1.11/products?limit=300&offset=300&orderBy=Name&totalResults=true

Which you would expect would return the next 300 results but instead you see:
  "totalResults": 500,
  "count": 200,
  "hasMore": false,
  "limit": 300,
  "offset": 300,

 How can the additional Product records be accessed through REST API?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms