Skip to main content
All CollectionsAPI
Paginating API Request Results
Paginating API Request Results

Break up your large result sets into manageable pages of data

Peter Novosel avatar
Written by Peter Novosel
Updated over a month ago

Paginating API Request Results

When working with large datasets, paginating API results is an essential technique to manage response sizes and improve efficiency. This guide explains how to use the pagination features in SmartSuite's API to retrieve manageable chunks of data.

Details

Answers

Plan Availability

All plans

Permissions

API Access Required

Related Reading

Overview

Pagination breaks large result sets into smaller, manageable pages of data. By default, API endpoints return all entities requested. However, you can control the size of each response and fetch specific pages by using the limit and offset parameters in your request URL.

Setting Page Size

To limit the number of items returned in each API response, use the limit parameter:

This request instructs the API to return the first 100 items.

Retrieving Subsequent Pages

To fetch additional pages, include the offset parameter. The offset specifies how many items to skip before starting the next batch:

This example skips the first 100 items and retrieves the next 100.

Response Format

The total number of results and pagination details are included in the API response:

{   "total": 5000,   "offset": 0,   "limit": 100,   "items": [     ...   ] }

Key Properties

  • total: The total number of records available.

  • offset: The starting point of the current page.

  • limit: The maximum number of items returned in the current response.

  • items: The array of data items in the current page.


Practical Use Cases and Scenarios

1. Efficient Data Retrieval

Scenario: A large dataset contains thousands of records, but you need to display only 100 records at a time in your application.

Solution: Use the limit parameter to fetch 100 records per page and the offset parameter to navigate through the dataset.

3. Optimized API Performance

Scenario: Avoid overwhelming your application or network with excessively large API responses.

Solution: Implement pagination to break down large result sets into smaller, more manageable responses.

4. Reporting and Analysis

Scenario: Generate reports that require processing all records from a dataset.

Solution: Use pagination to sequentially retrieve all records in batches and process them incrementally.

Pagination ensures your application remains responsive and efficient, even when working with extensive datasets. For more details, consult the SmartSuite API Documentation.

Did this answer your question?