AttendeeActivities
Returns data from the AttendeeActivities 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 =,!=
- Name supports =,!=
- Type supports =,!=
- Created supports =,!=,>,<,>=,<=
All other filters are handled client-side.
The following is an example of a SELECT statement:
SELECT * FROM AttendeeActivities WHERE Id='cventId' OR Created <= '06/11/2020'
INSERT
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. |