Calls
Stores logged call records, enabling full lifecycle management including creation, updates, and deletions.
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 Calls (Subject, ModuleName, RelatedTo_Id,CallType,CallStartTime) VALUES ('A test call', 'Accounts', '5768552000000433001','Outbound','May 20, 2023 12:00 AM')
Required fields: Subject, ModuleName, CallType, CallStartTime and ContactName_Id if ModuleName = Contacts and RelatedTo_Id if any other modulename is specified.
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 Calls WHERE Id = '3152079000000153079'
Update
You must specify the Id in the WHERE clause when executing an update against this table.
UPDATE Calls SET Subject = 'Updated from API' WHERE Id = '3152079000000484001'
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 (Id) for the call record. |
| CallOwner_Id | String | False |
Id of the user assigned as the call owner. |
| CallOwner_FirstName | String | True |
First name of the user who owns the call. |
| CallOwner_LastName | String | True |
Last name of the user who owns the call. |
| CallOwner_Email | String | True |
Email address of the user who owns the call. |
| CallOwner_Name | String | True |
Full name of the user who owns the call. |
| Subject | String | False |
Subject line or title of the call. |
| CallType | String | False |
Indicates whether the call was inbound or outbound. |
| CallPurpose | String | False |
Purpose or objective of the call, such as follow-up or demo. |
| ContactName_Id | String | False |
Identifier of the contact associated with the call. |
| ContactName_Name | String | True |
Full name of the contact associated with the call. |
| RelatedTo_Id | String | False |
Identifier of the related module record, such as an account or lead. |
| RelatedTo_Name | String | True |
Name of the record from the related module. |
| CallStartTime | Datetime | False |
Date and time when the call started. |
| CallDuration | String | False |
Duration of the call in human-readable format. |
| CallDuration(inseconds) | Int | False |
Duration of the call in seconds. |
| Description | String | False |
Detailed description or notes about the call. |
| CallResult | String | False |
Outcome of the call, such as completed or missed. |
| CTIEntry | Bool | False |
Indicates whether the call was logged using a CTI (Computer Telephony Integration) system. |
| CreatedBy_Id | String | False |
Identifier of the user who created the call record. |
| CreatedBy_FirstName | String | True |
First name of the user who created the call record. |
| CreatedBy_LastName | String | True |
Last name of the user who created the call record. |
| CreatedBy_Email | String | True |
Email address of the user who created the call record. |
| CreatedBy_Name | String | True |
Full name of the user who created the call record. |
| ModifiedBy_Id | String | False |
Identifier of the user who last modified the call record. |
| ModifiedBy_FirstName | String | True |
First name of the user who last modified the call record. |
| ModifiedBy_LastName | String | True |
Last name of the user who last modified the call record. |
| ModifiedBy_Email | String | True |
Email address of the user who last modified the call record. |
| ModifiedBy_Name | String | True |
Full name of the user who last modified the call record. |
| CreatedTime | Datetime | False |
Timestamp indicating when the call record was created. |
| ModifiedTime | Datetime | False |
Timestamp indicating when the call record was last modified. |
| Reminder | String | False |
Reminder setting for the call, such as alert time before the call. |
| CallStatus | String | True |
Current status of the call, such as completed or scheduled. |
| Tag | String | False |
Comma-separated list of tags associated with the call. |
| LastActivityTime | Datetime | False |
Timestamp of the last activity related to the call record. |
| CallAgenda | String | False |
Agenda or topics planned for discussion during the call. |
| CallerID | String | True |
Caller Id information used during the call. |
| DialledNumber | String | True |
Phone number that was dialed for the call. |
| ModuleName | String | False |
Name of the module in which the call record exists. |
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 |
One or more fields used to check for duplicates during an upsert operation. Multiple fields are supported in the REST API, but only one field is allowed in the BULK API. |
| Trigger | String |
Specifies whether to trigger associated workflow rules when inserting the record. |
| CustomViewId | Long |
Identifier of the custom view used to filter this record. Applies only when the useCOQL parameter is set to false. |