topic Re: CozyRoc REST Source Failure in APIs & Integrations

CozyRoc REST Source Failure

Tunde — Sun, 03 Mar 2019 11:23:38 GMT

Hello Gurus,

I am having issues connecting to the hubspot api using the cozyroc + ssis application.

I created an app in my hubspot (developer) account and have checked the scope (Basic OAuth Functionality) and contacts as the read and write. This matches with what is in the SSIS package as well but I get the error:

Request for Integration Permissions

Couldn't complete the connection

Insufficient scopes were provided. Please contact the integrator.

What am I doing wrong or not doing at all please?

Kind Regards,

Tunde

Re: CozyRoc REST Source Failure

JasminLin — Mon, 04 Mar 2019 08:41:51 GMT

Hi @Tunde . did you manage to go through our documentation on Scopes here https://developers.hubspot.com/docs/methods/oauth2/initiate-oauth-integration#scopes ?

Are you testing the authorization on a developer portal? A developer portal does not have access to any scopes so you should be testing on a test portal.

Re: CozyRoc REST Source Failure

Tunde — Mon, 04 Mar 2019 09:32:14 GMT

Hello JasminLin,

Yes, I have read the scopes. What do you mean by the developer account doesn't have access to scopes? Would the test portal be able to pull contacts (data) from another portal (that I have access to?)

Cheers

Re: CozyRoc REST Source Failure

JasminLin — Tue, 05 Mar 2019 06:12:25 GMT

Yes if you have another portal that is not a developer portal, that would work too.

I looked further into what would cause the error message you are seeing, and found that the error (Insufficient Scopes were provided. Please contact the integrator.) occurs when the scopes requested in the authorization URL don’t match up with the scopes checked off in the app’s settings.

Check in your app’s settings and uncheck/check scopes to match what you’re requesting in the authorization URL. Make sure your authorization URL matches the scopes that you have checked off in your app settings.

Re: CozyRoc REST Source Failure

Tunde — Tue, 05 Mar 2019 08:02:54 GMT

Hello JasminLin,

The scopes match in both. See attached. Can you please let me know the scopes I have access to based on our account/portalID? Seems I might not be able to pull data across all scopes.

It would be nice if you can let me know the scopes I should select for it to run. I have tried only the conatcts and the basic oauth but it still didn't work.

Please help check it.

Thanks

Re: CozyRoc REST Source Failure

JasminLin — Tue, 05 Mar 2019 08:15:02 GMT

Hi @Tunde , is the portal you are trying to install the app on 5550685 as shown in your screenshot? If so, this portal is a developer portal and so it does not have access to any scopes and cannot be authorized with an app (also stated in the doc here). You can only use authorization on test portals or non-developer portals.

If it is a non-developer portal that you are trying to install the app on and you're seeing the same error, please provide me the portal ID, and the full authorization URL you are using (exclude your client_id value in the params).

Re: CozyRoc REST Source Failure

Tunde — Tue, 05 Mar 2019 09:15:11 GMT

Thanks for this JasminLin. I tried with other portals - 383440 (the main portal) and 5551105 (the test environment) but still got the same error.

I am attaching the screens as it comes up in cozyroc - the thirdparty I'm trying to use in SSIS. There is no where it asks for an authorization URL.

Your documentation isn't straighforward. I have gone through loads and I'm no wiser.

Re: CozyRoc REST Source Failure

JasminLin — Wed, 06 Mar 2019 06:46:20 GMT

Hey @Tunde , from the screenshots in the external app Cozyroc I'm not able to tell for sure since we do not know how their app is using the field inputs to do the authorization or construct the authorization URL.

With one specific example of a connection you're trying to make, if you could send me the portal ID and the authorization URL COZYROC is using e.g.

https://app.hubspot.com/oauth/authorize/?client_id=client_id&redirect_uri=https%3A%2F%2F%2Foauth_redirect.html%3Fstate%3D23575&scope=contacts%20forms%20content)

I can look into it further. For example in Cozyroc's documentation here in Wizard Step Two screenshot, you can see the authorization URL in the address bar.

Re: CozyRoc REST Source Failure

Tunde — Wed, 06 Mar 2019 07:51:08 GMT

Hi @JasminLin ,

Find attached both screens from the login to the after login. I have also contacted cozyroc and was told that I should contact hubspot.

Cheers,

Tunde

Re: CozyRoc REST Source Failure

JasminLin — Wed, 06 Mar 2019 08:28:04 GMT

Hi @Tunde , sorry I should have been clearer previously, I would actually need the whole URL. The image does not display it in full.

Re: CozyRoc REST Source Failure

Tunde — Wed, 06 Mar 2019 08:40:39 GMT

https://app.hubspot.com/feedback-web-ui?portalId=53&pageUrl=https%3A%2F%2Fapp.hubspot.com%2Flogin%2F%3FloginRedirectUrl%3Dhttps%253A%252F%252Fapp.hubspot.com%252Foauth%252F5551105%252Fauthorize%253Fclient_id%253D4b6a500b-826e-11e5-963c-e78f9b100c80%2526redirect_uri%253Dhttps%25253A%25252F%25252Fwww.cozyroc.com%25252Foauth_callback%25252F%2526scope%253Dcontacts%26loginPortalId%3D5551105&utk=f2dc99b32b066157099ecb57a67d549e

