Get HubSpot tickets list with filters and pagination

curl --request GET \
  --url http://localhost:2000/hubspot/tickets/list/{startDate}/{endDate}/{startIndex}/{endIndex} \
  --header 'Authorization: Bearer <token>'

import requests

url = "http://localhost:2000/hubspot/tickets/list/{startDate}/{endDate}/{startIndex}/{endIndex}"

headers = {"Authorization": "Bearer <token>"}

response = requests.get(url, headers=headers)

print(response.text)

const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};

fetch('http://localhost:2000/hubspot/tickets/list/{startDate}/{endDate}/{startIndex}/{endIndex}', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_PORT => "2000",
  CURLOPT_URL => "http://localhost:2000/hubspot/tickets/list/{startDate}/{endDate}/{startIndex}/{endIndex}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "http://localhost:2000/hubspot/tickets/list/{startDate}/{endDate}/{startIndex}/{endIndex}"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("Authorization", "Bearer <token>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

require 'uri'
require 'net/http'

url = URI("http://localhost:2000/hubspot/tickets/list/{startDate}/{endDate}/{startIndex}/{endIndex}")

http = Net::HTTP.new(url.host, url.port)

request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'

response = http.request(request)
puts response.read_body

{
  "message": "",
  "data": [
    {
      "total": 20,
      "results": []
    }
  ]
}

Ticket Management

List HubSpot Tickets

Retrieves a list of HubSpot tickets within the specified date range and pagination window. Supports filtering by agent, feedback category, search keyword, and department code.
Notes: - If the calculated pageSize (endIndex - startIndex) exceeds 50, it is automatically resized to 50. - search looks into the following fields: content, chauffeur_name, passenger_name, and subject. - agentInvolved and feedbackCategory must match values returned from the /hubspot/tickets/list/filters endpoint. - departmentCode must be a valid department code in the system. - closedOnly must be a “false”/“true” in string default ‘false’. Returns only closed tickets

GET

hubspot

tickets

list

{startDate}

{endDate}

{startIndex}

{endIndex}

Get HubSpot tickets list with filters and pagination

curl --request GET \
  --url http://localhost:2000/hubspot/tickets/list/{startDate}/{endDate}/{startIndex}/{endIndex} \
  --header 'Authorization: Bearer <token>'

import requests

url = "http://localhost:2000/hubspot/tickets/list/{startDate}/{endDate}/{startIndex}/{endIndex}"

headers = {"Authorization": "Bearer <token>"}

response = requests.get(url, headers=headers)

print(response.text)

const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};

fetch('http://localhost:2000/hubspot/tickets/list/{startDate}/{endDate}/{startIndex}/{endIndex}', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_PORT => "2000",
  CURLOPT_URL => "http://localhost:2000/hubspot/tickets/list/{startDate}/{endDate}/{startIndex}/{endIndex}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"net/http"
	"io"
)

