How to use Pagination in Custom Page API in Business central

(0) Share

Report

Posted on by SG-05091051-0

163

Hi All,

I am using On-Prem Business Central.

I have created one Custom Page API to fetch Items from Business Central, but its taking to much long time to get all the 20,000 item.
I want to use pagination in this API to fetch 15 record for each API call, but i never use or heard about pagination in Page API.

Does anyone have any idea about it. How we can implement it or if you have any code snip you can share.

Page API code : This is my API where i want to use Pagination.

page 50119 "GetAllItemsDetail"
{
PageType = API;
APIVersion = 'v1.0';
APIPublisher = 'QueryV1';
APIGroup = 'QueryGroup';
EntityName = 'Item';
EntitySetName = 'Items';
DelayedInsert = true;
SourceTable = Item;

layout
{
area(content)
{
repeater(Group)
{
field(Id; Rec.SystemId)
{
Caption = 'Id';
}
field(ItemNo; Rec."No.")
{
Caption = 'Item No';
}
field(Name; Rec.Description)
{
Caption = 'Description';
}
field(Base_Unit_Price; Rec."Unit Price")
{
Caption = 'Base Unit Price';
}
}
}
}
}

Thanks for your Help.

I have the same question (0)

All responses (2)

Answers (0)

Gerardo Rentería Ga... 25,396 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi

I h ope this can help you

Pagination for long json response (trial version) (dynamics.com)

how to do pagination in MS Dynamics REST APIs

Solved: Using pagination on Business Central API (dynamics.com)

Best

GR

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 21,048 Super User 2025 Season 2 on at

Like (3)

Report
Copy link

Link copied!

Hi, you can use the built-in pagination support for Page APIs with the $top and $skip query parameters automatically handled by the API framework. you can make API calls using the standard pagination parameters:

To retrieve the first 15 items:

Was this reply helpful? Yes No