Need Data Connection String

Ray_Portugal · ‎Apr 27, 2017

Hi,
I’m trying to do an integration with Hubspot and SiSense. I have created an App in Hubspot. What are the next steps to generate the Hubspot connection string? Below is an example of what I need. Thanks

Ray

The following is an example of a HubSpot connection string:

jdbc:hubspot:OAuthClientId=xxxxxxxxxxxxxx;OAuthClientSecret=xxxxxxxxxxxxxxxxxx;InitiateOAuth=GETANDREFRESH;HubId=xxxxxxxxx;CallbackURL=http://localhost;Timeout=0;

3PETE · ‎Apr 27, 2017

You need to now install the app into your portal. Here is a link to a forum post that can help walk you through it.

Ray_Portugal · ‎Apr 28, 2017

Hi Peter,

Would it be possible to get on the phone to go through this? The
instructions are confusing and I just have some questions. Thanks

Ray

3PETE · ‎Apr 28, 2017

@Ray_Portugal This is not a support forum so I don’t hop on calls with customers. Is there a specific part you are confused about that I can help clarify?

Ray_Portugal · ‎Apr 28, 2017

OK. I have already created an App. The title of my App is “Ray’s App.”
According to your email, I’m supposed to download an App into the portal.
What App are you referring to?

I went to this URL and it wasn’t clear to me what App to download.

Get OAuth 2.0 Access Token and Refresh Tokens

POST /oauth/v1/token

7
http://developers.hubspot.com/docs/methods/oauth2/get-access-and-refresh-tokens

I just need the steps to complete this and generate the connection string.
Thanks

3PETE · ‎Apr 28, 2017

The app you just made is the app that you need to install into the portal. You need to grab the client ID and the client secret from the app and use that in your OAuth flow to install it.

Ray_Portugal · ‎May 1, 2017

Hey Peter,

I went to this URL (*https://app.hubspot.com/auth/authenticate/
https://app.hubspot.com/auth/authenticate/) *for OAuth authorization and
received this error. Please advise. Thanks

Ray

Ray_Portugal · ‎May 1, 2017

Attached is the error.

3PETE · ‎May 1, 2017

@Ray_Portugal Did you include the parameters in the URL? There is an example here.

Ray_Portugal · ‎May 2, 2017

Hey Peter,

I’m receiving an “Uh oh! Insufficient scopes were provided. Please contact
the integrator” message. Here are the steps I completed that produced this
message. Please advise. Seems I’m getting closer.

Ray

  I checked off “Contacts” and “Workflows” as my Scopes.

  I added the Client ID and Scopes to this URL.

https://app.hubspot.com/oauth/2999917/authorize?client_id=1655c903-6e0d-4d7d-84c6-b2007f81eb93&scope...

  I received the “Uh oh! Insufficient scopes were provided. Please

contact the integrator message

3PETE · ‎May 2, 2017

@Ray_Portugal

You need to fix the joining character between contacts and workflows

here is an ex. from the docs. Notice that contacts and automation are separated by an %20 and not an &

https://app.hubspot.com/oauth/authorize?client_id=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx&scope=contact...

Ray_Portugal · ‎May 15, 2017

Hey Peter,

I put in the %20 and I’m getting this message now:

Uh oh! You are missing a necessary parameter

The follow parameter is missing and is needed to continue with the
integration process:

Redirect_uri

Here is my updated URL:

https://app.hubspot.com/oauth/2999917/authorize?client_id=1655c903-6e0d-4d7d-84c6-b2007f81eb93&scope...

Ray_Portugal · ‎May 15, 2017

Hey Peter,

I put in & before the redirect_uri and received this message.

Uh oh!

An invalid scope name was provided.

3PETE · ‎May 15, 2017

@Ray_Portugal The workflows scope is called ‘automation’.

Please refer to the docs here.

Ray_Portugal · ‎May 15, 2017

I went through the instructions. I’m getting a message that I don’t have
the correct role to grant these permissions. I’m going to contact Hubspot
support to see if there is someone else who can assist me. You provide
vague instructions and are not very helpful.

APIs & Integrations