JDBC Driver for ActiveCampaign

Build 22.0.8462

ContactCustomFieldData

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

Table Specific Information

Select

The driver 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 driver 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 driver 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 driver 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 [KEY] 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 [KEY] 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462