Question 1

Which HubSpot objects accept writes?

Accepted Answer

Contacts, companies, deals, tickets, products, line items, activities, services and custom objects, according to what the connected account exposes. Static lists can also be destinations where list support is enabled, though dynamic lists cannot be. Invoices are read only.

Question 2

How does Polytomic decide which record to update?

Accepted Answer

You map a PostgreSQL field to a HubSpot property as the identity, and matching is exact equality. Any suitable property works, though HubSpot's own record ID is fastest for update only syncs. The most durable pattern for reverse ETL is to write a stable ID from your database into a unique custom HubSpot property and match on that instead of on email.

Question 3

Can Polytomic create a HubSpot property that does not exist?

Accepted Answer

No. Create the property in HubSpot first, refresh the connection schema, then map to it. This catches people out when they add a column in Postgres and expect the CRM side to follow automatically, so it is worth building the property first as a habit.

Question 4

How do associations work?

Accepted Answer

Relationship mappings resolve the associated record by its HubSpot record ID, a searchable property, or an eligible custom string or number property, then write the association with the correct type or label. The usual pattern is to sync companies first, then contacts using sync after, matched through a shared company ID that already exists in your database.

Question 5

What happens to rows HubSpot rejects?

Accepted Answer

They are logged individually while the rest continue, and the run completes with errors rather than stopping. Only if every write fails is the execution marked failed. You can download the record detail from sync history and retry once the data or mapping is fixed. Teams who try to wire Postgres straight into the HubSpot API without reverse ETL usually end up rebuilding exactly this error handling.

Sync PostgreSQL to HubSpot

Sync PostgreSQL to HubSpot with Polytomic

Most of the CRM writable

Match on any property

Associations resolved

Or sync HubSpot to PostgreSQL

Trusted by businesses worldwide

Step-by-step integration guide

Connect PostgreSQL in Polytomic

Connect HubSpot in Polytomic

Create a sync between PostgreSQL and HubSpot

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect PostgreSQL with HubSpot?