How to use Pagination in Custom Page API in Business central

(1) Share

Report

Posted on by SG-05091051-0

144

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.

All responses (2)

Answers (0)

Suggested answer

Khushbu Rajvi. 4,744 on at

Like (3)

Report

How to use Pagination in Custom Page API in Business central

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:
gdrenteria 12,290 Most Valuable Professional on at

Like (2)

Report

How to use Pagination in Custom Page API in Business central

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