Use this article to set up the ConnectWise Manage - API integration with MSPbots.
Prerequisites
- You need admin permissions to perform these steps.
- Prepare the following before you start:
- Company ID
- Company URL
- Your Connectwise Manage on-premise deployment has been updated to version 2019.3 and above patch levels.
How to connect ConnectWise Manage API to MSPbots
1. Create the Security Role for MSPbots.
-
- Log in to your ConnectWise Manage Console.
- Click System > Security Roles.
You can copy some roles if they have all read-only access already or you can create a new role. - Use the Role ID: MSPbots and ensure it has the correct level and correct Restrict Board Access.
-
Set the permission.
- Set All to Inquire level for all fields. No add, edit, or delete level permission is needed for now. Keep them at None.
-
Check the permission using the permission-checking function in MSPbots app.
-
Make sure you select All as Inquire Level for all fields.
-
Check the customized permissions.
MSPbots need to have permission to read your data because, without data, the bots and reports won't work.
Since we need data to create dashboards and to drive the bots for automation, share only the data that you are comfortable sharing and any data that you want to analyze via dashboards or to create automation with. For example, if you want the auto dispatchers to put a higher priority on clients who pay you more, we need their MRR data. Most MSPs share everything, except the password field, since we have a lot of pre-built dashboards.
2. Create the API key.
- Click System > Members > API Members > + .
- Fill in the blanks and select options on the required fields marked with an asterisk (*).
- Put the Member ID and Member Name: MSPbots
- For the required drop-down fields, choose an option based on your company configuration.
- Click Save to go to the next screen.
- Role ID: MSPbots
- Click API Keys, then +, type MSPbots in the description, and save.
- You will get the Public Key and Private Key. Copy and paste these in the MSPbots setup window to finish the setup.
- Set up the API in the MSPbots app.
- Log in to Integration.
- Navigate to ConnectWise Manage - API.
-
Click the Config option.
-
Copy and paste the details into the setup window.
- Fill in the Company ID and Company URL you prepared in the Prerequisites into ConnectWise URL and ConnectWise Company ID respectively.
-
Fill in the Public Key and Private Key you obtained from 2.2.f into CW API PublicKey and CW API PrivateKey respectively.
- Click Save and Sync.
ConnectWise Manage Product Website
https://www.connectwise.com/platform/business-management/manage
ConnectWise Manage API Documentation
It is useful to add more functions to ConnectWise Manage. If you want to do this, read https://developer.connectwise.com/Products/Manage.
FAQs
1. What kind of permission does MSPbots need?
MSPbots need data from ConnectWise to generate reports and to drive the bots using data-driven decision-making. This makes having read-only permission for MSPbots to all your data important, especially if you want to create automated processes.
In the future, we will create more bots that perform actions like creating and closing tickets. We will be asking permission accordingly.
2. If I upgrade the ConnectWise app, will it affect the data synchronization?
Yes, upgrading the ConnectWise app will cause data synchronization issues for ConnectWise Manage - API integration.
If you have upgraded, you need to reauthorize the ConnectWise Manage - API integration.
If the field values in your integration connection have not changed, just click the Save and Sync button.
Known issues
1. Incorrect Ticket Resource in the ConnectWise Manage Ticket
There is a known issue where tickets show the resource list as null but are not empty different in the API Realtime Result. For more information on this known issue and the corresponding workaround, refer to Incorrect Ticket Resource in the ConnectWise Manage Ticket.
2. The API connection error details diaplay "connection timed out"
When the API connection error details of ConnectWise API integration contain connection timed out, it is recommended that you check if your firewall has added the IP addresses of MSPbots servers to the whitelist, see What MSPbots server IP addresses can I allow through the firewall.