As a Sales Operations Director, I need to consume data from Hubspot in other tools as PowerBI, MDynamics, Quicksight, etc.
In the case of the User ID's I cannot use them to associate them to objects, forecast, results, ..., for applications like calculate commissions etc, since the ID's that appear related to Objects sucha as contacts, companies and deals are not User ID's but "hubspot_owner_ID".
Contact owner ID and company owner ID will be the same for each user, as well as for Deal owner. You can confirm the owner IDs here:
The problem is that this field customization menu is the only accesible and consumable way to get the hubspot_owner_id...since there is no way to download it, I need to go one by one manually. Which is a pain and far from satisfactory way to extract the data and warranty an errorless and seamless process.
Still do not understand why there is needed to have a User ID different than the Hubspot_Owner_ID. This adds to other lacks in usability like the deduplicate function that does not allow to import to remove duplicates, or to search and multiple select...and you have to go one by one instead.
Is there any other way to solve that and whan I export data to link for instance the user mail with the owner ID?
Adding my customer's use case to this Idea: it would be useful to be able to manually export a list of ownerIDs, instead of manually copying the values especially if they have many users in the portal. Thanks!
Big +1 for this - For our purposes, the "Portal ID" for users (which is currently exportable via the user settings view), is effectively meaningless when it comes to building external automation/reports/commission etc based on object ownership/relationship.
It would be extremely usable to have this exportable. Moreover, the current UI to view Owner ID is really clunky, making it a pain whenever we're onboarding/offboarding reps.
As a current workaround which you might find helpful @AGALifull:
- Generate a private API key with the users read permission
- Utilise a client like Insomnia to make API requests
I agree! The "Owner ID" should be the same as the "User ID" since it's literally pulling in from the user record.
This makes it especially hard for deactivated users. The company/contact owner property detail I see do NOT show deactivated users. I'm trying to create a calculated field off all owners and since 2 of my users are deactivated, I can't find their owner code. If the IDs were the same, I wouldn't have this issue, since I can see all user IDs in our user list, even after they're deactivated.
