Pagination

For endpoints that return lists (such as events or sales records), the Sales Tracker API implements pagination to manage large result sets and improve performance.

Pagination Parameters

• page: The page number to retrieve. If not provided, the default value is 1.

• limit: The number of records to return per page. The default is 10, with a maximum value of 100.

How It Works

The API calculates the offset for the SQL query using the formula:

offset = (page - 1) * limit

For example, if you request page=3 and limit=10, the API will retrieve records starting at offset 20 (i.e., the 21st record) and return 10 records.

Response Format

Paginated responses include the following metadata:

• total_count: The total number of records available.

• page: The current page number.

• limit: The number of records returned per page.

• results: An array containing the records for the requested page.

Example Response

{
  "total_count": 37921,
  "page": 1,
  "limit": 100,
  "events": [
    {
      "EventID": 2677,
      "Location": "Yokohama International Stadium",
      "Ort": "Yokohama city",
      "CountryCode": null,
      "Performer": "England",
      "PerformerSlug": "england",
      "Created": "2025-02-07 16:24:37",
      "title": "Rugby World Cup 2019 - Final",
      "date": "2019-11-02 18:00:00",
      "last_update": "2025-02-25 09:13:47",
      "image": "https://example.com/images/event2677.jpg",
      "marketplace": {
        "id": 3,
        "name": "Gigsberg"
      }
    }
    // ... more events
  ]
}

Clients can adjust the page and limit parameters to navigate through the full dataset.