Events
Returns data from the Events table.
Table Specific Information
The Cvent API allows you to filter by certain fields when querying for data.
The following is an example of a SELECT statement:
select * from Events where Title='titleValue' or Start <= '06/11/2020'The following is an example of an INSERT statement that uses aggregate fields for inserts:
String LanguagesAggregate = '[en-US, en-psk]' String PlannersAggregate = '[{firstName: Matthew, lastName: Villegas, email: [email protected] }]'
INSERT INTO Events (title, format, timezone, LanguagesAggregate, PlannersAggregate, type) VALUES('EventTitle', 'Virtual', 'America/Chicago', LanguagesAggregate, PlannersAggregate, 'Celebration')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'The following is an example of a DELETE statement:
DELETE FROM Events where id = '80B7A193-A807-4B7E-BFEA-787E86DFB40D'
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. |