Toucan 3.0
YouPrep documentationHelp centerGet a demo
  • Welcome
    • 👋Welcome to Toucan
    • ⚙️Technical resources
      • ⚙️Toucan stack
      • Setup mode
        • Toucan SaaS mode
      • ⚙️Security
        • Application Security
        • Source Code Quality
        • Global Security Practices
        • Security of Docker Images
  • TUTORIALS
    • 📊Getting Started : Embedded Analytics
    • 🤓Advanced tutorials
      • Embedding a story with user attributes
        • Dynamic filter with user attributes
        • Dynamic Tables
        • Dynamic Database
        • Dynamic Host
      • Using the HTTP API connector in advanced use cases
      • Using advanced syntax for SQL queries
      • Merging filters with our tool
      • Deep customization chart (CSS)
        • Homepage customization
        • Chart customization
        • Dashboard customization
  • Data Management
    • 🧮Overview of Data In Toucan
    • 📡Datasources in Toucan
      • 🔌Managing Connectors
        • 🔌Creating, editing and deleting a connector
        • 🔌Set up OAuth2 credentials for your platform
        • 🔌Setting up a connector
          • 🔌Generic Connectors
            • 🔌Setting up an HTTP API connector
            • 🔌Setting up an ODBC Connector
          • 🔌Database and data warehouse Connectors
            • 🔌Setting up an AWS Redshift Connector
            • 🔌Setting up a Snowflake Connector
            • 🔌Setting up a PostgreSQL Connector
            • 🔌Setting up a Google Big Query Connector
            • 🔌Setting up an AWS Athena connector
            • 🔌Setting up a MySQL connector
            • 🔌Setting up a MongoDB connector
            • 🔌Setting up a Microsoft SQL Server connector
            • 🔌Setting up an Azure SQL connector
            • 🔌Setting a Databricks Connector
            • 🔌Setting up a ElasticSearch Connector
            • 🔌Setting up a Clickhouse Connector
          • 🔌Online services connectors
            • 🔌Setting up a Sharepoint Connector
            • 🔌Setting up a Google Sheets Connector
            • 🔌Setting up a Salesforce Connector
            • 🔌Setting up a Hubspot Connector
          • 🔌Setting up an AWS S3 connector
      • 📁Managing Files
        • 📁Adding, editing and deleting local files
        • 📂Using advanced file settings
        • 📁Adding and combining remote files in Toucan
    • 🔢Datasets in Toucan
      • 🔢Stored and Live Datasets
      • 💿Managing datasets
        • 🔢Creating datasets
        • 🔢Editing, Duplicating and Deleting a dataset
        • 🔢Refreshing and Publishing Datasets
        • 📈Optimize data performance
        • 🗂️Adding indexes to stored datasets
        • 👩‍💻Code mode and single mode
      • 🛑Setting permissions on dataset
      • 🗃️Maintaining Data
        • 🗃️Tagging datasets
        • 🗃️Identifying datasets dependencies
        • 🗃️Set validation rules
    • 🧑‍🍳Preparing data
      • Overview of YouPrep™
        • 🎹Column header
          • Rename column
          • Duplicate column
          • Fill null values
          • Replace values
          • Sort values
          • Convert columns data types
        • Add
          • Add text column
          • Add formula column
          • Add conditional column
        • Filter
          • Delete columns
          • Keep columns
          • Filter rows
          • Top N rows
          • ArgMax
          • ArgMin
        • Aggregate
          • Group by
          • Add total rows
          • Hierarchical rollup
          • Get unique groups/values
        • Compute
          • Compute evolution
          • Cumulated sum
          • Percentage of total
          • Rank
          • Moving average
          • Compute statistics
          • Absolute value
        • Text
          • Concatenate
          • Split column
          • Extract substring
          • To lowercase
          • To uppercase
          • Compare text columns
          • Trim spaces
          • Replace text
        • Date
          • Convert text to date
          • Convert date to text
          • Extract date information
          • Add missing dates
          • Compute duration
        • Reshape
          • Pivot
          • Unpivot
          • Waterfall
        • Combine
          • Append datasets
          • Join datasets
        • Geo
          • Geographic dissolve
          • Geographic hierarchy
          • Geographic simplify
          • Prepare geo data (with basemap)
      • YouPrep™ Native SQL
      • Hybrid pipeline
    • ➿Managing variables in Toucan
      • ➿Variables hub
      • ♈Use variables in YouPrep™
      • ➿Easy reference to variables
    • 🧞Using advanced data concepts
      • 🧞Data personnalisation with user attributes
        • Connector setup with a user attribute
        • Database selection with a user attribute
        • YouPrep data filtering with a user attribute
        • Filter data in SQL with a user attribute
      • 🧞Advanced syntax for variables
      • 🧞Data cache
  • Visualizations and Layouts
    • 📺Apps
      • 📺Managing Apps
        • ➕Creating Apps
        • 📄Duplicating Apps
        • 🖨️Publishing Apps
        • 🚮Deleting Apps
        • ✍️Editing within an App
      • 🖌️Customizing Apps
        • Customizing chart color elements
        • Customizing the app's font
        • Adding Assets
        • Adding Glossary
        • Setting up, Managing and testing custom visibilities
        • Customizing the "no data error" message
        • Creating a dynamic background based on an Filter's column
      • 🏠Home
        • Creating the Home
        • Creating Tiles
          • Tile Dynamic Value
          • Tile Leaderboard
          • Tile Line
          • Tile Scorecard
          • Tile Bullet
          • Tile Heatmap
          • Tile PDF
          • Tile Video
          • Tile Image
          • Tile Text
          • Tile HTML
          • Tile Separator
      • ✨Stories
        • Creating a Story
        • KPIs
        • Narrative
        • Crossfilter
      • 📽️Filters
        • Managing Filters
          • Creating, reusing and editing Filters
          • Applying Filters
          • Unpinning and deleting Filters
        • Type of Filters
          • Dropdown
          • Checkboxes
          • Buttons
          • Date Range
          • Hierarchical
          • Slider
        • Templating from Filters' values
        • Dependant Filters
      • 📈PDF Report
      • 🎡Datawall
      • 🏗️Dashboard Builder
        • Create a Dashboard Builder
        • Embed a Dashboard Builder
        • Dashboard export options
      • 🌟MyFavorites
    • 📊Creating Visualizations
      • 🤩Viz Gallery
        • Barchart
        • Barlinechart
        • Bubblechart
        • Bulletchart
        • Circularchart
        • Funnelchart
        • Gantt chart
        • Heatmap
        • HTML
        • Leaderboard
        • Leaderboard Centered Average
        • Linechart
        • Mapchart
          • Configure a drill
        • Mediachart
        • Radarchart
        • Tablechart
        • Timeline
        • Versuschart
        • Waterfallchart
        • Score Card
        • Stacked Barchart
      • 🧠Common Chart Configuration
      • 💅Customizing chart colors
      • 🧞‍♂️Advanced chart configuration
        • Templating from chart's dataset
        • Add units, precisions and sentiments
        • Adding Tutorials
        • Add sparklines
        • Navigate with stories
        • Group informations in your stories
        • Multiple charts in one story
        • Manage dates
        • Customize tiles' sources
        • Add stars to tiles' title
        • Manage data order in your tiles
        • Navigate with tiles
    • 👩‍💻Embedding
      • 🔐Authentication
      • 🖇️Integration
        • Generate and manage embeds
        • Customize embeds
        • Embedding a Toucan App Using iFrames
        • Passing Extra Variables to Your Toucan Embed
      • ⚙️Embed SDK
        • Embed SDK Authentication
      • ❓FAQ
    • 🙋Self-Service
      • Self-Service Dashboard
      • Self-service PDF Report
  • Collaboration
    • ⏰Creating alerts
    • 📧Managing notifications
    • ➕Enriching a story with descriptions
    • 💌Sharing content
    • 💬Adding comments to stories
  • Administration
    • Page
    • ⚙️Instance Management
      • ⚙️Managing operations in SaaS
      • ⚙️Customizing your instance (whitelabel)
    • 👥Managing Users
      • 👥Users
      • 👥Managing user groups
      • 👥Managing user properties
      • 👥Setting up permissions and visibilities
    • 🌐Managing languages in Toucan (internationalisation)
    • 📈Monitoring Engagement with User Analytics
      • 🎛️How to Filter your User Analytics?
      • 🖥️Understanding your User Analytics Dashboards
  • Additional Ressources
    • 📚External documentation
    • 🚁Support for App-builders
    • 🆕Latest releases
      • 🎁2025 Releases
      • 🎁2024 Releases
      • 🎁2023 Releases
    • 🔧Troubleshooting
      • Troubleshoot:: DataHub
      • Cross-Site Cookies
      • How to :: read the inspector error
      • How to :: troubleshoot the toucan way
