Tableau Connector for ActiveCampaign

Build 22.0.8462

DealCustomFieldData

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

Table Specific Information

Select

The connector 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 connector 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 connector 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 connector 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 [KEY] Integer False

The CustomFieldId column of the DealCustomFieldData table.

DealCustomFieldMetumId Integer False

The DealCustomFieldMetumId column of the DealCustomFieldData table.

DealId [KEY] 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462