Prerequisites
Before you begin, ensure you have:- Admin access to both ConnectWise Manage and MSPortal.ai
- Your ConnectWise company ID (visible on the ConnectWise login screen)
- Access to create API members and security roles in ConnectWise
Part 1: Configure ConnectWise Manage
Before connecting to MSPortal.ai, you need to create an API member and security role in ConnectWise.Create Security Role
1
Access System Settings
Login to ConnectWise Manage and navigate to System > Security Roles.
2
Create Security Role
Create a security role named “MSPortal” with the following permissions. These permissions enable MSPortal to sync companies, contacts, tickets, opportunities, agreements, and related data.
Click Save and Close to finalize the security role settings.
Companies
Companies
| Permission | Add | Edit | Delete | Inquire |
|---|---|---|---|---|
| Company Maintenance | All | None | None | All |
| Company/Contact Group Maintenance | All | All | None | All |
| Configurations | All | All | None | All |
| Contacts | All | All | None | All |
| CRM / Sales Activities | All | All | None | All |
| Manage Attachments | All | All | None | All |
| Notes | All | None | None | All |
| Reports | All | All | None | All |
| Surveys | All | All | None | All |
| Team Members | All | None | None | All |
Finance
Finance
| Permission | Add | Edit | Delete | Inquire |
|---|---|---|---|---|
| Agreement Invoicing | All | None | None | All |
| Agreements | All | All | None | All |
| Billing View Time | All | None | None | All |
| Invoice Approval | All | None | None | All |
| Invoicing | All | None | None | All |
| Reports | All | All | None | All |
Procurement
Procurement
| Permission | Add | Edit | Delete | Inquire |
|---|---|---|---|---|
| Inventory Adjustments | None | None | None | All |
| Inventory Transfers | None | None | None | All |
| Product Billable Option | None | None | None | All |
| Product Catalog | All | All | None | All |
| Products | All | All | None | All |
| Purchase Orders | All | All | None | All |
| Purchasing Approvals | All | All | None | All |
| Purchasing Demand | All | All | None | All |
| Serial Number Search | None | None | None | All |
Projects
Projects
| Permission | Add | Edit | Delete | Inquire |
|---|---|---|---|---|
| Project Finance | None | None | None | All |
| Project Headers | None | None | None | All |
| Project Notes | None | None | None | All |
| Project Phase | None | None | None | All |
| Project Product | None | None | None | All |
| Project Reports | None | None | None | All |
| Project Scheduling | None | None | None | All |
| Project Teams | None | None | None | All |
| Project Ticket Tasks | None | None | None | All |
| Project Tickets | All | All | None | All |
Sales
Sales
| Permission | Add | Edit | Delete | Inquire |
|---|---|---|---|---|
| Closed Opportunity | All | All | All | All |
| Opportunity | All | All | All | All |
| Opportunity Finance | All | All | All | All |
| Sales Orders | All | All | None | All |
Service Desk
Service Desk
| Permission | Add | Edit | Delete | Inquire |
|---|---|---|---|---|
| Change Approvals | All | All | None | All |
| Close Service Tickets | All | All | None | All |
| Reports | All | All | None | All |
| Resource Scheduling | All | All | None | All |
| Service Ticket - Dependencies | All | All | All | All |
| Service Tickets | All | All | None | All |
| Ticket Templates | None | None | None | All |
System
System
| Permission | Add | Edit | Delete | Inquire |
|---|---|---|---|---|
| API Report | All | All | None | All |
| Custom Menu Entry | All | All | None | All |
| Data Import | All | All | None | All |
| Member Maintenance | All | All | None | All |
| My Company | All | All | None | All |
| Report Writer | None | None | None | All |
| Table Setup | All | All | None | All |
Time and Expense
Time and Expense
| Permission | Add | Edit | Delete | Inquire |
|---|---|---|---|---|
| Time Entry | All | All | None | All |
Create API Member
1
Navigate to API Members
- Go to System > Members
- Click the API Members tab
- Click + to create a new API member
2
Configure API Member
- Name it “MSPortal”
- Select the MSPortal security role you created
- Enter your Business Unit and Location
- Click Save
3
Generate API Keys
- With the API member open, click the API Keys tab
- Click + to add a new key
- Name it “MSPortal” and click Save
- Important: Copy the Public Key and Private Key immediately
Part 2: MSPortal Setup Wizard
MSPortal.ai provides a guided setup wizard that walks you through connecting and configuring your ConnectWise Manage integration in 4 easy steps.Starting the Wizard
1
Navigate to Integrations
In MSPortal.ai, go to Settings > Integrations.
2
Start Setup
Find the ConnectWise Manage integration card and click Configure to launch the setup wizard.
Step 1: Connect
Enter your ConnectWise API credentials to establish the connection.1
Enter API Credentials
Fill in the following fields:
| Field | Description | Example |
|---|---|---|
| API URL | Your ConnectWise API URL | na.myconnectwise.net or eu.myconnectwise.net |
| Company ID | Your company identifier (shown on login screen) | YourCompanyID |
| Public Key | API public key from API member | abc123... |
| Private Key | API private key from API member | xyz789... |
API URL Examples:
- Cloud-hosted:
na.myconnectwise.net,aus.myconnectwise.net,eu.myconnectwise.net - On-premise:
cw.yourcompany.com(without https://)
2
Test Connection
Click Test Connection to verify your credentials. You’ll see a green “Connected” status when successful.If the connection fails:
- Verify your API URL is correct (no https:// prefix)
- Check that your Company ID matches exactly
- Confirm the API keys are copied correctly
- Ensure the API member has the correct security role assigned
3
Proceed
Once connected, click Next to continue to sync configuration.
Step 2: Sync
Configure what data to sync from ConnectWise and set up company filters.1
Configure Data Sync Options
Enable or disable the following sync options:
| Option | Description |
|---|---|
| Sync Users | Sync member data from ConnectWise |
| Sync Companies | Sync company data from ConnectWise |
| Enable Ticket Sync | Sync service tickets from ConnectWise |
| Enable Opportunity Sync | Sync opportunities from ConnectWise |
2
Configure Contact Auto-Import
If you want contacts to be automatically imported when companies are added:
- Enable Auto-Import to automatically create user accounts for active contacts
- Select a Default Role for Imported Contacts (e.g., Viewer)
3
Configure Company Filters
ConnectWise has additional filtering options for company sync:
| Setting | Description |
|---|---|
| Skip Inactive Companies | Only sync active companies (recommended) |
| Exclude Company Types | Select company types to exclude from sync |
| Exclude Company Statuses | Select company statuses to exclude from sync |
| Exclude Opportunity Types | Select opportunity types to exclude from sync |
| Exclude Project Types | Select project types to exclude from sync |
4
Configure Ticket Sync Scope
Define which tickets to sync:
| Setting | Description |
|---|---|
| Boards to Sync | Select which ConnectWise service boards’ tickets to sync |
| Exclude Statuses | Select ticket statuses to exclude from sync |
When you proceed to the next step, data sync will begin in the background. This may take a few minutes depending on the amount of data in your ConnectWise instance.
5
Proceed
Click Next to continue to ticket and opportunity configuration.
Step 3: Configure
Set up ticket status mapping and opportunity defaults.Ticket Settings
1
Configure Status Settings
| Setting | Description |
|---|---|
| Closed Statuses | Select statuses that indicate a ticket is closed |
| Client Comment Status | Status to set when a client comments on a ticket |
2
Configure Resolution Status Stepper
The Resolution Status Stepper provides a visual indicator of ticket progress. Map your ConnectWise statuses to each stage:
| Stage | Description |
|---|---|
| New | Tickets that are newly created or not yet triaged |
| Triaged | Tickets that have been reviewed and categorized |
| Working | Tickets actively being worked on |
| Waiting | Tickets waiting for customer response or external input |
| Resolved | Tickets that have been completed |
3
Sync Actions
Use these buttons to manage ticket sync:
| Action | Description |
|---|---|
| Quick Sync | Trigger an immediate sync of ticket data |
| Clear & Resync | Delete all synced tickets and perform a fresh sync (useful after major configuration changes) |
Opportunity Settings
1
Configure Opportunity Defaults
Set default values for opportunities created from MSPortal:
| Setting | Description |
|---|---|
| Default Stage | The starting stage for new opportunities |
| Default Status | The default status for new opportunities |
| Default Type | The default opportunity type |
| Default Probability | Starting win probability for new opportunities |
| Fallback Sales Rep | Sales rep assigned when the user doesn’t have a ConnectWise account |
Opportunity sync can be enabled or disabled in the Sync step. These settings only apply when opportunity sync is enabled.
2
Proceed
Click Next to continue to the import step.
Step 4: Import (Optional)
Import users and companies from ConnectWise. This step is optional - you can skip it and import later from the respective settings pages.- Import Users
- Import Companies
Import members (your MSP staff) from ConnectWise to create user accounts.
- Enable Import Users Now
- Select users from the list to create accounts for
- Choose a default role for imported users
Client contacts are not imported here. They can be managed via Company settings after companies are imported.
Complete Setup
Click Complete Setup to finish the wizard. Your ConnectWise Manage integration is now configured!You can return to the setup wizard at any time by clicking Configure on the ConnectWise Manage integration card. The wizard will resume with your current settings.
Managing Your Integration
After setup, you can manage your integration from Settings > Integrations:- Configure: Re-open the setup wizard to modify settings
- Resync: Trigger a manual sync of data
- Sync PSA Data: Refresh configuration data (boards, statuses, types) from ConnectWise
- Import Configurations: Import device configurations from ConnectWise
Next Steps
After connecting, you can configure additional settings:- Configure Service Desk Settings - Set up ticket sync, boards, and statuses
- Configure Opportunity Settings - Set up opportunity sync and sales pipeline
- Re-sync PSA Settings - Refresh configuration data from ConnectWise
Troubleshooting
| Issue | Solution |
|---|---|
| Connection test fails | Verify API URL format (no https://), Company ID, and API keys are correct |
| Missing companies after sync | Check if company types or statuses are excluded in sync settings |
| Permission errors | Verify the API member has the MSPortal security role assigned |
| Sync not starting | Ensure the integration shows “Connected” status before syncing |
| Tickets from wrong boards | Verify the correct boards are selected in Ticket Sync Scope |
| Contacts not importing | Verify Auto-Import is enabled and a default role is selected in the Sync step |