Query the MSP Manager OData endpoint directly

Use Postman, cURL, PowerShell, or another HTTP client to send requests to the MSP Manager OData endpoint.

This method uses an API key instead of MSP Manager login credentials. For more information, see Generate an API Key and Configure permissions for specific API endpoints.

Authentication

Pass the API key in the X-API-Key request header:

GET https://api.mspmanager.com/odata/Tickets?$top=10

X-API-Key: YOUR_API_KEY

OData query options

Use OData query options to control the data returned. To combine options in a single request, separate them with an ampersand (&a&).

  • $filter: Returns records matching a condition.
  • $select: Returns the specified properties.
  • $expand: Returns related data in the same response.
  • $orderby: Sorts results in ascending or descending order.
  • $top: Limits the number of records returned.
  • $skip: Excludes the specified number of records from the start of the result set.

Examples

Return up to 50 tickets with a status code lower than 5 and a priority code of 1.

GET https://api.mspmanager.com/odata/Tickets?$filter=TicketStatusCode lt 5 and TicketPriorityCode eq 1&$top=50    

Return selected ticket properties, ordered from newest to oldest.

GET https://api.mspmanager.com/odata/Tickets?$select=TicketId,TicketNumber,Title,Description,CreatedDate,DueDate&$orderby=CreatedDate desc&$top=100

In the ticket entity model, Title stores the ticket subject and Description stores the ticket details.

Return the service item and contact information for a specific ticket.

GET https://api.mspmanager.com/odata/Tickets?$filter=TicketNumber eq 12345&$expand=ServiceItem,Contact

Retrieve a large result set in smaller batches with $top and $skip. Use the same sort order for each request.

# Page 1: records 1–1,000

GET https://api.mspmanager.com/odata/Customers?$orderby=CustomerId&$top=1000&$skip=0

# Page 2: records 1,001–2,000

GET https://api.mspmanager.com/odata/Customers?$orderby=CustomerId&$top=1000&$skip=1000

Return priority 1 tickets created during January 2026.

GET https://api.mspmanager.com/odata/Tickets?$filter=CreatedDate ge 2026-01-01T00:00:00Z and CreatedDate lt 2026-02-01T00:00:00Z and TicketPriorityCode eq 1

Return up to 30 priority 1 tickets with selected properties, ordered from newest to oldest.

GET https://api.mspmanager.com/odata/Tickets?$filter=TicketPriorityCode eq 1&$select=TicketNumber,Title,CreatedDate&$orderby=CreatedDate desc&$top=30

Next steps