Meetings
Stores scheduled meetings with agenda, participants, start/end times, and follow-up status.
Table-Specific Information
Select
This table supports COQL 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. |
| Title | String | False |
The subject or title of the meeting. |
| Location | String | False |
The location where the meeting is scheduled. |
| Allday | Bool | False |
Indicates whether the meeting lasts the entire day. |
| From | Datetime | False |
The start date and time of the meeting. |
| To | Datetime | False |
The end date and time of the meeting. |
| Host_Id | String | False |
The unique identifier of the meeting host. |
| Host_FirstName | String | True |
The first name of the meeting host. |
| Host_LastName | String | True |
The last name of the meeting host. |
| Host_Email | String | True |
The email address of the meeting host. |
| Host_Name | String | True |
The full name of the meeting host. |
| ContactName_Id | String | False |
The unique identifier of the associated contact. |
| ContactName_Name | String | True |
The name of the associated contact. |
| RelatedTo_Id | String | False |
The unique identifier of the related entity. |
| RelatedTo_Name | String | True |
The name of the related entity. |
| Repeat_Id | String | False |
The unique identifier of the recurrence rule. |
| Repeat_Name | String | True |
The name of the recurrence rule. |
| Reminder | String | False |
Details of the reminder set for the meeting. |
| CreatedBy_Id | String | False |
The unique identifier of the user who created the meeting record. |
| CreatedBy_FirstName | String | True |
The first name of the user who created the meeting record. |
| CreatedBy_LastName | String | True |
The last name of the user who created the meeting record. |
| CreatedBy_Email | String | True |
The email address of the user who created the meeting record. |
| CreatedBy_Name | String | True |
The full name of the user who created the meeting record. |
| ModifiedBy_Id | String | False |
The unique identifier of the user who last modified the meeting record. |
| ModifiedBy_FirstName | String | True |
The first name of the user who last modified the meeting record. |
| ModifiedBy_LastName | String | True |
The last name of the user who last modified the meeting record. |
| ModifiedBy_Email | String | True |
The email address of the user who last modified the meeting record. |
| ModifiedBy_Name | String | True |
The full name of the user who last modified the meeting record. |
| CreatedTime | Datetime | False |
The date and time when the meeting record was created. |
| ModifiedTime | Datetime | False |
The date and time when the meeting record was last modified. |
| Participants | String | False |
List of participants invited to the meeting. |
| Description | String | False |
Additional details or notes about the meeting. |
| Check-InTime | Datetime | True |
The date and time when the check-in occurred. |
| Check-InBy_Id | String | False |
The unique identifier of the user who performed the check-in. |
| Check-InBy_Name | String | True |
The name of the user who performed the check-in. |
| Check-InComment | String | True |
Comments provided at the time of check-in. |
| Check-InSub-Locality | String | True |
Sub-locality recorded at the time of check-in. |
| Check-InCity | String | True |
City recorded at the time of check-in. |
| Check-InState | String | True |
State recorded at the time of check-in. |
| Check-InCountry | String | True |
Country recorded at the time of check-in. |
| Latitude | Double | True |
Latitude coordinates of the check-in location. |
| Longitude | Double | True |
Longitude coordinates of the check-in location. |
| ZipCode | String | True |
Postal code recorded at the time of check-in. |
| Check-InAddress | String | True |
Full address recorded during check-in. |
| CheckedInStatus | String | True |
Indicates the check-in status of the meeting. |
| Tag | String | False |
Labels or tags associated with the meeting record. |
| LastActivityTime | Datetime | False |
Timestamp of the most recent activity on this record. |
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 |
| DuplicateCheckFields | String |
The fields used to detect duplicate records during an upsert. The REST API supports multiple fields while the BULK API supports only one. |
| Trigger | String |
Used to trigger workflow rules when inserting a new record into the CRM account. |
| CustomViewId | Long |
Custom view identifier used for filtering records. Works only when the useCOQL parameter is set to false. |