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):