SSIS Components for ActiveCampaign

Build 23.0.8839


Usage information for the operation AccountContacts.rsd.

Table Specific Information


The 本製品 uses the ActiveCampaign API to process some of the filters.

For example, the following queries are processed server side:

SELECT * FROM AccountContacts WHERE Id = 10003

SELECT * FROM AccountContacts WHERE AccountId = 1 AND ContactId = 100


Inserting an account-contact association requires specifying a value for the AccountId and ContactId columns.

INSERT INTO AccountContacts (AccountId, ContactId) VALUES (2, 300)

INSERT INTO AccountContacts (AccountId, ContactId, Jobtitle) VALUES (2, 300, 'nurse')


The driver supports updating account-contact information.

UPDATE AccountContacts SET ContactId = 3, JobTitle = 'updatedJobTitle' WHERE Id = 1

UPDATE AccountContacts SET JobTitle = 'updatedJobTitle' WHERE AccountId = 1


Remove all account-contacts association or an association by specifying the Id of the association.

DELETE FROM AccountContacts WHERE Id = 10003


Name Type ReadOnly Description
Id [KEY] String True

The Id of the account-contact association.

AccountId String False

The account Id.

ContactId String False

The contact Id.

CreatedTimestamp Datetime True

Datetime value which indicates when the assosiaction was created.

JobTitle String False

Job Title of the contact at the account.

AccountLink String True

Account link.

ContactLink String True

Contact link.

UpdatedTimestamp Datetime True

Datetime value which indicates when the assosiaction was last updated.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839