· Dan · Guides · 2 min read
Browse ConnectWise PSA Report Columns
A searchable reference for all 263 ConnectWise PSA report endpoints and their columns. Find the right report without trial and error.
ConnectWise PSA exposes over 260 report endpoints through its /system/reports API, each returning a different set of columns. The problem? There’s no easy way to know which report has the data you need. The official docs don’t list columns, so you’re left making blind API calls and hoping for the best.
We built a searchable report columns reference to fix that.
What it does
Type a column name like closedDate or agreementName and instantly see every report that includes it. Each report page shows:
- Every column with its type (Text, Numeric, DateTime, Boolean) and whether it’s nullable
- Related reports that share the most columns, so you can discover alternatives
- An n8n node pre-configured for that report, ready to copy and paste into a workflow
Why this matters
If you’ve ever built an integration against the ConnectWise reporting API, you know the pain of discovering the right endpoint. You might need ticket aging data but not know whether it lives in ServiceTicket, ServiceTicketDetail, or one of a dozen other options. Searching by column name gets you there in seconds instead of minutes of trial and error.
The column cross-referencing is especially useful. Click on any column’s “Also In” link to see which other reports share it. This is great when you need to join data across reports or find a lighter endpoint that still has the fields you need.
Check it out
Head over to the ConnectWise Report Columns Reference and search for any column or report name.
