# Creating many to many associations between custom objects

**URL:** <https://community.hubspot.com/t/creating-many-to-many-associations-between-custom-objects/119962>\
**Category:** APIs & Integrations\
**Tags:** python, workflows, object, contacts\
**Created:** [November 6, 2024, 9:00pm UTC](https://community.hubspot.com/t/creating-many-to-many-associations-between-custom-objects/119962 "2024-11-06T21:00:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![AHarvey11](https://avatars.discourse-cdn.com/v4/letter/a/6a8cbe/32.png) [@AHarvey11](https://community.hubspot.com/u/AHarvey11)\
**Post date:** [November 6, 2024, 9:00pm UTC](https://community.hubspot.com/t/creating-many-to-many-associations-between-custom-objects/119962/1 "2024-11-06T21:00:32Z")

</div>

Hello,

I am currently on an enterprise account and struggling to find a good solution to the following request from a client:

I have a custom object named “individuals” that can associate with many records in another custom object named “members” and deals. I would like to link these and create association labels from a file that lists the unique individual ID, unique member ID, and unique account ID (that is put into the deal) and their association.

I have tried using pandas with the Hubspot API to get this to work and was not having a lot of success, and workflows seem to not be working as intended either. Does anyone have any recommendations for going about this via code or a middleware solution?

Thank you!

---

<div class="post-metadata">

**Author:** ![zach\_threadint](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/zach_threadint/32/46318_2.png) [@zach\_threadint](https://community.hubspot.com/u/zach_threadint)\
**Post date:** [November 7, 2024, 12:31am UTC](https://community.hubspot.com/t/creating-many-to-many-associations-between-custom-objects/119962/2 "2024-11-07T00:31:41Z")

</div>

Hi @AHarvey11 👋

I think you should be able to achieve this via HubSpot’s Import feature. See the following HubSpot Knowledge Base Docs:

1. [Import records and activities](https://knowledge.hubspot.com/import-and-export/import-objects)
2. [Set up your import files](https://knowledge.hubspot.com/import-and-export/set-up-your-import-file)

Your import source CSV file might have the following headers:

- individual record id
- member record id
- association label (use the internal API name for the relevant label)
- _any other properties you’d like to populate for individual/members at the same time_

You’d then go through HubSpot’s Import process -- make sure to select the option relating to only updating existing records.

I hope that proves helpful. Please let me know if you have any follow-up questions.

---

<div class="post-metadata">

**Author:** ![AHarvey11](https://avatars.discourse-cdn.com/v4/letter/a/6a8cbe/32.png) [@AHarvey11](https://community.hubspot.com/u/AHarvey11)\
**Post date:** [November 7, 2024, 2:41am UTC](https://community.hubspot.com/t/creating-many-to-many-associations-between-custom-objects/119962/3 "2024-11-07T02:41:34Z")

</div>

Hi Zack,  
Yes we can do that but I need something that will be automatically done as  
these will be daily uploads.

---

<div class="post-metadata">

**Author:** ![zach\_threadint](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/zach_threadint/32/46318_2.png) [@zach\_threadint](https://community.hubspot.com/u/zach_threadint)\
**Post date:** [November 7, 2024, 8:26am UTC](https://community.hubspot.com/t/creating-many-to-many-associations-between-custom-objects/119962/4 "2024-11-07T08:26:54Z")

</div>

Thanks for clarifying @AHarvey11

How are you envisaging the creation of these daily files? If this will be a manual job, then I still think the HubSpot Import feature could do the job (you can define associations, including custom association labels, between records as part of an import).