https://community.hubspot.com/t5/APIs-Integrations/Associations-when-importing-multiple-files-from-the-API/m-p/687446#M56491 <P>Hello&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/127074">@Jaycee_Lewis</a>&nbsp;&nbsp;and&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/422694">@Otaka</a>,&nbsp;</P> <P>&nbsp;</P> <P>So&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/422694">@Otaka</a>&nbsp; I think your JSON needs to be updated by mentioning the <STRONG>idColumnType as <STRONG>HUBSPOT_ALTERNATE_ID and <STRONG>columnObjectTypeId&nbsp;as '0-1' as it's the email of the contact.</STRONG></STRONG></STRONG></P> <P>&nbsp;</P> <P>So the updated email column of the deal file will look like this -</P> <P>&nbsp;</P> <PRE class="" data-block-id="block-f6542ed7-31f6-4886-bdf1-1e1fcc8ec844" data-language="plain">{"ignored": false,"columnObjectTypeId": "0-1","columnName": "email","propertyName": null,"idColumnType": 'HUBSPOT_ALTERNATE_ID',"foreignKeyType": {"associationCategory": "HUBSPOT_DEFINED","associationTypeId": 4},"associationIdentifiedColumn": false}&nbsp;&nbsp;</PRE> <P>&nbsp;</P> <P>Regards,</P> <P>&nbsp;</P> Wed, 31 Aug 2022 10:40:03 GMT himanshurauthan 2022-08-31T10:40:03Z