hubspot-v1.md

title	permalink	keywords	summary	layout	input	key	name	display_name	singer	repo-url	this-version	api	certified	historical	frequency	tier	status-url	api-type	table-selection	column-selection	anchor-scheduling	cron-scheduling	extraction-logs	loading-reports	feature-summary	requirements-list	requirements-info	setup-steps	schema-sections
HubSpot (v1)	/integrations/saas/hubspot/v1	hubspot, integration, schema, etl hubspot, hubspot etl	Connection instructions and schema details for Stitch's HubSpot integration.	singer	false	hubspot-setup	hubspot	HubSpot	true	https://github.com/singer-io/tap-hubspot	1	[{{ integration.display_name }} REST API](https://developers.hubspot.com/docs/overview){:target="new"}	true	30 days	30 minutes	Standard	https://status.hubspot.com/	platform.hubspot	true	false	true	false	true	true	Stitch's {{ integration.display_name }} integration replicates data using the {{ integration.api | flatify | strip }}. Refer to the [Schema](#schema) section for a list of objects available for replication.	item **For HubSpot CRM or Marketing products:** Administrator permissions in HubSpot item **For the HubSpot Sales product:** Sales Administrator permissions in HubSpot	More information about HubSpot user roles and permissions can be found in [HubSpot's documentation](https://knowledge.hubspot.com/articles/kcs_article/settings/hubspot-user-roles-guide){:target="new"}.	title anchor content Add {{ integration.display_name }} as a Stitch data source add-stitch-data-source {% include integrations/shared-setup/connection-setup.html %} title anchor content Define the historical replication start date define-historical-sync {% include integrations/saas/setup/historical-sync.html %} title anchor content Create a replication schedule define-rep-frequency {% include integrations/shared-setup/replication-frequency.html %} title anchor content Authorize Stitch to Access HubSpot grant-stitch-authorization 1. Next, you'll be prompted to sign into your HubSpot account. 2. After you log into HubSpot, a screen with a list of your HubSpot accounts will display. Click the account you want to connect to Stitch. **Note that Stitch will only ever read your data**. Stitch will never modify or delete any data in your HubSpot account. 3. After the authorization process is successfully completed, you'll be directed back to Stitch. 4. Click {{ app.buttons.finish-int-setup }}. title anchor content Set objects to replicate setting-data-to-replicate {% include integrations/shared-setup/data-selection/object-selection.html %}	title anchor content Custom HubSpot Field Replication custom-field-replication Custom object properties, or fields, are supported by Stitch's {{ integration.display_name }} integration. Stitch will query the `properties` list for each object and, if custom fields are available through {{ integration.display_name }}'s API, replicate them to your destination. This is applicable to any object that supports custom fields in {{ integration.display_name }}. title anchor content HubSpot Date/DateTime Values & UNIX Timestamps datetime-unix-timestamps [{{ integration.display_name }} uses UNIX-formatted timestamps in milliseconds](https://developers.hubspot.com/docs/faq/how-should-timestamps-be-formatted-for-hubspots-apis){:target="new"} to store `date` and `datetime` data. Stitch doesn't perform any transformation during the replication process, meaning these values won't be converted to timestamps before they're loaded into your destination. To account for this, consider creating a user-defined function to perform the conversion or building views on top of the raw data.

{% assign integration = page %} {% include misc/data-files.html %}