How to retrieve more than 501 records from newItemRequestAffectedItems
Summary:
There are a total of 593 records. Using pagination, offset and limit, I was able to fetch the first 500 records, however the second request where offset is now set to 500, only a single record is returned.
Content (please ensure you mask any confidential information):
First Request
/fscmRestApi/resources/11.13.18.05/newItemRequests/{ID}/child/newItemRequestAffectedItems?totalResults=true&offset=0&limit=500&orderBy=ItemNumber
Result:
"totalResults": 593, "count": 500, "hasMore": true
, "limit": 500, "offset": 0,
Second Request: I expected 93 records to be returned.
/fscmRestApi/resources/11.13.18.05/newItemRequests/{ID}/child/newItemRequestAffectedItems?totalResults=true&offset=500&limit=500&orderBy=ItemNumber
Result
"totalResults": 501, "count": 1, "hasMore": false
, "limit": 500, "offset": 500,
Version (include the version you are using, if applicable):