APIs & Integrations

jwillson
Member

Bulk Import CRM Associations

SOLVE

Hi there,

 

I am looking to create associations between Contacts and Companies using the Bulk Import API 

crm/v3/imports

I am creating the association based on a common column header in a Company.xlsx file and a Client.xlsx file. 

The common column being used is the Company ID field.

This process imports and works fine, until I set the ignore property to true for the Company ID column mapping in the Client.xlsx file import json which contains the properties set for foreignKeyType.

Ideally I need to be able to ignore the column so it doesnt set that property for the contact but still use it to make the correct association, which is possible if importing manually. 

Any help on achieving this is much appreciated. 

Joe. 

0 Upvotes
1 Accepted solution
jwillson
Solution
Member

Bulk Import CRM Associations

SOLVE

Okay I seem to be able to achieve the result I want by leaving the ignore field as false, but setting the propertyName field to null.

View solution in original post

1 Reply 1
jwillson
Solution
Member

Bulk Import CRM Associations

SOLVE

Okay I seem to be able to achieve the result I want by leaving the ignore field as false, but setting the propertyName field to null.