Skip to content

HubSpot Query authentication guide

This is a step-by-step guide to acquiring credentials for authorizing the HubSpot Query component for use in Matillion ETL.

  • The HubSpot Query connector can use OAuth or Private App Token for third-party authentication. Both methods are described here.
  • While connector properties may differ between cloud data warehouses, the authentication process remains the same.

Prerequisites (OAuth)

Begin by creating an OAuth entry in Matillion ETL, as described in Manage OAuth. You should then create an authentication app in the HubSpot Developer portal, as described below.

Acquiring third-party credentials (OAuth)

  1. Open HubSpot Accounts in a browser and enter valid login credentials to continue.

  2. On the HubSpot Accounts dashboard, click the name of the account you will use to create the app.

    Note

    • This must be an app developer account.
    • You may be asked to provide additional login credentials to open the account.

  3. On the HubSpot Developer Home page, click Manage apps.

  4. On the Apps page, click Create app in the top-right of the page.
  5. In the App info tab of the new app, enter a name for the app in the Public app name field. The Description and App logo fields are not needed to complete the OAuth.
  6. Click the Auth tab, and in the Redirect URL field enter the Callback URL copied from the Manage OAuth dialog in Matillion ETL.
  7. Click Create app.

  8. Copy the Client ID and Client secret codes. These will be required to complete the OAuth configuration in Matillion ETL.

    Note

    • You will need to click Show before the Client secret code can be copied.
    • When copying the codes, some browsers may add a space to the end of the string. Watch out for this as it will cause the credentials to fail.

  9. Return to the Manage OAuth dialog in Matillion ETL to complete the OAuth configuration with the Client ID and Client secret.

Acquiring third-party credentials (Private App Token)

  1. Open HubSpot Accounts in a browser and enter valid login credentials to continue.

  2. On the HubSpot Accounts dashboard, click the name of the account you will use to obtain the token.

    Note

    • This must be an app developer account.
    • You may be asked to provide additional login credentials to open the account.

  3. On the HubSpot Developer Home page, click Manage apps.

  4. On the Apps page, click Get HubSpot API key in the top-right of the page.
  5. In the Developer App key dialog, click Show key.
  6. Copy the contents of the revealed API key field, then close the dialog.
  7. In Matillion ETL, you can paste this copied key directly into the Private App Token field of the HubSpot Query component, or the key can be stored in the Password Manager for future use.