JDBC Driver for Cvent

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062