Powered by GitBook
On this page
  • HubSpot connector¶
  • HubSpot connector (with a private application)¶

Was this helpful?

  1. Data Management
  2. Datasources in Toucan
  3. Managing Connectors
  4. Setting up a connector
  5. Online services connectors

Setting up a Hubspot Connector

Last updated 1 year ago

Was this helpful?

HubSpot connector¶

Warning

This connector is deprecated. It is recommented to use the HubSpot connector with Private Apps instead.

This connector is used to retrieve data from the HubSpot API:

The email events part relies for now on Hubspot’s legacy API:

Create a HubSpot application¶

First, you need to create a HubSpot application. To do so, you will need a registered :

  • Head over to Manage apps.

  • Click on Create app.

  • Once the App Info is filled, click on the Auth part, you’ll see the following:

  • Scroll down to the “Redirect URL” part and fill up the redirect URI.

    • The redirect URI should be like the following pattern:

      • https://api-{your-instance-name}.toucantoco.com/oauth/redirect?type=Hubspot

  • Scroll down to the Add a required scope part:

  • Then add any combination of the following scopes :

    • contacts

    • content

    • forms

    • business-intelligence

    • e-commerce

  • Note that the connector will not work on certain types of data if a scope listed above is not added to the required scopes of your HubSpot application.

  • Do not forget to click on the Save button at the bottom of the page when all your modifications are finished.

