Data & Query Engine

Offset-Based Pagination

Standard numbered page navigation using _page and _limit. Playground computes complete pagination metadata payload alongside standard RFC 5988 Link headers.

Interactive Page Navigator

Test numbered page offsets and limit sizes against live data:

Page 1

Target Collection

Page Size Limit (_limit)

Requesting page 1 with limit of 5 records.GET /posts?_page=1&_limit=5

Live API RunnerMethod: GET

Live Request Console

GET

response.json

{

// Click "Send" above to execute this request against the live server.

}

Pagination Metadata & Response Headers

Playground returns calculated navigation metadata in both the JSON payload and standard HTTP response headers:

JSON Payload Object

{
  "data": [ /* page items */ ],
  "pagination": {
    "page": 2,
    "limit": 5,
    "total": 100,
    "totalPages": 20,
    "hasNextPage": true,
    "hasPrevPage": true
  }
}

HTTP Response Headers

X-Total-Count: 100
X-Page: 2
X-Limit: 5
X-Total-Pages: 20
Link: <..._page=1>; rel="first",
      <..._page=1>; rel="prev",
      <..._page=3>; rel="next",
      <..._page=20>; rel="last"

Client Integration Recipes

Production patterns for smooth pagination without screen flickers:

queries/usePaginatedPosts.ts

// queries/usePaginatedPosts.ts

import { useQuery, keepPreviousData } from '@tanstack/react-query';

interface PaginationMeta {

page: number;

limit: number;

total: number;

totalPages: number;

hasNextPage: boolean;

hasPrevPage: boolean;

}

interface PostsResponse {

data: any[];

pagination: PaginationMeta;

}

export function usePaginatedPosts(page = 1, limit = 10) {

return useQuery<PostsResponse>({

queryKey: ['posts', 'paginated', page, limit],

queryFn: async () => {

const res = await fetch(

https://playground.nileslabs.com/api/v1/posts?_page=${page}&_limit=${limit}`,

{ credentials: 'include' }

);

if (!res.ok) throw new Error('Failed to load page');

return res.json();

// keepPreviousData prevents layout flickering during page navigation

placeholderData: keepPreviousData

});

}

Next Query Feature

Cursor-Based Pagination (Infinite Scroll)

Related Query Feature

CSV & Excel Export & Import

PreviousDynamic Sorting

NextCursor Pagination