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.
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.
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?)
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.
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.
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).
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.
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.
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.
@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
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 thescope= 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?
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.
@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.
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.
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.
