Emails
Returns data from the Emails 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:
- EventId supports =
- AttendeeId supports =
- ContactId supports =
- Status supports =
- LastModified supports =,>,<,>=,<=
All other filters are handled client-side.
The following is an example of a SELECT statement:
SELECT * FROM Emails WHERE EventId = '3a366031-7541-4a44-9fde-bc0f81d3e940'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The Id of the Emails table. | |
| Subject | String | The Subject of the Emails table. | |
| From | String | The From of the Emails table. | |
| To | String | The To of the Emails table. | |
| Type | String | The Type of the Emails table. | |
| Sent | Datetime | The Sent of the Emails table. | |
| Status | String | The Status of the Emails table. | |
| Undeliverable | Boolean | The Undeliverable of the Emails table. | |
| Opened | Boolean | The Opened of the Emails table. | |
| FirstOpened | String | The FirstOpened of the Emails table. | |
| Clicked | Boolean | The Clicked of the Emails table. | |
| FirstClicked | String | The FirstClicked of the Emails table. | |
| Bounced | Boolean | The Bounced of the Emails table. | |
| Created | Datetime | The Created of the Emails table. | |
| CreatedBy | String | The CreatedBy of the Emails table. | |
| LastModified | Datetime | The LastModified of the Emails table. | |
| LastModifiedBy | String | The LastModifiedBy of the Emails table. | |
| EventId | String | The EventId of the Emails table. | |
| ContactId | String | The ContactId of the Emails table. | |
| AttendeeId | String | The AttendeeId of the Emails table. |