HubSpot
HubSpot ETL connector for data replication
Features | Details |
Release Status | Released |
Source API Version | v2 |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | Hubspot apikey
Hubspot account email and password |
Replication Type | Full Replication
Key Based Replication |
Replication Key | Date |
Suggested Replication Frequency | 24 hrs |
Tables/APIs Supported | |
Contacts | Companies |
Tickets | Deals |
Products | |
- 1.Signin to Daton
- 2.Select hubspot from Integrations page
- 3.Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later.
- 4.provide your hubspot apikey.
- 5.Then provide your hubspot account email and Password,it shows up all the users you have. Select the user to authorize Daton to periodically extract data from hubspot.
- 6.Post successful authentication, you will be prompted to choose from the list of available tables
- 7.Then select all required fields for each table
- 8.Submit the integration.
- 1.Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
- 2.Users would be able to edit/pause/re-activate/delete integration anytime
- 3.Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Contacts
Purpose:For a given account, return all contacts that have been created in the account.
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
addedAt | INTEGER |
vid | INTEGER |
canonical-vid | INTEGER |
merged-vids | RECORD |
portal-id | NUMERIC |
is-contact | BOOLEAN |
profile-token | STRING |
profile-url | STRING |
properties | RECORD |
identity-profiles | RECORD |
Companies
Purpose:Used to get all of the companies in a account. Returns a paginated list of companies
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
portalId | NUMERIC |
companyId | NUMERIC |
isDeleted | BOOLEAN |
properties | RECORD |
Deals
Purpose:Get all of the deals in an account. Returns a paginated set of deals.
Replication: Key-Based Replication
Replication Key: properties
Fields
Name | Target Datatype |
portalId | NUMERIC |
dealId | NUMERIC |
isDeleted | BOOLEAN |
associations | RECORD |
properties | RECORD |
Tickets
Purpose:Get all tickets from a portal, up to 100 per request.
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
objectType | STRING |
portalId | NUMERIC |
objectId | NUMERIC |
properties | RECORD |
isDeleted | BOOLEAN |
Products
Purpose:Get all of the products in an account. Returns a paginated set of deals.
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
objectType | STRING |
portalId | INTEGER |
objectId | INTEGER |
properties | RECORD |
isDeleted | BOOLEAN |
Last modified 3yr ago