func main() {

	url := "http://localhost:2000/hubspot/tickets/list/{startDate}/{endDate}/{startIndex}/{endIndex}"

	req, _ := http.NewRequest("GET", url, nil)

	req.Header.Add("Authorization", "Bearer <token>")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

require 'uri'
require 'net/http'

url = URI("http://localhost:2000/hubspot/tickets/list/{startDate}/{endDate}/{startIndex}/{endIndex}")

http = Net::HTTP.new(url.host, url.port)

request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'

response = http.request(request)
puts response.read_body

{
  "message": "",
  "data": [
    {
      "total": 20,
      "results": []
    }
  ]
}

Retrieves a list of HubSpot tickets within the specified date range and pagination window. Supports filtering by agent, feedback category, search keyword, and department code.

Request

Headers

Name	Type	Required	Description
Authorization	string	Yes	Bearer token

Path Parameters

Parameter	Type	Required	Description
startDate	string	Yes	Start date for filtering tickets (inclusive)
endDate	string	Yes	End date for filtering tickets (inclusive)
startIndex	integer	Yes	Starting index for pagination
endIndex	integer	Yes	Ending index for pagination (max page size = 50)

Path Parameter Format

Date Format: YYYY-MM-DD (ISO 8601 date)
Pagination: Zero-based indexing
Page Size: Automatically limited to 50 items max

Query Parameters

Parameter	Type	Required	Description
agentInvolved	string	No	Filter by agent (from filters endpoint)
feedbackCategory	string	No	Filter by category (from filters endpoint)
search	string	No	Search keyword across multiple fields
departmentCode	string	No	Valid department code filter
closedOnly	string	No	”true”/“false” - return only closed tickets

Query Parameter Details

agentInvolved: Must match value from /hubspot/tickets/list/filters
feedbackCategory: Must match value from /hubspot/tickets/list/filters
search: Searches in content, chauffeur_name, passenger_name, and subject
departmentCode: Must be valid department code in system
closedOnly: Default “false”, use “true” for closed tickets only

Response

200 OK - Successfully retrieved filtered ticket list

{
  "message": "",
  "data": [
    {
      "ticketId": "12345678",
      "subject": "Late Driver - Airport Pickup",
      "feedbackCategory": "Late Driver",
      "agentInvolved": "abdullah",
      "status": "closed",
      "createdAt": "2025-10-01T10:30:00.000Z",
      "updatedAt": "2025-10-01T14:45:00.000Z",
      "priority": "high",
      "departmentCode": "OPS",
      "passenger_name": "John Smith",
      "chauffeur_name": "Mike Johnson"
    },
    {
      "ticketId": "12346",
      "subject": "Vehicle Maintenance Required",
      "feedbackCategory": "Vehicle Issue",
      "agentInvolved": "jane-smith",
      "status": "open",
      "createdAt": "2025-10-02T09:15:00.000Z",
      "updatedAt": "2025-10-02T11:30:00.000Z",
      "priority": "medium",
      "departmentCode": "MA",
      "content": "Customer reported vehicle making unusual noises"
    }
  ]
}

400 Bad Request

{
  "error": {
    "code": "INVALID_FILTER",
    "message": "Invalid filter or pagination parameters"
  }
}

401 Unauthorized

{
  "error": {
    "code": "UNAUTHORIZED",
    "message": "Missing or invalid token"
  }
}

500 Internal Server Error

{
  "error": {
    "code": "SERVER_ERROR",
    "message": "Internal server error"
  }
}

Examples

Get first 10 tickets for date range

curl -X GET 'http://localhost:2000/hubspot/tickets/list/2025-10-01/2025-10-20/0/50' \
  -H 'Authorization oBearerbearer your-jwt-token'
'

Filter by agent and category

curl -X GET 'http://localhost:2000/hubspot/tickets/list/2025-10-01/2025-10-20/0/50?agentInvolved=abdullah&feedbackCategory=Late Driver' \
  -H 'Authorization oBearerbearer your-jwt-token'

Search with keyword

curl -X GET 'http://localhost:2000/hubspot/tickets/list/2025-10-01/050?search=airport delay&startIndex=0&endIndex=25' \
  -H 'Authorization oBearerbearer your-jwt-token'

Filter by department and closed tickets

curl -X GET 'http://localhost:2000/hubspot/tickets/list/2025-10-01/050?departmentCode=OPS&closedOnly=true' \
  -H 'Authorization oBearer your-jwt-token'
'

Data Fields Explained

Ticket Object Fields

Field	Type	Description
ticketId	string	Unique HubSpot ticket identifier
subject	string	Ticket subject line
feedbackCategory	string	Feedback category assigned to ticket
agentInvolved	string	Agent handling the ticket
status	string	Current ticket status (open, closed, etc)
createdAt	string	Ticket creation timestamp (ISO 8601)
updatedAt	string	Last update timestamp (ISO 8601)
priority	string	Ticket priority level
departmentCode	string	Department code associated with ticket
passenger_name	string	Passenger name (if available)
chauffeur_name	string	Chauffeur name (if available)
content	string	Ticket content/description

Use Cases

Ticket Dashboard: Display paginated ticket lists
Filter Management: Apply multiple filters simultaneously
Search Functionality: Search across ticket content and metadata
Department Views: Show tickets by department
Agent Workloads: View tickets assigned to specific agents

Implementation Examples

React Component with Pagination

import React, { useState, useEffect } from 'react';

function TicketList() {
  const [tickets, setTickets] = useState([]);
  const [loading, setLoading] = useState(false);
  const [page, setPage] = useState(0);
  const [filters, setFilters] = useState({});

  const pageSize = 25;
  const startDate = '2025-10-01';
  const endDate = '2025-10-31';

  useEffect(() => {
    fetchTickets();
  }, [page, filters]);

  const fetchTickets = async () => {
    setLoading(true);
    const startIndex = page * pageSize;
    const endIndex = startIndex + pageSize;
    
    const queryParams = new URLSearchParams(filters).toString();
    const url = `/hubspot/tickets/list/${startDate}/${endDate}/${startIndex}/${endIndex}?${queryParams}`;
    
    try {
      const response = await fetch(url, {
        headers: { 'Authorization': `Bearer ${token}` }
      });
      const data = await response.json();
      setTickets(data.data);
    } catch (error) {
      console.error('Error fetching tickets:', error);
    } finally {
      setLoading(false);
    }
  };

  return (
    <div>
      <TicketFilters onFilterChange={setFilters} />
      {loading ? <LoadingSpinner /> : <TicketTable tickets={tickets} />}
      <Pagination page={page} onPageChange={setPage} />
    </div>
  );
}

Advanced Filtering

const buildFilterQuery = (filters) => {
  const params = new URLSearchParams();
  
  if (filters.agent) params.append('agentInvolved', filters.agent);
  if (filters.category) params.append('feedbackCategory', filters.category);
  if (filters.search) params.append('search', filters.search);
  if (filters.department) params.append('departmentCode', filters.department);
  if (filters.closedOnly) params.append('closedOnly', 'true');
  
  return params.toString();
};

// Usage
const filterQuery = buildFilterQuery({
  agent: 'abdullah',
  category: 'Late Driver',
  search: 'airport',
  department: 'OPS',
  closedOnly: 'false'
});

Pagination Logic

Calculate Total Pages

const calculatePagination = (totalCount, pageSize) => {
  return {
    totalPages: Math.ceil(totalCount / pageSize),
    hasNextPage: (page + 1) * pageSize < totalCount,
    hasPrevPage: page > 0,
    startIndex: page * pageSize,
    endIndex: Math.min((page + 1) * pageSize, totalCount)
  };
};

Pagination Controls

function Pagination({ page, onPageChange, hasNextPage, hasPrevPage }) {
  return (
    <div className="pagination">
      <button 
        disabled={!hasPrevPage} 
        onClick={() => onPageChange(page - 1)}
      >
        Previous
      </button>
      <span>Page {page + 1}</span>
      <button 
        disabled={!hasNextPage} 
        onClick={() => onPageChange(page + 1)}
      >
        Next
      </button>
    </div>
  );
}

Best Practices

Pagination: Use reasonable page sizes (10-50 items)
Filtering: Validate filter values before API calls
Search: Debounce search input to avoid excessive API calls
Caching: Cache ticket data for short periods
Error Handling: Handle pagination and filter errors gracefully

Performance Considerations

Page Size: Larger pages take longer to load
Filter Combinations: Multiple filters may impact performance
Date Range: Very large date ranges may be slow
Search: Full-text search can be resource-intensive

Use /hubspot/tickets/list/filters to get filter options
Use /hubspot/ticket-details/{ticketId} for full ticket details
Use /hubspot/tickets/list/export to export filtered results

Notes

Page size automatically limited to 50 items maximum
Filter values must match exactly with values from filters endpoint
Search is case-insensitive but matches partial words
Date range is inclusive of both start and end dates
Results are sorted by creation date (newest first) by default

Authorizations

Authorization

string

header

required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

startDate

string<date>

required

Start date for filtering tickets (inclusive)

endDate

string<date>

required

End date for filtering tickets (inclusive)

startIndex

integer

required

Starting index for pagination

Required range: x >= 0

endIndex

integer

required

Ending index for pagination (max page size = 50)

Required range: x >= 1

Query Parameters

agentInvolved

string | null

Filter by agent (must be one of the agents returned from /hubspot/tickets/list/filters)

feedbackCategory

string | null

Filter by category (must be one of the categories returned from /hubspot/tickets/list/filters)

string | null

Keyword to search across multiple fields — content, chauffeur_name, passenger_name, and subject.

departmentCode

string | null

Valid department code to filter tickets by department

closedOnly

string

closedOnly must be a "false"/"true" in string default 'false'. Returns only closed tickets.

Response

Successfully retrieved filtered ticket list

message

string

Example:

""

data

object[]

Array of matching tickets

​Request

​Headers

​Path Parameters

​Path Parameter Format

​Query Parameters

​Query Parameter Details

​Response

​200 OK - Successfully retrieved filtered ticket list

​400 Bad Request

​401 Unauthorized

​500 Internal Server Error

​Examples

​Get first 10 tickets for date range

​Filter by agent and category

​Search with keyword

​Filter by department and closed tickets

​Data Fields Explained

​Ticket Object Fields

​Use Cases

​Implementation Examples

​React Component with Pagination

​Advanced Filtering

​Pagination Logic

​Calculate Total Pages

​Pagination Controls

​Best Practices

​Performance Considerations

​Related Endpoints

​Notes

Authorizations

Path Parameters

Query Parameters

Response

Request

Headers

Path Parameters

Path Parameter Format

Query Parameters

Query Parameter Details

Response

200 OK - Successfully retrieved filtered ticket list

400 Bad Request

401 Unauthorized

500 Internal Server Error

Examples

Get first 10 tickets for date range

Filter by agent and category

Search with keyword

Filter by department and closed tickets

Data Fields Explained

Ticket Object Fields

Use Cases

Implementation Examples

React Component with Pagination

Advanced Filtering

Pagination Logic

Calculate Total Pages

Pagination Controls

Best Practices

Performance Considerations

Related Endpoints

Notes