Hello, I’m responsible for integrating a third-party application with Active Campaign. Our client wants all its contact data to be periodically synced from a third-party database into AC. This database is the source of truth and has contacts in the tens of thousands.
For this, I’m using the bulk import API but I’m facing a problem, AFAIK the bulk import API uses as the primary key the contact email (for selecting whether to insert or update a contact), so if a user in our application changes email, the bulk import will just create a new contact for the same user instead of updating the email (this is undesirable).
Is there a way I can specify another identifier for a contact in the bulk import? (like a custom field maybe, or the contact internal ID as it’s returned by other contact APIs) Or some workaround to this based solely on the API? (I would not be happy to track this in my code)
Also, the bulk import is very suitable for my problem due to the magnitude of the contacts, I could use the update contact API but it would generate a lot of calls and doesn’t seem a good idea.
Thanks in advance