Currently I am calling a custom API (CMS100MI-zzz) however it seems the response is cap out.
The row index from my response is 10,000 and it shown around 100000 lines. I added the maxReturnedRecords:999999. Is there a hard limit?
maxReturnedRecords:0 will give you maximum. But the hard limit is 10.000 as you have discovered. You need to break down the request to smaller portions and execute the API several times to get all records.
Hi Luis, The hard limit for each request is 10.000 but if your custom API have more that 10.000 lines e.g 15.000 you can send a positionkey. The positionKey is only available if you call the CMS100 Custom MI through the Api Gateway. The first time you call the CMS100 Custom MI to get the first 10.000 records you will need to set the positionKey field explicitly to " ". It should be "blank" but with a single space in it (dont ask why). Then the first 10.000 records will be returned AND the positionKey that should be used for the next call to the CMS100 Custom MI. I have not tested it with CMS100 Custom MI specifically but it works for all regular MI that is called from the API Gateway. OS → API Gateway → Available API's → Infor M3 → M3/m3api-rest/v2/execute → CMS100 → Custom MI
You cant go beyond 10K records in CMS100MIs
