Hubspot Connector

Hubspot Connector

The high-performance Hubspot Connector provides read/write capabilities within your application, allowing you to perform numerous Hubspot operations with minimal coding or even no-coding at all. Integrate Hubspot data into applications such as SSIS, SQL Server, any ODBC-compatible application, or even directly within a programming language using this connector.

Download for SSIS Download for SQL Server and ODBC Documentation

Integrate Hubspot with these applications

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC applications

Actions supported by Hubspot Connector

Hubspot Connector supports following actions for REST API integration:

Archive Companies

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • Id

Output Fields

The following fields are returned after calling this action:

  • Status

Visit documentation for more information.

Archive Contacts

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • Id

Output Fields

The following fields are returned after calling this action:

  • Status

Visit documentation for more information.

Archive Deals

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • Id

Output Fields

The following fields are returned after calling this action:

  • Status

Visit documentation for more information.

Archive Line Items

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • Id

Output Fields

The following fields are returned after calling this action:

  • Status

Visit documentation for more information.

Archive Products

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • Id

Output Fields

The following fields are returned after calling this action:

  • Status

Visit documentation for more information.

Archive Quotes

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • Id

Output Fields

The following fields are returned after calling this action:

  • Status

Visit documentation for more information.

Archive Tickets

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • Id

Output Fields

The following fields are returned after calling this action:

  • Status

Visit documentation for more information.

Create Companies

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • [Dynamic Column]

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Create Contacts

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • [Dynamic Column]

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Create Deals

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • [Dynamic Column]

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Create Line Items

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • [Dynamic Column]

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Create Products

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • [Dynamic Column]

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Create Quotes

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • [Dynamic Column]

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Create Tickets

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • [Dynamic Column]

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Get Companies

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Properties

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Get Company By ID

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Id
  • Properties

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Get Company Properties

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Name
  • Label
  • Type
  • IsHidden
  • FieldType
  • Description

Visit documentation for more information.

Get Contact By ID

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Id
  • Properties

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Get Contact Properties

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Name
  • Label
  • Type
  • IsHidden
  • FieldType
  • Description

Visit documentation for more information.

Get Contacts

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Properties

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Get Deal By ID

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Id
  • Properties

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Get Deal Properties

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Name
  • Label
  • Type
  • IsHidden
  • FieldType
  • Description

Visit documentation for more information.

Get Deals

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Properties

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Get Line Item By ID

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Id
  • Properties

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Get Line Item Properties

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Name
  • Label
  • Type
  • IsHidden
  • FieldType
  • Description

Visit documentation for more information.

Get Line Items

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Properties

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Get Owners

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • OwnerId

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • Email
  • FirstName
  • LastName
  • UserId

Visit documentation for more information.

Get Product By ID

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Id
  • Properties

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Get Product Properties

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Name
  • Label
  • Type
  • IsHidden
  • FieldType
  • Description

Visit documentation for more information.

Get Products

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Properties

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Get Quote By ID

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Id
  • Properties

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Get Quotes

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Properties

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Get Quotes Properties

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Name
  • Label
  • Type
  • IsHidden
  • FieldType
  • Description

Visit documentation for more information.

Get Ticket By ID

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Id
  • Properties

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Get Tickets

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Properties

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Get Tickets Properties

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Name
  • Label
  • Type
  • IsHidden
  • FieldType
  • Description

Visit documentation for more information.

Search Companies

Description

Search companies using one or more filter conditions. Choose properties to include in the output.

Parameters

You can provide the following parameters to this action:

  • Properties
  • SearchFilters

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Search Contacts

Description

Search contacts using one or more filter conditions. Choose properties to include in the output.

Parameters

You can provide the following parameters to this action:

  • Properties
  • SearchFilters

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Search Deals

Description

Search deals using one or more filter conditions. Choose properties to include in the output.

Parameters

You can provide the following parameters to this action:

  • Properties
  • SearchFilters

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Search LineItems

