App builder fetches only 100 rows from M3 API dataset

Hello,

I have created a widget using App Builder which calls an M3 API. I notice that the widget shows only 100 records from the query. But when I use MITEST tool, I can see more than 100 records. Is there a way to extend or set max number of records in the App Builder dataset for M3 API's?

Thanks

DS Sharma

Find more posts tagged with

API Usage

Accepted answers

Maxime Richard

Hello,

Can you try to edit your API relative URL in "manage dataservices" in order to add ";maxrecs=xxx" (where xxx is the number of records to be returned) behind the transaction of your API :

0911060553270289.pdf

All comments

Maxime Richard

Hello,

Can you try to edit your API relative URL in "manage dataservices" in order to add ";maxrecs=xxx" (where xxx is the number of records to be returned) behind the transaction of your API :

0911060553270289.pdf

Legacy Contributor

Thank you. This solution has helped.

Also is there way to pass on a parameter from users session. For Ex: If we specify division as {DIVI} in the general M3 widget, this loads the division associated with the user session opening the widget.

Is there a similar way to achieve this in the widget build by app builder.

Thanks

DS Sharma

Copyright © 2025 Infor. All rights reserved.