ConnectWise PSA Data Stream Parameters
The ConnectWise PSA plugin provides configurable data streams that you can narrow down to specific companies, agreements and other ConnectWise objects. The Members data stream has no parameters, so it is not listed here.
Each configurable data stream exposes a set of parameters that lets you filter the data you retrieve. The following information describes the available configurable data streams and their parameters in detail.
Agreements
Returns client contracts and SLAs, with one row for each agreement.
Companies
Returns client company accounts, with one row for each company.
Configurations
Returns managed assets (configuration items), with one row for each configuration.
Projects
Returns projects, with one row for each project.
Tickets
Returns service tickets, with one row for each ticket.
The Tickets data stream includes a State column that shows Open or Closed. Use it instead of the Closed column when you want readable labels.
Ticket Counts
Returns the number of tickets for each priority or board, with one row for each value. The data stream makes one count request for each priority or board, instead of loading every ticket. If a request fails, that value is left out and a warning is shown.
Ticket Counts needs the Table Setup permission. See Creating an API Member and keys. For counts for each company, use the Tickets data stream with the Company parameter.
Time Entries
Returns time tracking entries, with one row for each logged time entry. Time entries are filtered by their start time using the timeframe.