Description

Search LineItems using one or more filter conditions. Choose properties to include in the output.

Parameters

You can provide the following parameters to this action:

  • Properties
  • SearchFilters

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Search Products

Description

Search products using one or more filter conditions. Choose properties to include in the output.

Parameters

You can provide the following parameters to this action:

  • Properties
  • SearchFilters

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Search Quotes

Description

Search Quotes using one or more filter conditions. Choose properties to include in the output.

Parameters

You can provide the following parameters to this action:

  • Properties
  • SearchFilters

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Search Tickets

Description

Search tickets using one or more filter conditions. Choose properties to include in the output.

Parameters

You can provide the following parameters to this action:

  • Properties
  • SearchFilters

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • IsArchived
  • CreatedAt
  • UpdatedAt
  • [Dynamic Column]

Visit documentation for more information.

Update Companies

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • Id
  • [Dynamic Column]

Output Fields

The following fields are returned after calling this action:

  • Id
  • CreatedAt
  • UpdatedAt
  • IsArchived
  • [Dynamic Column]

Visit documentation for more information.

Update Contacts

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • Id
  • [Dynamic Column]

Output Fields

The following fields are returned after calling this action:

  • Id
  • CreatedAt
  • UpdatedAt
  • IsArchived
  • [Dynamic Column]

Visit documentation for more information.

Update Deals

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • Id
  • [Dynamic Column]

Output Fields

The following fields are returned after calling this action:

  • Id
  • CreatedAt
  • UpdatedAt
  • IsArchived
  • [Dynamic Column]

Visit documentation for more information.

Update Line items

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • Id
  • [Dynamic Column]

Output Fields

The following fields are returned after calling this action:

  • Id
  • CreatedAt
  • UpdatedAt
  • IsArchived
  • [Dynamic Column]

Visit documentation for more information.

Update Products

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • Id
  • [Dynamic Column]

Output Fields

The following fields are returned after calling this action:

  • Id
  • CreatedAt
  • UpdatedAt
  • IsArchived
  • [Dynamic Column]

Visit documentation for more information.

Update Quotes

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • Id
  • [Dynamic Column]

Output Fields

The following fields are returned after calling this action:

  • Id
  • CreatedAt
  • UpdatedAt
  • IsArchived
  • [Dynamic Column]

Visit documentation for more information.

Update Tickets

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • Id
  • [Dynamic Column]

Output Fields

The following fields are returned after calling this action:

  • Id
  • CreatedAt
  • UpdatedAt
  • IsArchived
  • [Dynamic Column]

Visit documentation for more information.

Upload File from Local Disk

Description

Uploads local file to Hubspot CRM. This API requires files permission for the App (see scopes).

Parameters

You can provide the following parameters to this action:

  • Source File Path
  • Target Folder Path
  • AccessType
  • Overwrite
  • DuplicateValidationStrategy
  • DuplicateValidationScope
  • Target File Name (e.g. MyFile.xlsx)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • PortalId
  • Name
  • Size
  • Height
  • Width
  • Encoding
  • Type
  • Extension
  • CloudKey
  • S3Url
  • FriendlyUrl
  • AltKey
  • AltKeyHash
  • Title
  • MetaUrlScheme
  • MetaAllowsAnonymousAccess
  • MetaIndexable
  • Created
  • Updated
  • DeletedAt
  • FolderId
  • Hidden
  • CloudKeyHash
  • Archived
  • CreatedBy
  • DeletedBy
  • Replaceable
  • Url
  • AltUrl
  • CdnPurgeEmbargoTime
  • FileHash

Visit documentation for more information.

Make Generic API Request

Description

This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • Url
  • Body
  • IsMultiPart
  • Filter
  • Headers

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Make Generic API Request (Bulk Write)

Description

This is a generic endpoint for bulk write purpose. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • Url
  • IsMultiPart
  • Filter
  • Headers

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Download for SSIS Download for SQL Server and ODBC