JDBC Driver for ActiveCampaign

Build 22.0.8462

AccountCustomFieldData

Create, modify, delete and query the available deal 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 AccountCustomFieldData WHERE Id = 10003

SELECT * FROM AccountCustomFieldData WHERE AccountId = 1

Insert

Inserting an account custom field data requires specifying a value for the AccountId, CustomFieldId, FieldValue columns.

Additionally, the driver supports inserting account custom fields data from the Accounts table. See Accounts for more information.

INSERT INTO AccountCustomFieldData (FieldValue, CustomFieldId, AccountId) VALUES ('custom field value',1,5)

Update

The driver supports updating account custom field data information. Updating an account custom field data requires specifying a value for the Id and CustomFieldId columns.

Additionally, it is possible to update account custom fields data from the Accounts table.

UPDATE AccountCustomFieldData SET FieldValue = 'Custom Field Value' WHERE Id = 13 AND CustomFieldId = 1

Delete

The driver supports removing accounts' custom field data.

DELETE FROM AccountcustomFieldData WHERE Id = 10

Columns

Name Type ReadOnly Description
Id [KEY] String True

The Id of the account custom field data.

AccountCustomFieldMetumId Integer True

The custom field metum Id.

AccountId Integer False

The ID of the account the field value relates to.

CreatedTimestamp Datetime True

Datetime value that indicates when the custom field value was set.

CustomFieldId [KEY] Integer False

The ID of the custom field metum the field value relates to.

CustomFieldName String True

The name of the custom field metum the field value relates to.

FieldValue String False

Values for the field. (For currency field only, this needs to be in cents: eg, 10050 = 100.5)

AccountLink String True

Account link.

AccountCustomFieldMetumLink String True

AccountCustomFieldMetum link.

UpdatedTimestamp Datetime True

Datetime value which indicates when the custom field data was last updated.

FieldCurrency String False

Value of the custom field currency type for a specific contact. This field is required when inserting currency custom fields.

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