Primary-Foreign Key relationships?

MEvans89 · ‎Jan 26, 2024

Do you have a doc that outlines the primary-foreign key relationships between your various tables?

Jaycee_Lewis · ‎Jan 29, 2024

Hi, @MEvans89 👋 Welcome to our community!

I don't have a specific document. Would you mind clarifying which HubSpot objects or data points you're looking to understand the relationships between? For example, are you focusing on contacts, companies, deals, or a specific integration or use case?

Best,

Jaycee

HubSpot’s AI-powered customer agent resolves up to 50% of customer queries instantly, with some customers reaching up to 90% resolution rates.
Learn More.

Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !

MEvans89 · ‎Jan 29, 2024

I exported several tables from HubSpot DB into Domo. I am trying to tie the
Contacts table to the All Companies table using SQL. Intuitively, I can't
find a field on which I can connect these two tables. For this purpose, I
am looking for a document or clues on what the primary and foreign key
relationships look like for HubSpot tables.

I currently have the following tables pulled into my Domo instance:
All Deals
Contacts
All Engagements
All Companies

I am currently trying to make sense of the data.

Regards,
Martin

APIs & Integrations