Create, modify, delete and query the available contact custom field data in ActiveCampaign.

Table-Specific Information

Select

The connector uses the ActiveCampaign API to process WHERE clause conditions built with the following columns and operator:

• Id supports the = operator.
• FieldValue supports the = operator.
• ContactId supports the = operator.
• FieldId supports the = operator.

For example, the following queries are processed server-side:

SELECT * FROM ContactCustomFieldData WHERE Id = 10003
SELECT * FROM ContactCustomFieldData WHERE FieldValue = 'custom field value'
SELECT * FROM ContactCustomFieldData WHERE ContactId = 52
SELECT * FROM ContactCustomFieldData WHERE FieldId = 104

The connector processes other filters client-side within the connector.

Insert

Inserting a contact custom field data requires specifying a value for the ContactId, FieldId, FieldValue columns.

Additionally, the connector supports inserting contact custom fields data from the Contacts table. See Contacts for more information.

INSERT INTO ContactCustomFieldData (FieldValue, FieldId, ContactId) VALUES ('custom field value', 1, 5)

Update

The connector supports updating contact custom field data information. Updating contact custom field data requires specifying a value for the Id, ContactId and FieldId columns.

Additionally, it is possible to update contact custom fields data from the Contacts table.

UPDATE ContactCustomFieldData SET FieldValue = 'custom field value' WHERE Id = 8 AND ContactId = 3 AND FieldId = 2"

Delete

The connector supports removing contact custom field data.

DELETE FROM ContactCustomFieldData WHERE Id = 10

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	False	The Id column of the ContactCustomFieldData table.
CDate	Datetime	False	The CDate column of the ContactCustomFieldData table.
ContactId	String	False	The ContactId column of the ContactCustomFieldData table.
CustomFieldName	String	True	The name of the custom field metum the field value relates to.
FieldId	String	False	ID of the field the value belongs to.
FieldLink	String	False	The FieldLink column of the ContactCustomFieldData table.
OwnerLink	String	False	The OwnerLink column of the ContactCustomFieldData table.
Owner	String	False	The Owner column of the ContactCustomFieldData table.
Udate	Datetime	False	The Udate column of the ContactCustomFieldData table.
FieldValue	String	False	Value of the custom field for a specific contact.