| Feature | Supported? |
|---|---|
| Full Refresh Sync | Yes |
| Incremental Sync | Yes |
| Replicate Incremental Deletes | No |
| SSL connection | Yes |
Check out common troubleshooting issues for the HubSpot connector on our Discourse here.
This source is capable of syncing the following tables and their data:
- Campaigns
- Companies (Incremental)
- Contact Lists (Incremental)
- Contacts (Incremental)
- Deal Pipelines
- Deals (including Contact associations) (Incremental)
- Email Events (Incremental)
- Engagements
- Forms
- Line Items (Incremental)
- Marketing Emails
- Owners
- Products (Incremental)
- Quotes (Incremental)
- Subscription Changes (Incremental)
- Tickets (Incremental)
- Workflows
Note: HubSpot API currently only supports quotes endpoint using API Key, using Oauth it is impossible to access this stream (as reported by community.hubspot.com).
- HubSpot Account
- Api credentials
- If using Oauth, scopes enabled for the streams you want to sync
{% hint style="info" %} HubSpot's API will rate limit the amount of records you can sync daily, so make sure that you are on the appropriate plan if you are planning on syncing more than 250,000 records per day. {% endhint %}
This connector supports only authentication with API Key. To obtain API key for the account go to settings -> integrations (under the account banner) -> api key. If you already have an api key you can use that. Otherwise generated a new one. See docs for more details.
The connector is restricted by normal HubSpot rate limitations.
When connector reads the stream using API Key that doesn't have neccessary permissions to read particular stream, like workflows, which requires to be enabled in order to be processed, the log message returned to the output and sync operation goes on with other streams available.
Example of the output message when trying to read workflows stream with missing permissions for the API Key:
{
"type": "LOG",
"log": {
"level": "WARN",
"message": 'Stream `workflows` cannot be procced. This hapikey (EXAMPLE_API_KEY) does not have proper permissions! (requires any of [automation-access])'
}
}
If you are using Oauth, most of the streams require the appropriate scopes enabled for the API account.
| Stream | Required Scope |
|---|---|
campaigns |
content |
companies |
contacts |
contact_lists |
contacts |
contacts |
contacts |
deal_pipelines |
either the contacts scope (to fetch deals pipelines) or the tickets scope. |
deals |
contacts |
email_events |
content |
engagements |
contacts |
forms |
forms |
line_items |
e-commerce |
owners |
contacts |
products |
e-commerce |
quotes |
no scope required |
subscription_changes |
content |
tickets |
tickets |
workflows |
automation |
| Version | Date | Pull Request | Subject |
|---|---|---|---|
| 0.1.29 | 2021-12-17 | 8699 | Add incremental sync support for companies, contact_lists, contacts, deals, line_items, products, quotes, tickets streams |
| 0.1.28 | 2021-12-15 | 8429 | Update fields and descriptions |
| 0.1.27 | 2021-12-09 | 8658 | Fixed config backward compatibility issue by allowing additional properties in the spec |
| 0.1.26 | 2021-11-30 | 8329 | Removed 'skip_dynamic_fields' config param |
| 0.1.25 | 2021-11-23 | 8216 | Add skip dynamic fields for testing only |
| 0.1.24 | 2021-11-09 | 7683 | Fix name issue 'Hubspot' -> 'HubSpot' |
| 0.1.23 | 2021-11-08 | 7730 | Fix oAuth flow schema |
| 0.1.22 | 2021-11-03 | 7562 | Migrate Hubspot source to CDK structure |
| 0.1.21 | 2021-10-27 | 7405 | Change of package import from urllib to urllib.parse |
| 0.1.20 | 2021-10-26 | 7393 | Hotfix for split_properties function, add the length of separator symbol ,(%2C in HTTP format) to the checking of the summary URL length |
| 0.1.19 | 2021-10-26 | 6954 | Fix issue with getting 414 HTTP error for streams |
| 0.1.18 | 2021-10-18 | 5840 | Add new marketing emails (with statistics) stream |
| 0.1.17 | 2021-10-14 | 6995 | Update discover method: disable quotes stream when using OAuth config |
| 0.1.16 | 2021-09-27 | 6465 | Implement OAuth support. Use CDK authenticator instead of connector specific authenticator |
| 0.1.15 | 2021-09-23 | 6374 | Use correct schema for owners stream |
| 0.1.14 | 2021-09-08 | 5693 | Include deal_to_contact association when pulling deal stream and include contact ID in contact stream |
| 0.1.13 | 2021-09-08 | 5834 | Fixed array fields without items property in schema |
| 0.1.12 | 2021-09-02 | 5798 | Treat empty string values as None for field with format to fix normalization errors |
| 0.1.11 | 2021-08-26 | 5685 | Remove all date-time format from schemas |
| 0.1.10 | 2021-08-17 | 5463 | Fix fail on reading stream using API Key without required permissions |
| 0.1.9 | 2021-08-11 | 5334 | Fix empty strings inside float datatype |
| 0.1.8 | 2021-08-06 | 5250 | Fix issue with printing exceptions |
| 0.1.7 | 2021-07-27 | 4913 | Update fields schema |