Returns data from the ContactGroups table.

Table Specific Information

SELECT

The Cvent API allows you to filter by certain fields when querying for data. The following fields can be filtered by the API:

• Id supports =
• Name supports =,!=,like
• Type supports =

All other filters are handled client-side.

The following is an example of a SELECT statement:

SELECT * from ContactGroups where Name='new'

INSERT

The following is an example of an INSERT statement:

INSERT INTO ContactGroups (Name, Type) VALUES ('Test 2', 'STANDARD')

UPDATE

The following is an example of an UPDATE statement:

UPDATE ContactGroups SET Id ='fa47f767-3a45-44dc-a7a5-701f42a6cccd', Name='abc', Type = 'DISTRIBUTION_LIST' WHERE Id ='fa47f767-3a45-44dc-a7a5-701f42a6cccd'

DELETE

The following is an example of a DELETE statement:

DELETE FROM ContactGroups WHERE Id='fa3ca656-a6cb-498d-9b54-25bba92cf931'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The Id of the ContactGroups table.
Name	String	False		The Name of the ContactGroups table.
ShortDescription	String	False		The ShortDescription of the ContactGroups table.
Description	String	False		The Description of the ContactGroups table.
Type	String	False		The Type of the ContactGroups table.
Note	String	False		The Note of the ContactGroups table.
Created	Datetime	False		The Created of the ContactGroups table.
CreatedBy	String	False		The CreatedBy of the ContactGroups table.
LastModified	Datetime	False		The LastModified of the ContactGroups table.
LastModifiedBy	String	False		The LastModifiedBy of the ContactGroups table.
DistributionSecurityType	String	False		The DistributionSecurityType of the ContactGroups table.
DistributionInternalNote	String	False		The DistributionInternalNote of the ContactGroups table.
DistributionStatus	String	False		The DistributionStatus of the ContactGroups table.