Event
Stores scheduled meetings, appointments, and calendar events associated with users or records.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier of the event. | |
| WhoId | String | False |
ID of the contact or lead associated with the event. | |
| WhoIdType | String | False |
Specifies the type of the 'WhoId' polymorphic field to use in the statement. | |
| WhoIdExternalFieldName | String | False |
Specifies the external field name of the 'WhoId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement | |
| WhatId | String | False |
ID of the related opportunity, account, or other object associated with the event. | |
| WhatIdType | String | False |
Specifies the type of the 'WhatId' polymorphic field to use in the statement. | |
| WhatIdExternalFieldName | String | False |
Specifies the external field name of the 'WhatId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement | |
| Subject | String | False |
Subject or title of the event. | |
| Location | String | False |
Location where the event will take place. | |
| IsAllDayEvent | Bool | False |
Indicates whether the event spans the entire day. | |
| ActivityDateTime | Datetime | False |
Start date and time of the event (used if the event is not all-day). | |
| ActivityDate | Date | False |
Date of the event (used for all-day events). | |
| DurationInMinutes | Int | False |
Duration of the event in minutes. | |
| StartDateTime | Datetime | False |
Start date and time of the event. | |
| EndDateTime | Datetime | False |
End date and time of the event. | |
| EndDate | Date | True |
End date for the record or activity. | |
| Description | String | False |
Detailed description or notes related to the event. | |
| AccountId | String | True |
Account.Id |
ID of the related account associated with the event. |
| OwnerId | String | False |
ID of the user who owns or is assigned to the event. | |
| OwnerIdType | String | False |
Specifies the type of the 'OwnerId' polymorphic field to use in the statement. | |
| OwnerIdExternalFieldName | String | False |
Specifies the external field name of the 'OwnerId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement | |
| CurrencyIsoCode | String | False |
ISO code for the currency in which the revenue amount is expressed. | |
| IsPrivate | Bool | False |
Indicates whether the event is marked as private. | |
| ShowAs | String | False |
Specifies how the event should be displayed on the calendar, such as Busy or Free. | |
| IsDeleted | Bool | True |
Indicates whether the event has been deleted. | |
| IsChild | Bool | True |
Indicates whether the event is a child in a recurring series. | |
| IsGroupEvent | Bool | True |
Indicates whether the event involves a group of users. | |
| GroupEventType | String | True |
Type of group event, such as internal meeting or shared calendar entry. | |
| CreatedDate | Datetime | True |
Date and time when the event was created. | |
| CreatedById | String | True |
User.Id |
ID of the user who created the event. |
| LastModifiedById | String | True |
User.Id |
ID of the user who last modified the event. |
| IsArchived | Bool | True |
Indicates whether the event is archived. | |
| RecurrenceActivityId | String | True |
Event.Id |
ID of the recurring series the event belongs to, if applicable. |
| IsRecurrence | Bool | False |
Indicates whether the event is part of a recurring series. | |
| RecurrenceStartDateTime | Datetime | False |
Start date and time of the recurring event series. | |
| RecurrenceEndDateOnly | Date | False |
End date of the recurring event series. | |
| RecurrenceTimeZoneSidKey | String | False |
Time zone in which the recurrence occurs. | |
| RecurrenceType | String | False |
Pattern type of the recurring event, such as daily or weekly. | |
| RecurrenceInterval | Int | False |
Interval between recurrences based on the recurrence type. | |
| RecurrenceDayOfWeekMask | Int | False |
Bitmask representing the days of the week the event repeats on. | |
| RecurrenceDayOfMonth | Int | False |
Day of the month the event repeats on, if applicable. | |
| RecurrenceInstance | String | False |
Instance within the month the event repeats on, such as First or Last. | |
| RecurrenceMonthOfYear | String | False |
Month in which the recurring event occurs, if applicable. | |
| ReminderDateTime | Datetime | False |
Date and time when a reminder is scheduled to trigger. | |
| IsReminderSet | Bool | False |
Indicates whether a reminder is set for the event. | |
| EventSubtype | String | False |
Type classification for EventSub. | |
| IsRecurrence2Exclusion | Bool | True |
Indicates whether the record has the Recurrence2Exclusion characteristic. | |
| Recurrence2PatternText | String | False |
Field containing Recurrence2PatternText information. | |
| Recurrence2PatternVersion | String | True |
Field containing Recurrence2PatternVersion information. | |
| IsRecurrence2 | Bool | True |
Indicates whether the record has the Recurrence2 characteristic. | |
| IsRecurrence2Exception | Bool | True |
Indicates whether the record has the Recurrence2Exception characteristic. | |
| Recurrence2PatternStartDate | Datetime | True |
Date associated with Recurrence2PatternStart. | |
| Recurrence2PatternTimeZone | String | True |
Field containing Recurrence2PatternTimeZone information. | |
| SOQL | String | False |
Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query. | |
| ExternalIdColumn | String | False |
Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called. | |
| FilterScope | String | False |
Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team. | |
| SystemModstamp | Datetime | True |
System-generated timestamp indicating the last modification date. | |
| LastModifiedDate | Datetime | True |
Date and time when the event was last modified. |