I am not able to fetch the primary company from the deal api

[SKumar00]

I am using Hubspot API and fetching data through Airbyte, for deals api, I can see that there are multiple companies id, how do I identify the which is primary company associated to that deal?

{

 "archived": false,

 "companies": [

   "19642076053",

   "19473581391",

   "19642076053"

 ],

 "contacts": [

   "20437202"

 ],

 "createdAt": "2024-02-08T03:51:49.123Z",

 "id": "18040077916",

 "line_items": [

   "28045840280"

 ],

 "properties": {

   "account_legal_name": null,

   "account_manager": null,

   "ace_opportunity_id_url": null,

   "activation": null,

   "activation_type": "One Time",

.......

}

 "updatedAt": "2025-04-17T09:14:31.024Z"

}

This is how receive data through Airbyte, but I can't identify which is primary company?

there is no associated fields also in this.

[SKumar00]

Thank you so much, I am able to get it.

[Jaycee_Lewis · Accepted solution]

Hey @SKumar00 👋 Welcome to our community! Thank you very much for your post. It may be worth checking with Airbyte on this question as well. I found their support forum here. 

Stepping outside the connector, we would get those labels, such as Primary, from making a request to the Associations API endpoints and the response will include the labels you are after. I am not sure how Airbyte handles this, as it is not listed in the documentation specifically. 

I'll add a quick example of what the response from the Associations API looks like so you know what to expect from it. 

I know this is not the answer you are after, and I want to share our available and documented options for meeting your goal.

Have fun testing! — Jaycee

[Jaycee_Lewis]

My example:

• I created a Deal
• Associated 4 companies with it, with one being the Primary
• Used the Deal ID to make a request to the Associations API 
• View the label “Primary”

Request

GET {{API URL}}/crm/v4/objects/0-3/36526838310/associations/0-2 

Response

{
    "results": [
        {
            "toObjectId": 10202231613,
            "associationTypes": [
                {
                    "category": "HUBSPOT_DEFINED",
                    "typeId": 5,
                    "label": "Primary"
                },
                {
                    "category": "HUBSPOT_DEFINED",
                    "typeId": 341,
                    "label": null
                }
            ]
        },
        {
            "toObjectId": 11685858563,
            "associationTypes": [
                {
                    "category": "HUBSPOT_DEFINED",
                    "typeId": 341,
                    "label": null
                }
            ]
        },
        {
            "toObjectId": 13861282304,
            "associationTypes": [
                {
                    "category": "HUBSPOT_DEFINED",
                    "typeId": 341,
                    "label": null
                }
            ]
        },
        {
            "toObjectId": 16053398365,
            "associationTypes": [
                {
                    "category": "HUBSPOT_DEFINED",
                    "typeId": 341,
                    "label": null
                }
            ]
        }
    ]
}

Best,

Jaycee