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: John, lastName: Doe, email: [email protected] }]'
INSERT INTO Events (Title, format, timezone, LanguagesAggregate, PlannersAggregate, type) VALUES('SampleTitle', 'Virtual', 'America/New_York' , + languageAggregate + , + plannersAggregate + , 'Webinar')
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. |