# Hubspot Owners v3 **URL:** \ **Category:** Matillion ETL\ **Created:** [March 27, 2025, 3:16pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118 "2025-03-27T15:16:16Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![roy.taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/roy.taylor/32/1112_2.png) [@roy.taylor](https://matillioncommunity.discourse.group/u/roy.taylor)\ **Post date:** [March 27, 2025, 3:16pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/1 "2025-03-27T15:16:16Z")
We are hitting an error while trying to hit the “owners” api on Hubspot via the in-built connector. Recently, Hubspot deprecated their v2. > **[Final Reminder: Sunset of v2 Owners API](https://developers.hubspot.com/changelog/final-reminder-sunset-of-v2-owners-api#:~:text=The%20v2%20Owners%20API%20will,feature%2Drich%20v3%20Owners%20API)** > > The v2 Owners API will officially be sunset on March 24th, 2025, with no further extensions. After this date, all v2 Owners API endpoints will be fully sunset and return a 404 error response. This marks the final stage of our transition to the more... Is there any plan to update the connector? Connector → Load → Hubspot Query There is only one option for “Owners” in the datasource field, and it is being rejected on their end as being deprecated. Any suggestions on how to proceed? ---
**Author:** ![Joe-Community-Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/joe-community-manager/32/897_2.png) [@Joe-Community-Manager](https://matillioncommunity.discourse.group/u/Joe-Community-Manager)\ **Post date:** [March 27, 2025, 3:57pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/2 "2025-03-27T15:57:08Z")
Hello @roy.taylor Welcome to the Matillion Community. its great to see you posting for the first time! Thanks for your question, to resolve this particular issue you will need to set a connection option with Schema=HUBSPOTV3 this will get it going again. If you need anything else, please don’t hesitate to ask. Kind regards, Joe ---
**Author:** ![roy.taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/roy.taylor/32/1112_2.png) [@roy.taylor](https://matillioncommunity.discourse.group/u/roy.taylor)\ **Post date:** [March 28, 2025, 5:40pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/3 "2025-03-28T17:40:08Z")
Thanks, that got us to the next error. Now trying to get the OAuth install working correctly with Hubspot with the new scope. ---
**Author:** ![roy.taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/roy.taylor/32/1112_2.png) [@roy.taylor](https://matillioncommunity.discourse.group/u/roy.taylor)\ **Post date:** [March 28, 2025, 9:27pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/4 "2025-03-28T21:27:50Z")
> This app hasn’t been granted all required scopes to make this call. Read more about required scopes here: [HubSpot Developer Documentation](https://developers.hubspot.com/scopes). One or more of the following scopes are required. Unfortunately I don’t know what basic scopes I need to add to be able to configure the data source. I was able to get OAuth happy for that “Authentication”…but I only wanted it for one small scope, but apparently that triggers an issue with the API. ---
**Author:** ![Joe-Community-Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/joe-community-manager/32/897_2.png) [@Joe-Community-Manager](https://matillioncommunity.discourse.group/u/Joe-Community-Manager)\ **Post date:** [March 31, 2025, 8:33am UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/5 "2025-03-31T08:33:33Z")
Oh no! Can you please confirm what scopes you currently have set up in your app? We can look into this and get it resolved @roy.taylor 🙂 Kind regards, Joe ---
**Author:** ![roy.taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/roy.taylor/32/1112_2.png) [@roy.taylor](https://matillioncommunity.discourse.group/u/roy.taylor)\ **Post date:** [March 31, 2025, 8:26pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/6 "2025-03-31T20:26:13Z")
Sure, I’m trying set up a new one to accommodate the changes for that Owners API v3 change. The app only has a couple set up. – - `crm.objects.owners.read` - `oauth` – I get this URL… > [https://matillion.bi.community.co/oauth\_redirect.html&scope=oauth%20crm.objects.owners.read](https://matillion.bi.community.co/oauth_redirect.html&scope=oauth%20crm.objects.owners.read) With the scope on there. When I authenticate with Matillion to this app, it gives me this URL… > [HubSpot OAuth](https://app.hubspot.com/oauth/authorize?redirect_uri=https%3A%2F%2Fmatillion.bi.community.co%2Foauth_redirect.html&scope=oauth+crm.objects.owners.read&state=XXXXXXXX&optional_scope=content+social+automation+files+forms+timeline+e-commerce+business-intelligence+integration-sync+tickets+sales-email-read+crm.objects.custom.read+crm.schemas.custom.read+crm.objects.feedback_submissions.read+crm.schemas.deals.read+crm.objects.owners.read+crm.objects.contacts.write+crm.objects.companies.write+crm.lists.write+crm.objects.companies.read+crm.lists.read+crm.objects.deals.read+crm.schemas.contacts.read+crm.objects.deals.write+crm.schemas.companies.read&client_id=xxxxxxxxxx&response_type=code) I’ve noticed if I edit out the “optional\_scope” from this URL, I can get it to authenticate. However…with that, I still get the error on the component. > This app hasn’t been granted all required scopes to make this call. Read more about required scopes here: [HubSpot Developer Documentation](https://developers.hubspot.com/scopes). One or more of the following scopes are required. ![image](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/2X/b/b96519820844636d5f99b172a93848eae9ff06a0.png) ---
**Author:** ![Joe-Community-Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/joe-community-manager/32/897_2.png) [@Joe-Community-Manager](https://matillioncommunity.discourse.group/u/Joe-Community-Manager)\ **Post date:** [April 1, 2025, 12:26pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/7 "2025-04-01T12:26:23Z")
Thanks @roy.taylor Let me take this away and speak to the team, I will be back soon. Kind regards, Joe ---
**Author:** ![Joe-Community-Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/joe-community-manager/32/897_2.png) [@Joe-Community-Manager](https://matillioncommunity.discourse.group/u/Joe-Community-Manager)\ **Post date:** [April 1, 2025, 1:44pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/8 "2025-04-01T13:44:15Z")
Hi @roy.taylor Can you confirm what version of Matillion ETL you are currently using for me, could you also please turn on auto debug and turn that to debug level 3 and send me a private message with the log file you get please? Our team can take a closer look at that for you. Kind regards, Joe ---
**Author:** ![roy.taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/roy.taylor/32/1112_2.png) [@roy.taylor](https://matillioncommunity.discourse.group/u/roy.taylor)\ **Post date:** [April 1, 2025, 8:55pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/9 "2025-04-01T20:55:10Z")
We are on… # Matillion ETL Version: 1.68.20 (build f08d3c2-270375) BTW…all the links to support and documentation are now 404 for us. I’ll see if I can get you logs soon. ---
**Author:** ![roy.taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/roy.taylor/32/1112_2.png) [@roy.taylor](https://matillioncommunity.discourse.group/u/roy.taylor)\ **Post date:** [April 1, 2025, 9:46pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/10 "2025-04-01T21:46:38Z")
## I was able to see the full error on the Hubspot Side. ## {“status”:“error”,“message”:“This app hasn’t been granted all required scopes to make this call. Read more about required scopes here: [https://developers.hubspot.com/scopes.",“correlationId”:“aae2df67-39bc-4503-91a3-f2a2af597d3e”,“errors”:[{“message”:"One](https://developers.hubspot.com/scopes.%22,%22correlationId%22:%22aae2df67-39bc-4503-91a3-f2a2af597d3e%22,%22errors%22:%5B%7B%22message%22:%22One) or more of the following scopes are required.”,“context”:{“requiredGranularScopes”:[“crm.objects.custom.read”,“crm.schemas.custom.read”]}}],“links”:{“scopes”:“[https://developers.hubspot.com/scopes"},“category”:"MISSING\_SCOPES](https://developers.hubspot.com/scopes%22%7D,%22category%22:%22MISSING_SCOPES)”} So I tried adding those scopes… ![image](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/2X/9/98a8941c0b4ab178bb97751f7d83bde9817c5fc6.png) And added them to the app in Hubspot…but I’m still getting the scope mismatch (it’s still trying to add in the optional scopes or something??) when trying to authenticate. ---
**Author:** ![Joe-Community-Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/joe-community-manager/32/897_2.png) [@Joe-Community-Manager](https://matillioncommunity.discourse.group/u/Joe-Community-Manager)\ **Post date:** [April 2, 2025, 10:02am UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/11 "2025-04-02T10:02:08Z")
Thanks @roy.taylor My colleague has had a look at that and has been able to replicate this, the solution would be to specify an OauthOptionalScopes when configuring the OAuth as they have done here: ![image](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/2X/f/f544dedf5bb71ccfd3592df1527a0fb5b0e7f566.png) I hope this helps, please keep me posted. Kind regards, Joe ---
**Author:** ![roy.taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/roy.taylor/32/1112_2.png) [@roy.taylor](https://matillioncommunity.discourse.group/u/roy.taylor)\ **Post date:** [April 4, 2025, 4:41pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/12 "2025-04-04T16:41:44Z")
Still failing. And it won’t tell me which ones. When I add _all_ the ones that Matillion adds to the “Authorization” link, it also fails with a different message. ![image](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/2X/9/9b42081c55da9fbdd2ab1bea25dab303d6ee46ce.png) ---
**Author:** ![roy.taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/roy.taylor/32/1112_2.png) [@roy.taylor](https://matillioncommunity.discourse.group/u/roy.taylor)\ **Post date:** [April 4, 2025, 4:47pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/13 "2025-04-04T16:47:55Z")
I got it auth in Hubspot…then came back to Matillion and got this error \_- Authorization failed with redirect url of: [https://matillion.bi.community.co/oauth\_redirect.html?code=na1-94f9-70e6-4d71-87ae-1e10ed7b156a&state=47875185](https://matillion.bi.community.co/oauth_redirect.html?code=na1-94f9-70e6-4d71-87ae-1e10ed7b156a&state=47875185) ## Message:Error creating settings file: This app hasn’t been granted all required scopes to make this call. Read more about required scopes here: [Working with OAuth - HubSpot docs](https://developers.hubspot.com/scopes). One or more of the following scopes are required. This cuts off the message part of the error, which lists out the scopes it thinks it wants. ## – {“status”:“error”,“message”:“This app hasn’t been granted all required scopes to make this call. Read more about required scopes here: [https://developers.hubspot.com/scopes.",“correlationId”:“6e747701-b0f5-48dd-b197-821af1aa9275”,“errors”:[{“message”:"One](https://developers.hubspot.com/scopes.%22,%22correlationId%22:%226e747701-b0f5-48dd-b197-821af1aa9275%22,%22errors%22:%5B%7B%22message%22:%22One) or more of the following scopes are required.”,“context”:{“requiredGranularScopes”:[“crm.objects.custom.read”,“crm.schemas.custom.read”]}}],“links”:{“scopes”:“[https://developers.hubspot.com/scopes"},“category”:"MISSING\_SCOPES](https://developers.hubspot.com/scopes%22%7D,%22category%22:%22MISSING_SCOPES)”} I have both of these scopes already. ![image](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/2X/0/0c619908ae9f91e787fcae658411ec0af2a83bd3.png) ---
**Author:** ![roy.taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/roy.taylor/32/1112_2.png) [@roy.taylor](https://matillioncommunity.discourse.group/u/roy.taylor)\ **Post date:** [April 4, 2025, 4:50pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/14 "2025-04-04T16:50:34Z")
I can see the attempted call on the Hubspot side. But it’s saying the scopes are still wrong. ![image](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/2X/7/70f47cd9bf8fb5626dedb91bb0454d3c1ef3065f.png) ---
**Author:** ![roy.taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/roy.taylor/32/1112_2.png) [@roy.taylor](https://matillioncommunity.discourse.group/u/roy.taylor)\ **Post date:** [April 7, 2025, 3:18pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/15 "2025-04-07T15:18:26Z")
> “This oauth-token (CLaqsoD) does not have proper permissions! (requires all of [users-read])”,“correlationId”:" I’m down to this error in the logs. It’s odd. because I am seeing some success in the API call, but the whole things is failing. I can send the logs via DM. ---
**Author:** ![ClaireSeniorCommunityManager](https://avatars.discourse-cdn.com/v4/letter/c/7ba0ec/32.png) [@ClaireSeniorCommunityManager](https://matillioncommunity.discourse.group/u/ClaireSeniorCommunityManager)\ **Post date:** [April 7, 2025, 3:33pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/16 "2025-04-07T15:33:23Z")
Hi @roy.taylor, thanks so much for sending through that further information. If you do have logs, please feel free to DM them to myself or @Joe-Community-Manager and we can take those to the team. Thanks so much, Claire ---
**Author:** ![roy.taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/roy.taylor/32/1112_2.png) [@roy.taylor](https://matillioncommunity.discourse.group/u/roy.taylor)\ **Post date:** [April 10, 2025, 4:00pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/17 "2025-04-10T16:00:28Z")
Let me write up my latest findings here today. The issue I’m seeing now is that it doesn’t seem to “remember” the Schema call. Is it recommended to put the Schema=HUBSPOTV3 when creating the OAuth connection, or should it be used on the component itself? Both? It seems to break it one way, and then it ignores it the other way. ---
**Author:** ![Joe-Community-Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/joe-community-manager/32/897_2.png) [@Joe-Community-Manager](https://matillioncommunity.discourse.group/u/Joe-Community-Manager)\ **Post date:** [April 11, 2025, 8:00am UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/18 "2025-04-11T08:00:05Z")
Thanks @roy.taylor The schema connection option should not be used when creating the OAuth, it should only be used in the component itself. Happy to get the team to look at your log files if this does not resolve the issue. Kind regards, Joe ---
**Author:** ![roy.taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/roy.taylor/32/1112_2.png) [@roy.taylor](https://matillioncommunity.discourse.group/u/roy.taylor)\ **Post date:** [April 11, 2025, 3:49pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/19 "2025-04-11T15:49:23Z")
It won’t validate when I do that. ![image](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/2X/2/2284013bb73fe3256da68bea6a35534c4e0ef6e6.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/2X/3/338b4d47b2c66445c99ecb299bec3d6e92acb548.png) So I can see in Hubspot that the call the schemas is valid when configuring it, but trying to get sample data or actually running it fails. ---
**Author:** ![roy.taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/roy.taylor/32/1112_2.png) [@roy.taylor](https://matillioncommunity.discourse.group/u/roy.taylor)\ **Post date:** [April 11, 2025, 3:52pm UTC](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118/20 "2025-04-11T15:52:53Z")
On the Hubspot side… ![image](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/2X/1/1da86e29866bd4f23ded838b7510994901086c9e.png) The green are configuring it…but then it tries to call (for the sample) and uses the old one. [Next page](https://matillioncommunity.discourse.group/t/hubspot-owners-v3/3118.md?page=2)