API Pagination

Free API Pagination calculator with clear step-by-step results.

About API Pagination

Works out the page count, the partial last page and the offset needed to jump straight to the end of a paginated API collection. It also shows how many round trips you would save by requesting the maximum page size the endpoint permits.

Formulas

Page count

Pages = ceil(total records / page size)

Last page offset

Offset = (pages - 1) x page size

Worked example

With the default values below, API Pagination returns Total pages of 250. Change any input above and every figure here is recalculated in your browser.

Inputs used

Total records in the collectionminimum 0: 12,500
Records per pageaccepts 1–10,000: 50
Maximum page size the API allowsaccepts 1–10,000: 200

Results

Total pages: 250
Records on the last page: 50
Pages if you used the maximum page size: 63
Offset that returns the last page: 12,450

Step by step

1Values used
2Page count
3Last page offset
4Total pages= 250
5Records on the last page= 50
6Pages if you used the maximum page size= 63
7Offset that returns the last page= 12,450

Assumptions and limits

The result is derived only from the 3 inputs listed above. Anything not among them is not part of the calculation.
In particular, this calculator does not take inflation, tax, fees or charges or compounding frequency into account.
Figures are rounded for display to whole numbers, so totals built from several rounded parts can differ slightly from the unrounded arithmetic.

How these calculators are built and tested is described on the Methodology page. If a figure looks wrong, please report it.

Frequently Asked Questions

Why does the last page have fewer records?

Unless the total divides evenly by the page size, the final page holds the remainder. Clients that assume a full page will silently drop records.

Should I use offset or cursor pagination?

Offset is simple and gives you the jump-to-page arithmetic above, but it gets slow and can skip or duplicate rows on a changing dataset. Cursor pagination is stable and scales better; use the page count here only as a size estimate.