DealCustomFieldData

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

Table Specific Information

Select

The add-in uses the ActiveCampaign API to process some of the filters.

For example, the following queries are processed server side:

SELECT * FROM DealCustomFieldData WHERE Id = 10003

SELECT * FROM DealCustomFieldData WHERE DealId = 1

Insert

Inserting a deal custom field data requires specifying a value for the DealId, CustomFieldId, and FieldValue columns.

Additionally, the add-in supports inserting deal custom fields data from the Deals table. See Deals for more information.

INSERT INTO DealCustomFieldData (FieldValue, CustomFieldId, DealId) VALUES ('custom field value', 1, 5)

Update

The add-in supports updating deal custom field data information. Updating deal custom field data requires specifying a value for the Id, DealId and CustomFieldId columns.

Additionally, it is possible to update deal custom fields data from the Deals table.

UPDATE DealCustomFieldData SET FieldValue = 'custom field value' WHERE Id = 8 AND DealId = 3 AND CustomFieldId = 2

Delete

The add-in supports removing deal custom field data.

DELETE FROM DealCustomFieldData WHERE Id = 10

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	The Id column of the DealCustomFieldData table.
CreatedTimestamp	Datetime	False	The CreatedTimestamp column of the DealCustomFieldData table.
CustomFieldName	String	True	The name of the custom field metum the field value relates to.
CustomFieldId	Integer	False	The CustomFieldId column of the DealCustomFieldData table.
DealCustomFieldMetumId	Integer	False	The DealCustomFieldMetumId column of the DealCustomFieldData table.
DealId	Integer	False	The DealId column of the DealCustomFieldData table.
FieldValue	String	False	The FieldValue column of the DealCustomFieldData table.
DealLink	String	False	The DealLink column of the DealCustomFieldData table.
DealCustomFieldMetumLink	String	False	The DealCustomFieldMetumLink column of the DealCustomFieldData table.
UpdatedTimestamp	Datetime	False	The UpdatedTimestamp column of the DealCustomFieldData.
FieldCurrency	String	False	Value of the custom field currency type for a specific deal. This field is required when inserting currency custom fields.
FieldType	String	False	Value of the custom field currency type for a specific deal. This field is required when inserting currency custom fields.