SSIS Components for Cvent

Build 26.0.9655

Attendees

Returns data from the Attendees 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 =,!=
  • ConfirmationNumber supports =,!=
  • CheckedIn supports =,!=
  • CheckIn supports =,!=,>,<,>=,<=
  • CheckOut supports =,!=,>,<,>=,<=
  • ReferenceId supports =,!=
  • Note supports =,!=
  • Guest supports =,!=
  • Unsubscribed supports =,!=
  • Status supports =,!=
  • RegisteredAt supports =,!=,>,<,>=,<=
  • RegistrationLastModified supports =,!=,>,<,>=,<=
  • InvitedBy supports =,!=
  • ResponseMethod supports =,!=
  • Visibility supports =,!=
  • AttendeeLastModified supports =,!=,>,<,>=,<=
  • Created supports =,!=,>,<,>=,<=
  • LastModified supports =,!=,>,<,>=,<=
  • ContactId supports =,!=
  • ContactFirstName supports =,!=
  • ContactLastName supports =,!=
  • ContactEmail supports =,!=
  • EventId supports =,!=
  • RegistrationPathId supports =,!=
  • InvitationListId supports =,!=
  • RegistrationTypeId supports =,!=,IS NULL,IS NOT NULL
  • GroupId supports =,!=
  • GroupLeader supports =,!=
  • PrimaryId supports =,!=
  • DeletedGuest supports =,!=
  • IncludeDeletedGuests supports =,!=

All other filters are handled client-side.

The following is an example of a SELECT statement: 

SELECT * FROM Attendees WHERE Id='cventId' OR RegistrationLastModified <= '06/11/2026'

INSERT

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')

UPDATE

The following is an example of an UPDATE statement: 
UPDATE Attendees SET status = 'Accepted', ContactId = 'DE830CBE-B4EB-4E2B-A51C-6F10384CD0AD', EventId = 'e0ce6b11-2c5c-48b2-8104-b71ace5eed13'
 WHERE ID = '462af84e-be35-4082-ac38-3cda475dd1de'

DELETE

DELETEs are not supported for this table.

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 Attendees table.

Guest String False

The Guest of the Attendees table.

PrimaryId String False

The PrimaryId of the Attendees table.

Unsubscribed String False

The Unsubscribed of the Attendees table.

Status String False

The Status of the Attendees table.

RegisteredAt Datetime False

The RegisteredAt of the Attendees table.

RegistrationLastModified Datetime False

The RegistrationLastModified of the Attendees table.

RegistrationCancelledAt Datetime False

The RegistrationCancelledAt of the Attendees table.

InvitedBy String False

The InvitedBy of the Attendees table.

ResponseMethod String False

The ResponseMethod of the Attendees table.

Visibility String False

The Visibility of the Attendees table.

Bio String False

The Bio of the Attendees table.

ShowPopupNotification String False

The ShowPopupNotification of the Attendees table.

WebsiteUrl String False

The WebsiteUrl of the Attendees table.

AllowPushNotifications String False

The AllowPushNotifications of the Attendees table.

AllowAppointmentPushNotifications String False

The AllowAppointmentPushNotifications of the Attendees table.

TestRecord String False

The TestRecord of the Attendees table.

AttendeeLastModified Datetime False

The AttendeeLastModified of the Attendees table.

Created Datetime False

The Created of the Attendees table.

CreatedBy String False

The CreatedBy of the Attendees table.

LastModified Datetime False

The LastModified of the Attendees table.

LastModifiedBy String False

The LastModifiedBy of the Attendees table.

EventId String False

The EventId of the Attendees table.

ContactId String False

The ContactId of the Attendees table.

ContactFirstName String False

The ContactFirstName of the Attendees table.

ContactLastName String False

The ContactLastName of the Attendees table.

ContactEmail String False

The ContactEmail of the Attendees table.

RegistrationPathId String False

The RegistrationPathId of the Attendees table.

RegistrationPathCode String False

The RegistrationPathCode of the Attendees table.

RegistrationPathName String False

The RegistrationPathName of the Attendees table.

InvitationListId String False

The InvitationListId of the Attendees table.

InvitationListName String False

The InvitationListName of the Attendees table.

WebLinksAcceptRegistration String False

The WebLinksAcceptRegistration of the Attendees table.

WebLinksDeclineRegistration String False

The WebLinksDeclineRegistration of the Attendees table.

RegistrationTypeId String False

The RegistrationTypeId of the Attendees table.

RegistrationTypeName String False

The RegistrationTypeName of the Attendees table.

ExternalReferencesAggregate String False

The ExternalReferencesAggregate of the Attendees table.

GroupId String False

The GroupId of the Attendees table.

GroupMember Boolean False

The GroupMember of the Attendees table.

GroupLeader Boolean False

The GroupLeader of the Attendees table.

QuestionsAggregate String False

The QuestionsAggregate of the Attendees table.

AnswersAggregate String False

The AnswersAggregate of the Attendees table.

AdmissionItemId String False

The AdmissionItemId of the Attendees table.

AdmissionItemCode String False

The AdmissionItemCode of the Attendees table.

AdmissionItemName String False

The AdmissionItemName of the Attendees table.

AppointmentGroupsAggregate String False

The AppointmentGroupsAggregate of the Attendees table.

DeletedGuest Boolean False

Indicates this attendee is a deleted guest. Deleted guests will only be included if IncludeDeletedGuests=true.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
IncludeDeletedGuests Boolean

Whether to include deleted guests in the response.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655