How to handle sorting, pagination, and limit in a Laravel REST API?

I’m building a REST API with Laravel and I want to manage query parameters like sorting, pagination, and limit in a clean and reusable way.

For example:

Sorting results by a field (e.g., ?sort=created_at&order=desc)

Limiting the number of returned items (e.g., ?limit=10)

Paginating responses properly (e.g., ?page=2&per_page=15)

What is the recommended approach or best practice to implement this in Laravel? Should I use a package, write custom query logic, or rely on built-in features like paginate()?

martinbean

7 months ago

Level 80

@selcukgiray You can use Spatie’s query builder package in tandem with Laravel’s built-in API resources:

public function index()
{
    $articles = QueryBuilder::for(Article::query())
        ->allowedFilters([
            // Put allowed filters here..
        ])
        ->allowedSorts([
            // Put allowed sorts here...
        ])
        ->paginate();

    return ArticleResource::collection($articles);
}

1 like

selcukgiray

7 months ago

Level 1

Thank you :)

Please or to participate in this conversation.