Attendees
Returns data from the Attendees 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 Attendees where Id='cventId' or RegistrationLastModified <= '06/11/2020'The following is an example of an INSERT statement:
INSERT INTO Attendees (status, ContactId, EventId, InvitationListId) VALUES('No Response', 'DE830CBE-B4EB-4E2B-A51C-6F10384CD0AD', 'e0ce6b11-2c5c-48b2-8104-b71ace5eed13', 'be48a15b-f86f-458f-a7e5-45c9bc073030')The following is an example of an UPDATE statement:
UPDATE Attendees status = 'Accepted', ContactId = 'DE830CBE-B4EB-4E2B-A51C-6F10384CD0AD', EventId='e0ce6b11-2c5c-48b2-8104-b71ace5eed13' where ID='462af84e-be35-4082-ac38-3cda475dd1de'The following is an example of a DELETE statement:
DELETE FROM Attendees where id = 'attendeeId'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | False |
The ID of the Attendees table. | |
ConfirmationNumber | String | False |
The ConfirmationNumber of the Attendees table. | |
CheckedIn | Boolean | False |
The CheckedIn of the Attendees table. | |
CheckIn | Datetime | False |
The CheckIn of the Attendees table. | |
CheckOut | Datetime | False |
The CheckOut of the Attendees table. | |
Duration | String | False |
The Duration of the Attendees table. | |
ReferenceId | String | False |
The ReferenceId of the Attendees table. | |
Note | String | False |
The Note of the Attendess table. | |
Guest | String | False |
The Guest of the Attendess table. | |
PrimaryId | String | False |
The PrimaryId of the Attendess table. | |
Unsubscribed | String | False |
The Unsubscribed of the Attendess table. | |
Status | String | False |
The Status of the Attendess table. | |
RegisteredAt | Datetime | False |
The RegisteredAt of the Attendess table. | |
RegistrationLastModified | Datetime | False |
The RegistrationLastModified of the Attendess table. | |
RegistrationCancelledAt | Datetime | False |
The RegistrationCancelledAt of the Attendess table. | |
InvitedBy | String | False |
The InvitedBy of the Attendess table. | |
ResponseMethod | String | False |
The ResponseMethod of the Attendess table. | |
Visibility | String | False |
The Visibility of the Attendess table. | |
Bio | String | False |
The Bio of the Attendess table. | |
ShowPopupNotification | String | False |
The ShowPopupNotification of the Attendess table. | |
WebsiteUrl | String | False |
The WebsiteUrl of the Attendess table. | |
AllowPushNotifications | String | False |
The AllowPushNotifications of the Attendess table. | |
AllowAppointmentPushNotifications | String | False |
The AllowAppointmentPushNotifications of the Attendess table. | |
TestRecord | String | False |
The TestRecord of the Attendess table. | |
AttendeeLastModified | Datetime | False |
The AttendeeLastModified of the Attendess table. | |
Created | Datetime | False |
The Created of the Attendess table. | |
CreatedBy | String | False |
The CreatedBy of the Attendess table. | |
LastModified | Datetime | False |
The LastModified of the Attendess table. | |
LastModifiedBy | String | False |
The LastModifiedBy of the Attendess table. | |
EventId | String | False |
The EventId of the Attendess table. | |
ContactId | String | False |
The ContactId of the Attendess table. | |
ContactFirstName | String | False |
The ContactFirstName of the Attendess table. | |
ContactLastName | String | False |
The ContactLastName of the Attendess table. | |
ContactEmail | String | False |
The ContactEmail of the Attendess table. | |
RegistrationPathId | String | False |
The RegistrationPathId of the Attendess table. | |
RegistrationPathCode | String | False |
The RegistrationPathCode of the Attendess table. | |
RegistrationPathName | String | False |
The RegistrationPathName of the Attendess table. | |
InvitationListId | String | False |
The InvitationListId of the Attendess table. | |
InvitationListName | String | False |
The InvitationListName of the Attendess table. | |
WebLinksAcceptRegistration | String | False |
The WebLinksAcceptRegistration of the Attendess table. | |
WebLinksDeclineRegistration | String | False |
The WebLinksDeclineRegistration of the Attendess table. | |
RegistrationId | String | False |
The RegistrationId of the Attendess table. | |
RegistrationName | String | False |
The RegistrationName of the Attendess table. | |
ExternalReferencesAggregate | String | False |
The ExternalReferencesAggregate of the Attendess table. | |
GroupId | String | False |
The GroupId of the Attendess table. | |
GroupMember | Boolean | False |
The GroupMember of the Attendess table. | |
GroupLeader | Boolean | False |
The GroupLeader of the Attendess table. | |
QuestionsAggregate | String | False |
The QuestionsAggregate of the Attendess table. | |
AnswersAggregate | String | False |
The AnswersAggregate of the Attendess table. | |
AdmissionItemId | String | False |
The AdmissionItemId of the Attendess table. | |
AdmissionItemCode | String | False |
The AdmissionItemCode of the Attendess table. | |
AdmissionItemName | String | False |
The AdmissionItemName of the Attendess table. | |
AppointmentGroupsAggregate | String | False |
The AppointmentGroupsAggregate of the Attendess table. |