Hubspot Connector
Documentation
Version: 6
Documentation
Hubspot Connector
Version: 6
Toggle navigation
Hubspot Connector
What's new
Authentication
Private app (Static Access Token)
Public app
Developer API key (Deprecated)
SSIS
Getting started
Reading data
Writing data
SQL Server
Getting started
Reading data
SQL examples
ODBC
Getting started
Reading data
SQL examples
Tables
Companies
Contacts
Deals
__DynamicRequest__
LineItems
Owners
Products
Quotes
Tickets
Endpoints
Archive Companies
Archive Contacts
Archive Deals
Archive Line Items
Archive Products
Archive Quotes
Archive Tickets
Create Companies
Create Contacts
Create Deals
Create Line Items
Create Products
Create Quotes
Create Tickets
Get Companies
Get Company By ID
Get Company Properties
Get Contact By ID
Get Contact Properties
Get Contacts
Get Deal By ID
Get Deal Properties
Get Deals
Get Line Item By ID
Get Line Item Properties
Get Line Items
Get Owners
Get Product By ID
Get Product Properties
Get Products
Get Quote By ID
Get Quotes
Get Quotes Properties
Get Ticket By ID
Get Tickets
Get Tickets Properties
Search Companies
Search Contacts
Search Deals
Search LineItems
Search Products
Search Quotes
Search Tickets
Update Companies
Update Contacts
Update Deals
Update Line items
Update Products
Update Quotes
Update Tickets
Upload File from Local Disk
Make Generic REST API Request
Make Generic REST API Request (Bulk Write)
Advanced topics
SQL functions
Placeholder functions
Stored procedures
Views
Metadata
SQL syntax
Integration
Applications & ETL tools
Programming languages
Connector file
Download
Source code
Custom connectors
Connector customization
Building your own connector
Discover
All connectors
Community
Hubspot Connector
What's new
Authentication
Private app (Static Access Token)
Public app
Developer API key (Deprecated)
SSIS
Getting started
Reading data
Writing data
SQL Server
Getting started
Reading data
SQL examples
ODBC
Getting started
Reading data
SQL examples
Tables
Companies
Contacts
Deals
__DynamicRequest__
LineItems
Owners
Products
Quotes
Tickets
Endpoints
Archive Companies
Archive Contacts
Archive Deals
Archive Line Items
Archive Products
Archive Quotes
Archive Tickets
Create Companies
Create Contacts
Create Deals
Create Line Items
Create Products
Create Quotes
Create Tickets
Get Companies
Get Company By ID
Get Company Properties
Get Contact By ID
Get Contact Properties
Get Contacts
Get Deal By ID
Get Deal Properties
Get Deals
Get Line Item By ID
Get Line Item Properties
Get Line Items
Get Owners
Get Product By ID
Get Product Properties
Get Products
Get Quote By ID
Get Quotes
Get Quotes Properties
Get Ticket By ID
Get Tickets
Get Tickets Properties
Search Companies
Search Contacts
Search Deals
Search LineItems
Search Products
Search Quotes
Search Tickets
Update Companies
Update Contacts
Update Deals
Update Line items
Update Products
Update Quotes
Update Tickets
Upload File from Local Disk
Make Generic REST API Request
Make Generic REST API Request (Bulk Write)
Advanced topics
SQL functions
Placeholder functions
Stored procedures
Views
Metadata
SQL syntax
Integration
Applications & ETL tools
Programming languages
Connector file
Download
Source code
Custom connectors
Connector customization
Building your own connector
Discover
All connectors
Community
Home
»
API Integration Hub
»
Hubspot Connector
»
Documentation
» ODBC »
SQL examples
» List owners
ODBC guide
List owners
Returns all owners (users) in the account.
SELECT * FROM Owners