AllEvents
Presents a comprehensive collection of SharePoint event records, detailing timing, location, attendees, and associated metadata for effective event management.
Columns
| Name | Type | References | Description |
| SiteURL [KEY] | String |
Sites.SiteURL | The URL of the SharePoint site where the event list resides. |
| EventListId [KEY] | String | The unique identifier of the library. | |
| EventId [KEY] | Int | The unique identifier for the event item. | |
| Category | String | The classification category of the event. | |
| Title | String | The title or subject of the event. | |
| Name | String | The display name of the event item. | |
| Attendees | String | The collection of attendee identifiers for the event. | |
| StartTime | Datetime | The starting time of the event. | |
| EndTime | Datetime | The ending time of the event. | |
| IsAllDayEvent | Bool | Indicates whether the event is scheduled to last the entire day. | |
| Availability | String | The event's availability status (free or busy). | |
| Attachments | Bool | Indicates whether the event item has any attachments. | |
| EventCancelled | Bool | Indicates whether the event has been cancelled. | |
| EventType | Int | The classification type of the event. | |
| Duration | Int | The duration of the event, typically in minutes. | |
| EncodedAbsoluteURL | String | The encoded absolute URL for accessing the event item. | |
| ServerRelativeURL | String | The server-relative URL to access the event item. | |
| Path | String | The server file path of the event item within SharePoint. | |
| CreatedBy | Int | The identifier of the user who created the event item. | |
| ModifiedBy | Int | The identifier of the user who last modified the event record. | |
| Created | Datetime | The timestamp when the event item was created. | |
| Modified | Datetime | The timestamp when the event record was last updated. | |
| Description | String | The detailed description of the event. | |
| ContentTypeID | String | The unique identifier for the content type applied to the event item. | |
| ItemType | Int | The SharePoint item type (for example, file, folder) 0: File; 1: Folder. | |
| FileName | String | The display name of the file associated with the event record. | |
| Resources | String | The associated resources or facilities reserved for the event. | |
| Location | String | The physical or virtual location where the event takes place. | |
| ApproverComments | String | The comments provided by the approver regarding the event item. | |
| ApprovalStatus | Int | The current approval status of the event item. 0: Approved; 1: Rejected; 2: Pending; 3: Draft. | |
| CheckDoubleBooking | String | The indicator used to flag potential double bookings for events. | |
| HiddenParticipants | String | The list of participants hidden from the event's public participant list. | |
| EffectivePermissionsMask | String | The permissions mask representing the effective rights for the event item. | |
| PrincipalCount | String | The number of principals (users or groups) associated with the event item permissions. | |
| IsRecurring | Bool | Indicates whether the event is recurring. | |
| RecurrenceData | String | The XML data defining the recurrence pattern for the event. | |
| TimeZone | Int | The time zone identifier applicable to the event timings. | |
| GUID | String | The globally unique identifier (GUID) for the event item. | |
| UniqueId | String | The read-only GUID for the event record. | |
| BannerImageURL | String | The URL of the banner image associated with the event for visual representation | |
| BannerURL | String | The hyperlink URL for the event's banner image. | |
| BannerDescription | String | The descriptive text for the banner hyperlink of the event. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| ItemCount | Int | The filter that is propagated to the AllLists view. |