Skip to main content
Connector guides

Connect MSPbots

MSPbots is a business-intelligence platform that MSPs run over their PSA and RMM data. Its Public API lets an administrator share the datasets and widgets behind the dashboards through a key, and…

Written By Christopher Scaminaci

Last updated 13 days ago

MSPbots is a business-intelligence platform that MSPs run over their PSA and RMM data. Its Public API lets an administrator share the datasets and widgets behind the dashboards through a key, and StackJack connects an AI assistant to that API so it can read them.

Connecting MSPbots to StackJack gives your AI assistant a pair of mspbots_ MCP tools. MCP (Model Context Protocol) tools are the standardized commands an AI assistant can call through StackJack. With them, your AI can:

  • Read a dataset - the rows of a dataset bound to your key, one page at a time, narrowed by column
  • Read a widget - the data behind a widget bound to your key, one page at a time, narrowed by column

Everything on this connector reads. The MSPbots Public API has no operation that changes anything, so both tools are on the Free tier.

How StackJack authenticates to MSPbots

MSPbots uses a Public API key. An MSPbots administrator creates it, and MSPbots decides what the key can read: only the datasets and widgets you bind to it. The address is fixed, so there is no URL to enter, and StackJack sends the key only to MSPbots' API address, only over HTTPS.

Creating the key

  1. Sign in to MSPbots as an administrator and open Settings, then Public API.
  2. Switch Enable Public API ON. While it is off, every key and every bound dataset and widget is unreachable.
  3. On the Public API tab choose Add New Key, enter a name, select Custom for the type and add a short description, then save.
  4. Open the Datasets tab and the Widget tab, choose Add, and select each dataset and widget the key may read. Confirm with Add Selected.
  5. Select the key in the API Key list and use the copy icon.

Finding the resource ids

The tools take a resource id. MSPbots shows it beside each dataset and widget bound to the key. The API cannot list them for you, so note the ids you want your AI assistant to use. A dataset id and a widget id are different kinds of id: use mspbots_get_dataset for a dataset and mspbots_get_widget for a widget.

Connect it in StackJack

  1. Open Connectors, then MSPbots.
  2. Paste the key into Public API key.
  3. Click Test connection. StackJack asks MSPbots for a resource that no key is bound to and reads the answer, which proves whether the key is accepted and changes nothing.

Paste the key again whenever you save the connection, including when you only rename it.

What is worth knowing before you start

Paging and filters

Both tools page with current (the page, from 1) and size (rows per page). StackJack accepts a size from 1 to 1000. MSPbots documents no maximum, so 1000 is StackJack's own ceiling.

A filter narrows by column. Pass a JSON object whose keys are column names exactly as MSPbots spells them (spaces included) and whose values carry the operator in their shape:

ValueMeaning
an empty stringthe column is empty
textthe column contains the text
a number or true / falsethe column equals the value
two values joined by a comma, such as 2023-01-01,2023-02-01 or 12.6,56.3a range, from the first value to the second
more pairs, such as 12.6,56.3,103,210further ranges

For example: {"Status":"Open","Update Date":"2026-10-01,2026-10-31"}. Paging uses current and size, so a column named like either one cannot be filtered this way.

What MSPbots does not support

  • A widget with a measure or calculate layer is not supported by the Public API.
  • Some widgets answer with a 502 error. That is MSPbots' answer for a widget it cannot serve through the Public API, and StackJack reports it as a temporary problem on MSPbots' side.
  • The key reads what is bound to it, not what the person asking can see in the MSPbots app.

When MSPbots refuses a call

  • The key is rejected: the key was deleted or never existed, or Enable Public API is off. Check Settings, Public API in MSPbots, then paste the key again.
  • The key may not read that resource: bind the dataset or widget to the key on the Datasets or Widget tab, then try again.
  • A resource is not found: check the resource id. Dataset ids and widget ids are not interchangeable.
  • Rate limited: MSPbots names rate limits but does not publish numbers. StackJack paces its calls and backs off when MSPbots asks it to slow down. Ask for fewer rows per page, or narrow the filters.
  • A request is rejected: the column names in a filter must match the dataset's columns exactly.

Plans and limits

Both tools are available on the Free tier. Business reaches the same tools and differs by monthly call quota.

See the generated MSPbots tool reference for the current inventory, plan assignment and input schemas.

MSPbots tools

mspbots_ · 2 tools · Free 2

Public API

ToolWhat it does
mspbots_get_dataset
Free · Read-only
Read one page of rows from a dataset bound to this MSPbots Public API key.
mspbots_get_widget
Free · Read-only
Read one page of the data of a widget bound to this MSPbots Public API key.