Re: CozyRoc REST Source Failure

JasminLin — Thu, 07 Mar 2019 02:22:58 GMT

Thank you. I have 2 things to point out:

From the URL, the client ID doesn't seem to match the client ID in your dev portal's app (5550685). Are you using an app from another dev portal?
Going back to one of my initial guesses, if you had scopes checked in the app that you didn't include in the authorization URL, you may see that insufficient scope error. For example if you had checked Contacts and Oauth, you need to include these 2 scopes at the minimum in the authorization URL.

I know your dev portal 5550685 has those 2 scopes checked, but you may want to verify if you are using that portal's app because the client ID does not seem to match from what I'm seeing.

Re: CozyRoc REST Source Failure

Tunde — Thu, 07 Mar 2019 04:24:25 GMT

@JasminLin thanks for the response. My dev app is what you quoted above but you said I should use the test app to connect even though the apps are created in the dev app. The test app is 5551105.

And the scopes chosen in cozyroc is as shown the screenshots sent earlier. Basic authorisation and contacts

Re: CozyRoc REST Source Failure

JasminLin — Thu, 07 Mar 2019 08:20:42 GMT

To clarify, the developer portal is where you create your app, and that is 5550685 for you. A developer portal does not have any scopes so you cannot test authorization on it. 5551105 is a test portal that is just like a normal portal, so it has scopes and you can test authorization on it.

If it is certain that the dev portal you are using is 5550685, then the only thing that jumps out to me is the scopes provided in the authorization URL. Any scopes that you have selected in the app settings are considered required scopes, so you’d need to include everything you have selected in the scope= parameter.

So in your app in 5550685, you have checked contacts and oauth, means you need to include contacts and oauth in your authorization URL. But according to the authorization URL that you provided, it only has a scope=contacts. I would expect this to throw out the insufficient scopes error.

Can you uncheck all scopes in your app settings and try again?

Re: CozyRoc REST Source Failure

Tunde — Thu, 07 Mar 2019 08:35:42 GMT

@JasminLin

I unchecked every scope and removed all scopes in the CozyRoc end and got an invalid scope name provided. I left all the scopes in cozyroc whilst all the scopes were unchecked in hubspot and I got the earlier error of insufficient scopes.

Find attached the invalid scope error.

Re: CozyRoc REST Source Failure

JasminLin — Thu, 07 Mar 2019 09:00:21 GMT

Hi @Tunde , you should not be removing all scopes in Cozyroc. You need at least one scope in the authorization URL.

So try this:

In your app settings have all scopes unchecked
And in Cozyroc add a scope for contacts

Re: CozyRoc REST Source Failure

Tunde — Thu, 07 Mar 2019 09:50:03 GMT

@JasminLin

I did that the last time as well and got the same insufficient scop error message. Find attached the screenshot of the message.

Thanks

Re: CozyRoc REST Source Failure

JasminLin — Thu, 07 Mar 2019 10:20:01 GMT

@Tunde Ok, I really think the issue is we are not looking at the correct app you are trying to authorize - which is the client_id that is being used in the authorization URL. As I mentioned previously, according to the Cozyroc authorization URL you provided, the client_id in the URL is 4b6axxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx. But the client_id of your app in developer portal 5550685 is edf2xxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx.

If I try to authorize using this URL https://app.hubspot.com/oauth/authorize?client_id=edf2xxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx&redirect_uri=https://www.cozyroc.com/oauth_callback/&scope=contacts it works for me. If I change the client_id to 4b6axxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx I'll get the insufficient scopes error.

The client_id is unique to each app in a developer portal. If you can find out from your team which developer portal's app you are using, you can have them uncheck the scopes in that portal's app settings. Or change your Cozyroc connection to use the client_id from your app in 5550685. I would not know specifically where in Cozyroc you can change the client_id, but that would be the direction to go now.

Re: CozyRoc REST Source Failure

Tunde — Thu, 07 Mar 2019 10:37:42 GMT

Thanks @JasminLin

I have contacted CozyRoc's Support with your suggestions. I'd let you know once I get some feedback.

Cheers

Re: CozyRoc REST Source Failure

Tunde — Sun, 10 Mar 2019 08:33:45 GMT

Hi @JasminLin

Got a feedback from CozyRoc to include all scopes in their add-on and tick all scopes in hubspot which I did. The outcome:

This worked for the test site: 5551105 and I could access the two contacts that I reckon comes by default with a test portal in HubSpot. It however, didn't work for the main portal with portalID - 383440 and came with a "Request for Integration Permissions" error. Is this an access error and if so, can you please let me know what access I need to be granted to get the data?

Also, if it has to do with the limited apps/tools we are currently subscribed to with Hubspot, please do let me know which scopes to include.

Please find attached the error message I got.

Many thanks for your continued support.

Cheers,

Tunde