Sessions
Returns data from the Sessions 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 =,!=
- Virtual supports =,!=
- Title supports =,!=
- Code supports =,!=
- Description supports =,!=
- Start supports =,!=,>,<,>=,<=
- End supports =,!=,>,<,>=,<=
- Status supports =,!=
- EnableWaitlist supports =,!=
- Capacity supports =,!=,>,<,>=,<=
- Featured supports =,!=
- OpenForRegistration supports =,!=
- OpenForAttendeeHub supports =,!=
- Created supports =,!=,>,<,>=,<=
- LastModified supports =,!=,>,<,>=,<=
All other filters are handled client-side.
The following is an example of a SELECT statement:
SELECT * from Sessions WHERE Created > '2024-02-16'
INSERT
INSERT is not supported for this table.UPDATE
UPDATE is not supported for this table.DELETE
The following is an example of a DELETE statement:DELETE FROM Sessions WHERE Id ='2cbd2393-8b84-42e4-9702-dc32f67d02c6'
Columns
| Name | Type | ReadOnly | References | Description |
| IncludedSession | Boolean | False |
The IncludedSession of the Sessions table. | |
| Relevance | String | False |
The Relevance of the Sessions table. | |
| Id [KEY] | String | False |
The Id of the Sessions table. | |
| Virtual | Boolean | False |
The Virtual of the Sessions table. | |
| Title | String | False |
The Title of the Sessions table. | |
| Code | String | False |
The Code of the Sessions table. | |
| Description | String | False |
The Description of the Sessions table. | |
| Start | Datetime | False |
The Start of the Sessions table. | |
| End | Datetime | False |
The End of the Sessions table. | |
| Status | String | False |
The Status of the Sessions table. | |
| AutomaticallyOpensOn | String | False |
The AutomaticallyOpensOn of the Sessions table. | |
| AutomaticallyClosesOn | String | False |
The AutomaticallyClosesOn of the Sessions table. | |
| EnableWaitlist | Boolean | False |
The EnableWaitlist of the Sessions table. | |
| WaitlistCapacity | String | False |
The WaitlistCapacity of the Sessions table. | |
| EnableWaitlistVirtual | Boolean | False |
The EnableWaitlistVirtual of the Sessions table. | |
| Capacity | String | False |
The Capacity of the Sessions table. | |
| CapacityUnlimited | Boolean | False |
The CapacityUnlimited of the Sessions table. | |
| CapacityVirtual | String | False |
The CapacityVirtual of the Sessions table. | |
| VirtualCapacityUnlimited | Boolean | False |
The VirtualCapacityUnlimited of the Sessions table. | |
| WaitlistCapacityVirtual | String | False |
The WaitlistCapacityVirtual of the Sessions table. | |
| Timezone | String | False |
The Timezone of the Sessions table. | |
| DisplayOnAgenda | Boolean | False |
The DisplayOnAgenda of the Sessions table. | |
| Featured | Boolean | False |
The Featured of the Sessions table. | |
| OpenForRegistration | Boolean | False |
The OpenForRegistration of the Sessions table. | |
| OpenForAttendeeHub | Boolean | False |
The OpenForAttendeeHub of the Sessions table. | |
| PresentationType | String | False |
The PresentationType of the Sessions table. | |
| DataTagCode | String | False |
The DataTagCode of the Sessions table. | |
| Created | Datetime | False |
The Created of the Sessions table. | |
| CreatedBy | String | False |
The CreatedBy of the Sessions table. | |
| LastModified | Datetime | False |
The LastModified of the Sessions table. | |
| LastModifiedBy | String | False |
The LastModifiedBy of the Sessions table. | |
| EventId | String | False |
The EventId of the Sessions table. | |
| CategoryId | String | False |
The CategoryId of the Sessions table. | |
| CategoryName | String | False |
The CategoryName of the Sessions table. | |
| TypeId | String | False |
The TypeId of the Sessions table. | |
| TypeCode | String | False |
The TypeCode of the Sessions table. | |
| TypeName | String | False |
The TypeName of the Sessions table. | |
| LocationId | String | False |
The LocationId of the Sessions table. | |
| LocationCode | String | False |
The LocationCode of the Sessions table. | |
| LocationName | String | False |
The LocationName of the Sessions table. | |
| Group | String | False |
The GroupAggregate of the Sessions table. | |
| AdmissionItemsAggregate | String | False |
The AdmissionItemsAggregate of the Sessions table. | |
| RegistrationTypesAggregate | String | False |
The RegistrationTypesAggregate of the Sessions table. |