ContactCustomFieldData
Create, modify, delete and query the available contact custom field data in ActiveCampaign.
Table Specific Information
Select
The 本製品 uses the ActiveCampaign API to process some of the filters.
For example, the following queries are processed server side:
SELECT * FROM ContactCustomFieldData WHERE Id = 10003 SELECT * FROM ContactCustomFieldData WHERE FieldValue = 'custom field value'
Insert
Inserting a contact custom field data requires specifying a value for the ContactId, FieldId, FieldValue columns.
Additionally, the 本製品 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 本製品 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 本製品 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. |