ODBC Driver for ActiveCampaign

Build 24.0.9062

DealCustomFieldData

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 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 本製品 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 本製品 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 本製品 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062