REST API Cannot Retrieve Data Past 500 Records
Summary
REST API Cannot Retrieve Data Past 500 RecordsContent
We are using several REST API, to retrieve data for our application. For example, we are have more than 30,000 Item records in our SCM system. Here is the documentation for the API we are using:
https://docs.oracle.com/en/cloud/saas/supply-chain-management/18b/fasrp/op-items-get.html
When running several calls to the API though curl (or through our application), we are unable to see records past 500 in the results.
The first API call looks like this:
curl -u username:password "https://servername.oraclecloud.com/fscmRestApi/resources/11.13.18.05/items?q=OrganizationId=300000002559348&offset=0&limit=450&totalResults=true"
0