Tableau Connector for ActiveCampaign

Build 22.0.8462

DealStages

Usage information for the operation DealStages.rsd.

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 DealStages WHERE Id = 10003

SELECT * FROM DealStages WHERE Title = 'title' AND GroupId = 1

Insert

Inserting a stage requires specifying a value for the GroupId, Title columns.

INSERT INTO DealStages (GroupId, Title) VALUES (2,'title')

INSERT INTO DealStages (Title, GroupId, OrderId, CardRegion3, Color, Width) VALUES ('TestStage',1,2,'hide-avatar','434343','280')

Update

The connector supports updating stage/dealstage information.

UPDATE DealStages SET Title = 'updatedTitle' WHERE Id = 1

Delete

Remove all stages or a stage by specifying the Id of the stage.

DELETE FROM DealStages WHERE Id = 10003

Columns

Name Type ReadOnly Description
Id [KEY] String True

The Id column of the DealStages table.

CardRegion1 String False

The CardRegion1 column of the DealStages table. Indicates what to show in upper-left corner of Deal Cards.

CardRegion2 String False

The CardRegion2 column of the DealStages table. Indicates what to show in upper-right corner of Deal Cards.

CardRegion3 String False

The CardRegion3 column of the DealStages table. Indicates whether to show the avatar in Deal Cards. Can be one of show-avatar and hide-avatar. If set to show-avatar, deal cards will show the avatars. If set to hide-avatar, deal cards will hide the avatars.

CardRegion4 String False

The CardRegion4 column of the DealStages table. Indicates what to show next to the avatar in Deal Cards.

CardRegion5 String False

The CardRegion5 column of the DealStages table. Indicates what to show in lower-right corner of Deal Cards.

Cdate Datetime True

The Cdate column of the DealStages table.

Color String False

Deal Stage's color. 6-character HEX color code without the hashtag. e.g. 434343 to assign the hex color value #434343.

DealOrder String False

Option and direction to be used to sort deals in the deal stage. The option and direction should be delimited by a space. Direction can be either

GroupId String False

The GroupId column of the DealStages table.

GroupLink String True

The GroupLink column of the DealStages table.

OrderId String False

The OrderId column of the DealStages table.

Title String False

The Title column of the DealStages table.

Udate Datetime True

The Udate column of the DealStages table.

Width String False

Deal stage's width in pixels, without px unit.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462