How to connect¶

Once your HubSpot application is created, you will need to set-up the client_id and client_secret credentials of your previously created application.

Data provider configuration¶

Once the credentials are set-up, you will need to configure your data provider. All of the pulled data is taken from your HubSpot application, whether it’s about email campaigns, companies, deals, etc.

Go to the connectors interface from the DATA section in the Toucan Studio:

Click on the ADD A CONNECTOR button:

In the search bar, search for the hubspot connector by typing hubspot, then click on the connector:

A pop-up window will open and look like this, click on the account that you wish to link to your connector:

On the next window, all the scopes that are required by the application are displayed; a confirmation is required to link your connector to your hubspot account, just click on Connect app to do so:

You will be redirected to your instance with a new popup with two fields: name and Auth Flow ID. Auth Flow ID should be pre-filled and name empty.

Fill the name part and save your new connector:

Data source configuration¶

Once the data provider is configured, it is possible to add one (or more!) data source that will provide data for your apps.

The HubspotDataset parameter is needed to define the kind of data you want to query in the following list:

  • contacts (default value)

  • companies

  • deals

  • products

  • web-analytics

  • email-events

The HubspotObjectType and parameters parameters are needed for the web-analytics dataset:

  • parameters is a dict-like object that will contain filters that you want to use to filter the resulting data

    • The value can be anything

  • HubspotObjectType has only one value for now (contact) but this may evolve in the future

Once you are all set, just hit SAVE and voilà!

HubSpot connector (with a private application)¶

Create a private application¶

First, you need to create a HubSpot private application.

To create one, follow these steps:

  1. Go to the Settings page of your HubSpot account (click on the small gear in the top right corner of the page).

  2. Head over to the Account Setup/Private Apps section.

  3. Click on the Create a private app button.

  1. Fill out the basic information form.

  1. Click on the Scopes tab. Toucan needs a read access on all CRM objects you want to query. The following objects are supported:

    • companies

    • contacts

    • deals

    • owners

    • quotes

  2. Once you’ve ticked all the scopes you need, click on the “Create app” button.

  1. You will now need to copy your app’s access token: Click on the View access token button, and then on Copy in the pop-up.

Connecting Toucan to HubSpot¶

Now that your HubSpot private application is created, you will need to create a connector. Proceed to the connectors tab and click on Create a connector. Search for Hubspot (private application), and click on it:

Then, paste the previously copied access token in the Access token field and click on Save afterwards.

Creating a data source¶

Now that the connector is configured, it is time to add a data source that will provide data for your app.

The HubspotDataset parameter is needed to specify the kind of data you want to query. Pick the desired dataset (note that your private app needs to have the right scopes for that), and click on Validate (or Run preview if you want a preview of your data first).

You’re all done!

Look at for more information.

The key must follow this schema: objectProperty.{property}, where property is a value defined in

This connector is used to retrieve data from the HubSpot API:

📡
🔌
🔌
🔌
🔌
Set up OAuth2 credentials for your platform
HubSpot’s documentation
HubSpot API Documentation
HubSpot API Documentation
HubSpot legacy API Documentation
HubSpot developer account
Hubpot Manage App Menu
HubSpot_create_app
HubSpot_auth_app_layout
HubSpot_app_add_redirect_uri
HubSpot_app_add_scopes
HubSpot_create_connector_step_1
HubSpot_create_connector_step_2
HubSpot_create_connector_step_3
HubSpot_create_connector_step_4
HubSpot_create_connector_step_5
HubSpot_create_connector_step_6
HubSpot_create_data_source
HubSpot_private_app_private_apps_menu
HubSpot_private_app_basic_info
HubSpot_private_app_scopes
HubSpot_private_app_view_access_token
HubSpot_private_app_select_connector
HubSpot_private_app_paste_access_token
HubSpot_private_app_data_source
Hubspot Developer Console
HubSpot_create_app
HubSpot_auth_app_layout
HubSpot_app_add_redirect_uri
HubSpot_app_add_scopes
HubSpot_create_connector_step_1
HubSpot_create_connector_step_2
HubSpot_create_connector_step_3
HubSpot_create_connector_step_4
HubSpot_create_connector_step_5
HubSpot_create_connector_step_6
HubSpot_create_data_source
HubSpot_private_app_private_apps_menu
HubSpot_private_app_basic_info
HubSpot_private_app_scopes
HubSpot_private_app_view_access_token
HubSpot_private_app_select_connector
HubSpot_private_app_paste_access_token
HubSpot_private_app_data_source