Connecting to ConnectWise Sell v2

This document is a step by step guide for setting up the ConnectWise Sell integration within BrightGauge.

NOTE: If you are using Quosal1, the baseline package for ConnectWise Sell, it does not have API support; because of this you will not be able to set up the ConnectWise Sell integration within BrightGauge.

IMPORTANT NOTE: In order for this integration to work, you will need to ensure that your CW Sell User has API Access enabled.  Any Sell Admin will be able to enable this setting - additional details are provided within Step 2 of this document.

Step 1 - Log in to your BrightGauge Account

If you have not created an account yet, go here to get started.

Once you have logged in:

  • For New or Existing Accounts:

From the account Overview page, click on the "Add a new Datasource" button:

Or, simply click on the "Data" menu on the top right-hand corner of the screen, and then select "Datasources" from the drop-down menu:

Screen_Recording_2018-11-06_at_04.06_PM.gif

 

On the "Add a New Datasource" page, you will find an icon for "ConnectWise Sell". 

bg_adddatasource_sell.png

 

 

Step 2 - Test and Save the ConnectWise Sell Datasource in BrightGauge

After clicking on the above icon, you will be taken to this page to enter your credentials:

Image_2019-06-05_at_10.25.32_AM.png

To find your Access Key, log into your Sell system and find your Access Key within the URL.

Note: When accessing ConnectWise Sell, login directly to ConnectWise Sell, avoid accessing it through the ConnectWise Manage Portal.

Your Access Key will include your subdomain followed by an underscore and the word azure, for example: accesskey=subdomain_azureImage_2019-07-05_at_3.53.44_PM.png

 

Additionally, the username and password are the same that you use to login to your Sell system.

IMPORTANT NOTE: In order for this integration to work, you will need to ensure that your CW Sell User is set up as an "API user".

Image_2019-06-11_at_4.40.38_PM__1_.png

After adding your credentials, simply add a name, and make sure to test the Datasource to confirm it is connecting correctly. If encountering an error when connecting to the datasource, you may need to input your username instead of your full email. For example instead of myusername@domain.com, only input username. Once that is good to go, hit "Save".

Dashboards, reports, datasets, and gauges will be added to your account after the datasource is saved. They will start syncing immediately and typically complete syncing after 20-30 minutes. 

Your Default Dashboards

  • BGS - ConnectWise Sell Overview

Your Default Reports

  • Quote Overview

Your Default Datasets

  • QuotesThis dataset represents the header of a quote, and includes important lookup information, such as the Quote Number, Quote Name, and Quote Status fields. Quotes over the last 360 days.
  • Users - Information on the users within ConnectWise Sell

For a list of all default gauges, please visit the "Gauges" section of your account, sort by the Datasource you'd like to see and select for Default.  

If you have any questions, don't hesitate to ask us at support@brightgauge.com

Was this article helpful?
2 out of 2 found this helpful

Comments

0 comments