Cmdlets for Cvent

Build 24.0.9060

AttendeeActivities

Returns data from the AttendeeActivities 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 AttendeeActivities where Id='cventId' or Created <= '06/11/2020'
The following is an example of an INSERT statement:
INSERT INTO AttendeeActivities (name, type, dataid, dataExternalActivityDate, attendeeId, eventId)
VALUES ('social.media', 'event.external', 'e1188b76-74e7-406a-aeec-c841e52dbc11', '01/02/2024', '97bb14d0-69ce-40a3-be66-0a888542978c', 'e1188b76-74e7-406a-aeec-c841e52dbc11' )

Columns

Name Type ReadOnly References Description
Name String False

The Name of the AttendeeActivities table.

Type String False

The Type of the AttendeeActivities table.

Id [KEY] String False

The Id of the AttendeeActivities table.

Created Datetime False

The Created of the AttendeeActivities table.

AppointmentId String False

The AppointmentId of the AttendeeActivities table.

AppointmentName String False

The AppointmentName of the AttendeeActivities table.

AppointmentCode String False

The AppointmentCode of the AttendeeActivities table.

ContactFirstName String False

The ContactFirstName of the AttendeeActivities table.

ContactLastName String False

The ContactLastName of the AttendeeActivities table.

ContactEmail String False

The ContactEmail of the AttendeeActivities table.

AttendeeId String False

The AttendeeId of the AttendeeActivities table.

EventId String False

The EventId of the AttendeeActivities table.

EventCode String False

The EventCode of the AttendeeActivities table.

EventTimezone String False

The EventTimezone of the AttendeeActivities table.

EventTitle String False

The EventId of the AttendeeActivities table.

DataId String False

The DataId of the Attendess table.

DataExternalActivityDate Datetime False

The DataExternalActivityDate of the Attendess table.

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