Skip to main content

ConnectWise PSA Integration

How to create a ConnectWise PSA API member with the right permissions and connect it to Strategy Overview.

This guide covers the ConnectWise-specific steps for creating API credentials and connecting to Strategy Overview. For the common setup steps that follow (mapping types, importing companies, importing configurations), see Connect Your Integrations.
​

If your ConnectWise environment requires IP whitelisting, add the Strategy Overview IPs first. See the IP Allow List article.
​

Create a Security Role

  1. Go to System > Security Roles > Add Role

  2. Role ID: StrategyOverview

  3. Set the following permissions (leave everything else at None):

Category

Permission

Add

Edit

Delete

Inquire

Used for

Companies

Company Maintenance

-

-

-

All

Importing companies

Companies

Configurations

-

All

-

All

Importing configurations and writing changes back

Companies

Contacts

-

-

-

All

Contacts, and the authors of ticket notes

Companies

Manage Attachments

All

-

-

All

Images in ticket notes

Companies

Notes

-

-

-

All

Company notes

Finance

Agreements

-

-

-

All

Syncing agreements

Finance

Invoicing

-

-

-

All

Agreement invoice history and PDFs

Project

Project Headers

All

-

-

All

Projects module: Inquire syncs projects, Add creates one from Strategy Overview

Project

Project Finance

-

-

-

All

Projects module: project budget amounts

Sales

Opportunities

All

-

-

All

Proposals: Inquire syncs opportunities, Add creates one from Strategy Overview

Service Desk

Service Tickets

All

All

-

All

Tickets module: Inquire and Edit to view, edit and add notes; Add for the New Ticket form

System

Member Maintenance

-

-

-

All

Members: ticket note authors, sales reps and project managers

System

Table Setup

All

-

-

All

Boards, statuses, types and priorities

Important: If your integration was set up earlier, compare your role with this table and add any rows it's missing. On the Agreements row, click customize and allow the agreement types you want to sync.

On the Project Headers row, set Inquire to All, not Mine. With Mine, Strategy Overview only sees the projects the API member owns, and the rest drop out without an error.
​

Create an API Member

  1. Go to System > Members > API Members tab > Add Member

  2. Member ID: strategyoverview

  3. Member Name: Strategy Overview

  4. Role ID: StrategyOverview (the role you just created)

  5. Level: Corporate

  6. Save

  7. Go to the API Key tab and click Add

  8. Description: Strategy Overview

  9. Save

  10. Copy your Public Key and Private Key. Once you leave this page, the private key won't be visible again. You can always create a new API key if needed.

Add the Integration in Strategy Overview

  1. Go to Settings > System > Integrations > Add Integration > ConnectWise PSA

  2. Server Domain Name: Your ConnectWise URL (e.g., https://cwmanage.yourmsp.com)

  3. Company ID: From your ConnectWise login screen

  4. Public Key: From the API member you created

  5. Private Key: From the API member you created

  6. Click Add Integration

Once the integration is added, follow the common steps in Connect Your Integrations to map types, markets, statuses, and import your companies and configurations.
​

Syncing agreements

The Agreements sync brings your ConnectWise agreements into the Agreements module, so turn that module on as well. The Agreements Module covers what synced agreements do. The security role needs the two Finance rows above.

  1. In Settings > System > Integrations, open your ConnectWise PSA integration and go to its Agreements tab.

  2. Tick Enable Agreements Integration.

  3. Pick at least one of your Agreement Types.
    ​

  4. Narrow it down further if you need to. Leave Statuses or Companies empty to bring in all of them, including ones added later.

  5. Check the preview, then click Import Agreements.

Each agreement brings its additions in as Line Items and its invoices in as Invoice History. Its Amount is the agreement fee plus its active, billable additions, and Save as PDF on an invoice gets that invoice's PDF from ConnectWise.
​

Unticking Enable Agreements Integration takes your synced agreements out of Strategy Overview and clears your Agreement Types, Statuses and Companies picks. To bring them back, tick it again, pick your types and click Import Agreements.
​

Syncing opportunities into Proposals

The Opportunities sync brings your ConnectWise opportunities into the Proposals module, so turn that module on as well. The Proposals Module covers working with them. The security role needs the Sales > Opportunities row above.

  1. In Settings > System > Integrations, open your ConnectWise PSA integration and go to its Opportunities tab.

  2. Tick Enable Opportunities Integration.

  3. On the Opportunity Selection tab, tick the Opportunity Types to bring in and pick an Entered Date window. The window is Last 12 months out of the box.

  4. Click Import Opportunities.

The standard opportunity fields always sync. To bring in ConnectWise custom fields as well, tick them under Fields to download on the Field Selection tab. A custom field you add starts hidden from clients, and stays hidden until you untick it under Internal Fields.
​

Each Proposal's status comes from the ticks on its ConnectWise opportunity status, not from the status's name:

  • Accepted: the status has Won ticked.

  • Declined: the status has Lost ticked.

  • Open: the status has neither ticked.

ConnectWise's Closed tick doesn't change a Proposal's status, but closed opportunities are left out of the Proposals list by default. The Status Mapping tab on the Opportunities tab shows where each of your statuses lands. It's read-only: to move a status, change its Won or Lost tick in ConnectWise.
​

A Proposal created from Strategy Overview becomes a new opportunity in ConnectWise. Its Sales Rep starts as your own ConnectWise member, matched by your email, and its Amount goes to ConnectWise as a note on the opportunity, not as the opportunity's amount, so fill in the figures in ConnectWise.
​

Unticking Enable Opportunities Integration hides every synced Proposal until you tick it again, and removes the custom fields you picked, along with their values.
​

Did this answer your question?