ADO.NET Provider for HubSpot

Build 21.0.8137

Establishing a Connection

Authenticating to HubSpot

There are two authentication methods available for connecting to HubSpot data source, the Token based and the OAuth Authentication methods.

Some tables on the HubspotV3 schema, may not work with the OAuth mechanism. This API limitation restricts their usage only to the ApiKey (Token based authentication). Specifically, each table in the data-model section will mention the supported authentication mechanism.

Authenticate using OAuth

HubSpot supports the OAuth 2.0 authentication standard. To authenticate using OAuth, you may leave the OAuth credentials blank to use the provider's embedded app.

Alternatively, you may create a custom app to obtain the OAuthClientId, OAuthClientSecret to use custom OAuth credentials. In addition to those properties, set CallbackURL. See Using OAuth Authentication for more information.

You should set the AuthScheme to OAuth to enforce the OAuth Authentication scheme.

Authenticate using API Key

To connect using Hubspot API Keys, set the ApiKey property, and you are ready to connect.

You can get an existing or generate a new HubSpot ApiKey by following the steps below.

  1. In your HubSpot account, click the settings icon settings in the main navigation bar.
  2. In the left sidebar menu, navigate to Integrations -> API key.
  3. If a key has never been generated for your account, click Generate API key. If an ApiKey already exists, simply click Show to display it.

You can now set the retrieved key in the ApiKey connection property.

You may set the AuthScheme to Token to enforce the Token based Authentication scheme.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137