ION API call not returning all rows

Legacy Contributor

I'm developing an app that's calling ION API M3 CRS630MI LstAccountID.  If I run the CRS630MI LstAccountID transaction from M3 Metadata Publisher it returns 830 rows.  When I run the same query using ION API it returns 98 rows.  I've tried experimenting with maxrecs=0 and various other values but maxrecs seems to be ignored from ION API.  Running a Get from Postman with maxrecs=5 still returns 98 rows.

Does anyone have any ideas as to how to get this to return the full result set?

Legacy Contributor

Hi,

Did you pass the parameters as matrix parameters or as normal parameters? It has to be a matrix parameter.

Strange that it does not return the default 100 rows if there are more rows. Try with a smaller number to see if it takes effect.

If you have tried with the matrix parameter in Postman, try with 10 for example, before trying with 0.

For example, notice that some parameters are before ? separated with ';'. Those are called matrix parameters. Added the parameter maxrec=0 as a standard query parameter does not work.

myserver.infor.com/.../LstAddresses;metadata=true;maxrecs=100;excludempty=false;cono=780;divi=AAA

Hum not sure how to add a code block in here so here is the last part of the URL above, with what I would use as default values.

protocol-server/m3api-rest/execute/CRS610MI/LstAddresses;metadata=false;maxrecs=100;excludempty=true;cono=780;divi=AAA?CUNO=MANGO

If that does not have any affect you should report it in Xtreme support.

Please note that changing the limit to 0 can have implications on performance. There are other parameters that you should pass in to reduce the overall size of the reply. Like selecting excludeempty=true and also by passing in the specific fields that you would like in the output as returncols=LMTS,LEVL,FNID,TX40.

Always specify returncols so that you don't load more data across the network than, you actually need. If you are working on a specific scenario then always optimize on all levels for that specific scenario.