AccountCustomFieldData

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

Table Specific Information

Select

The adapter uses the 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 adapter 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 adapter 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 adapter 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.