Meetings
Create, update, delete, and query information regarding meetings.
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 |
Id |
| Title | String | False |
Title |
| Location | String | False |
Location |
| Allday | Bool | False |
Allday |
| From | Datetime | False |
From |
| To | Datetime | False |
To |
| Host_Id | String | False |
Host Id |
| Host_FirstName | String | True |
Host FirstName |
| Host_LastName | String | True |
Host LastName |
| Host_Email | String | True |
Host Email |
| Host_Name | String | True |
Host Name |
| ContactName_Id | String | False |
ContactName Id |
| ContactName_Name | String | True |
ContactName Name |
| RelatedTo_Id | String | False |
RelatedTo Id |
| RelatedTo_Name | String | True |
RelatedTo Name |
| Repeat_Id | String | False |
Repeat Id |
| Repeat_Name | String | True |
Repeat Name |
| Reminder | String | False |
Reminder |
| CreatedBy_Id | String | False |
CreatedBy Id |
| CreatedBy_FirstName | String | True |
CreatedBy FirstName |
| CreatedBy_LastName | String | True |
CreatedBy LastName |
| CreatedBy_Email | String | True |
CreatedBy Email |
| CreatedBy_Name | String | True |
CreatedBy Name |
| ModifiedBy_Id | String | False |
ModifiedBy Id |
| ModifiedBy_FirstName | String | True |
ModifiedBy FirstName |
| ModifiedBy_LastName | String | True |
ModifiedBy LastName |
| ModifiedBy_Email | String | True |
ModifiedBy Email |
| ModifiedBy_Name | String | True |
ModifiedBy Name |
| CreatedTime | Datetime | False |
CreatedTime |
| ModifiedTime | Datetime | False |
ModifiedTime |
| Participants | String | False |
Participants |
| Description | String | False |
Description |
| Check-InTime | Datetime | True |
Check-InTime |
| Check-InBy_Id | String | False |
Check-InBy Id |
| Check-InBy_Name | String | True |
Check-InBy Name |
| Check-InComment | String | True |
Check-InComment |
| Check-InSub-Locality | String | True |
Check-InSub-Locality |
| Check-InCity | String | True |
Check-InCity |
| Check-InState | String | True |
Check-InState |
| Check-InCountry | String | True |
Check-InCountry |
| Latitude | Double | True |
Latitude |
| Longitude | Double | True |
Longitude |
| ZipCode | String | True |
ZipCode |
| Check-InAddress | String | True |
Check-InAddress |
| CheckedInStatus | String | True |
CheckedInStatus |
| Tag | String | False |
Tag |
| LastActivityTime | Datetime | False |
LastActivityTime |
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 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. |
| CustomViewId | Long |
The custom view Id to be used for filtering this record. Will work when useCOQL=false. |