topic Primary-Foreign Key relationships? in APIs & Integrations

Primary-Foreign Key relationships?

MEvans89 — Fri, 26 Jan 2024 18:16:26 GMT

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

Re: Primary-Foreign Key relationships?

Jaycee_Lewis — Mon, 29 Jan 2024 18:07:52 GMT

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

Re: Primary-Foreign Key relationships?

MEvans89 — Mon, 29 Jan 2024 20:41:49 GMT

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