SQL examples for SQL Server

The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with Hubspot.

• Bulk create contacts using SQL Server data
• Bulk delete contacts using IDs from SQL Server
• Bulk update contacts using SQL Server data
• Delete a contact
• Get a contact by ID
• Get contacts by email (search)
• Insert a contact
• List companies
• List contacts
• List deals
• List line items
• List owners
• List products
• List quotes
• List tickets
• Query companies with search API (generic request)
• Update a contact
• Upload a file (generic request)