AccountCustomFieldData
Create, modify, delete and query the available deal 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 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 本製品 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 本製品 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 本製品 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 | 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. |