Unable to fetch more than 500 records from REST API using limit and offset
I'm unable to retrieve more than 500 records from the following Oracle Fusion API:
/fscmRestApi/resources/11.13.18.05/channelCustomerPrograms/{ProgramID}/child/productRules?expand=DFF&limit=500&offset=0
What I’ve tried:
- When I use
limit=500andoffset=0, I receive 500 records, and the response includes"hasMore": true. - On the next call with
limit=500andoffset=500, only 1 record is returned, despite the expectation of another 500 records. - There are over 1000
productRulesin the Fusion system for the given program, but I cannot retrieve more than 501 records in total across both calls.
Question:
How can I reliably retrieve all records from this API, given that the dataset exceeds 1000 entries and pagination using
Tagged:
0