Meetings
Stores planned meetings with agenda, participants, start and end times, reminders, and follow-up status.
Table-Specific Information
Select
This table supports the COQL and BULK APIs for filtering, meaning that most filters comparing columns to values are submitted server-side.
Insert
INSERT INTO Meetings (Title, `From`, To) VALUES ('A test event', '2018/05/29 18:00:00', '2018/05/29 20:30:00')
Required fields: Title, From, To.
Any field which is not read-only (ReadOnly = false in the table below) can be inserted.
Delete
You must specify the Id in the WHERE clause when executing a delete against this table.
DELETE FROM Meetings WHERE Id = '3152079000000153079'
Update
You must specify the Id in the WHERE clause when executing an update against this table.
UPDATE Meetings SET Description = 'Changed from the API.' WHERE Id = '3152079000000154219'
Required fields: Id.
Any field which is not read-only (ReadOnly = false in the table below) can be updated.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
Unique identifier of the meeting. |
| Event_Title | String | False |
The title or subject of the meeting. |
| Venue | String | False |
The location where the meeting is scheduled. |
| All_day | Bool | False |
Indicates whether the meeting lasts the entire day. |
| Start_DateTime | Datetime | False |
The start date and time of the meeting. |
| End_DateTime | Datetime | False |
The end date and time of the meeting. |
| Owner_Id | String | False |
Unique identifier of the meeting host. |
| Owner_FirstName | String | True |
First name of the meeting host. |
| Owner_LastName | String | True |
Last name of the meeting host. |
| Owner_Email | String | True |
Email address of the meeting host. |
| Who_Id_Id | String | False |
Unique identifier of the contact associated with the meeting. |
| What_Id_Id | String | False |
Unique identifier of the related record. |
| Recurring_Activity_Id | String | False |
Unique identifier of the repeat schedule. |
| Remind_At | String | False |
Reminder settings for the meeting. |
| Created_By_Id | String | False |
Unique identifier of the user who created the meeting. |
| Modified_By_Id | String | False |
Unique identifier of the user who last modified the meeting. |
| Modified_By_FirstName | String | True |
First name of the user who last modified the meeting. |
| Modified_By_LastName | String | True |
Last name of the user who last modified the meeting. |
| Modified_By_Email | String | True |
Email address of the user who last modified the meeting. |
| Created_Time | Datetime | False |
Date and time when the meeting was created. |
| Modified_Time | Datetime | False |
Date and time when the meeting was last modified. |
| Description | String | False |
Detailed description of the meeting. |
| Check_In_Time | Datetime | True |
Date and time when the participant checked in. |
| Check_In_By_Id | String | False |
Unique identifier of the user who performed the check-in. |
| Check_In_Comment | String | True |
Comment added during check-in. |
| Check_In_Sub_Locality | String | True |
Sub-locality where the check-in occurred. |
| Check_In_City | String | True |
City where the check-in occurred. |
| Check_In_State | String | True |
State where the check-in occurred. |
| Check_In_Country | String | True |
Country where the check-in occurred. |
| Latitude | Double | True |
Latitude coordinate of the check-in location. |
| Longitude | Double | True |
Longitude coordinate of the check-in location. |
| ZIP_Code | String | True |
Postal code of the check-in location. |
| Check_In_Address | String | True |
Full address of the check-in location. |
| Check_In_Status | String | True |
Current check-in status of the meeting. |
| Tag | String | False |
User-defined tags for categorization or filtering. |
| Remind_Participants | String | False |
Reminder configuration for meeting participants. |
| Id_CustomModule | Long | True |
Internal identifier used for processing the record. |
| Last_Activity_Time | Datetime | False |
The last date and time when the meeting was interacted with. |
| Record_Status__s | String | False |
Internal system status representing the current lifecycle/state of the meeting record. |
| Meeting_Venue__s | String | False |
Location or venue where the meeting is scheduled to take place. |
| Meeting_Provider__s | String | False |
Online meeting service/provider used for the meeting. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| DuplicateCheckFields | String |
The field(s) to be used for checking duplicate records in an upsert. The REST API allows for more than one field in the duplicate check but the BULK API only allows one field. |
| Trigger | String |
To trigger the rule while inserting record into CRM account. |