Returns data from the Events 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 =,!=
• Title supports =,!=
• Code supports =,!=
• Virtual supports =,!=
• Format supports =,!=
• Description supports =,!=
• Start supports =,!=,>,<,>=,<=
• End supports =,!=,>,<,>=,<=
• CloseAfter supports =,!=,>,<,>=,<=
• ArchiveAfter supports =,!=,>,<,>=,<=
• LaunchAfter supports =,!=,>,<,>=,<=
• Note supports =,!=
• Status supports =,!=
• EventStatus supports =,!=
• Created supports =,!=,>,<,>=,<=
• LastModified supports =,!=,>,<,>=,<=

All other filters are handled client-side.

The following is an example of a SELECT statement:

SELECT * FROM Events WHERE Title='titleValue' OR Start <= '06/11/2020'

INSERT

The following is an example of an INSERT statement that uses aggregate fields for inserts:

@languagesAggregate = '[en-US, en-psk]'
@plannersAggregate = '[{firstName: John,  lastName: Doe,  email: [email protected] }]'

INSERT INTO Events (Title, format, timezone, LanguagesAggregate, PlannersAggregate, type) VALUES('SampleTitle', 'Virtual', 'America/New_York' , @languagesAggregate, @plannersAggregate, 'Webinar')

UPDATE

The following is an example of an UPDATE statement:

UPDATE Events SET title= 'EventTitle',format= 'Virtual',timezone= 'America/Chicago',LanguagesAggregate= @languagesAggregate,PlannersAggregate= @plannersAggregate, type='Celebration' WHERE id = '80B7A193-A807-4B7E-BFEA-787E86DFB40D'

DELETE

DELETEs are not supported for this table.

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The Id of the Events table.
Title	String	False		The Title of the Events table.
Code	String	False		The Code of the Events table.
Virtual	Boolean	False		The Virtual of the Events table.
Format	String	False		The Format of the Events table.
Description	String	False		The Description of the Events table.
Start	Datetime	False		The Start of the Events table.
End	Datetime	False		The End of the Events table.
CloseAfter	Datetime	False		The CloseAfter of the Events table.
ArchiveAfter	Datetime	False		The ArchiveAfter of the Events table.
LaunchAfter	Datetime	False		The LaunchAfter of the Events table.
Timezone	String	False		The Timezone of the Events table.
Phone	String	False		The Phone of the Events table.
Note	String	False		The Note of the Events table.
DefaultLocale	String	False		The DefaultLocale of the Events table.
Currency	String	False		The Currency of the Events table.
RegistrationSecurityLevel	String	False		The RegistrationSecurityLevel of the Events table.
Status	String	False		The Status of the Events table.
EventStatus	String	False		The EventStatus of the Events table.
PlanningStatus	String	False		The PlanningStatus of the Events table.
TestMode	Boolean	False		The TestMode of the Events table.
Capacity	Integer	False		The Capacity of the Events table.
Type	String	False		The Type of the Events table.
Created	Datetime	False		The Created of the Events table.
LastModified	Datetime	False		The LastModified of the Events table.
MeetingRequestId	String	False		The MeetingRequestId of the Events table.
CreatedBy	String	False		The CreatedBy of the Events table.
LastModifiedBy	String	False		The LastModifiedBy of the Events table.
VenuesAggregate	String	False		The VenuesAggregate of the Events table.
LanguagesAggregate	String	False		The LanguagesAggregate of the Events table.
PlannersAggregate	String	False		The PlannersAggregate of the Events table.
StakeholdersAggregate	String	False		The StakeholdersAggregate of the Events table.
CategoryId	String	False		The CategoryId of the Events table.
CategoryName	String	False		The CategoryName of the Events table.
CategoryCode	String	False		The CategoryCode of the Events table.