Power BI Connector for Cvent

Build 24.0.9029

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.

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