Calls
Captures inbound and outbound call logs, including duration, outcome, and related contacts or deals.
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 for the call record. |
| CallOwner_Id | String | False |
Identifier of the user who owns the call record. |
| CallOwner_FirstName | String | True |
First name of the call owner. |
| CallOwner_LastName | String | True |
Last name of the call owner. |
| CallOwner_Email | String | True |
Email address of the call owner. |
| CallOwner_Name | String | True |
Full name of the call owner. |
| Subject | String | False |
Title or subject of the call. |
| CallType | String | False |
Type of call, such as inbound or outbound. |
| CallPurpose | String | False |
Purpose or intent of the call. |
| ContactName_Id | String | False |
Identifier of the contact person associated with the call. |
| ContactName_Name | String | True |
Full name of the contact person associated with the call. |
| RelatedTo_Id | String | False |
Identifier of the related record linked to the call. |
| RelatedTo_Name | String | True |
Name of the related record linked to the call. |
| CallStartTime | Datetime | False |
Date and time when the call started. |
| CallDuration | String | False |
Duration of the call in formatted text. |
| CallDuration(inseconds) | Int | False |
Duration of the call in seconds. |
| Description | String | False |
Additional details or notes about the call. |
| CallResult | String | False |
Outcome or result of the call. |
| CTIEntry | Bool | False |
Indicates whether the call was recorded through a computer telephony integration (CTI) 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 of when the call record was created. |
| ModifiedTime | Datetime | False |
Timestamp of the most recent modification to the call record. |
| Reminder | String | False |
Reminder settings associated with the call. |
| Tag | String | False |
User-defined tag associated with the call. |
| OutgoingCallStatus | String | False |
Status of the outgoing call, such as completed or missed. |
| ScheduledinCRM | String | True |
Indicates whether the call was scheduled in the CRM system. |
| LastActivityTime | Datetime | False |
Timestamp of the most recent activity related to the call. |
| CallAgenda | String | False |
Agenda or topic discussed during the call. |
| CallerID | String | True |
Caller identifier number displayed during the call. |
| DialledNumber | String | True |
Phone number that was dialed during the call. |
| ModuleName | String | False |
Name of the module in which the call record resides. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| DuplicateCheckFields | String |
Fields used to identify duplicate records during an upsert operation. The REST API allows multiple fields, while the BULK API allows only one. |
| Trigger | String |
Indicates whether to trigger automation rules when inserting the call record. |
| CustomViewId | Long |
Custom view Id used for filtering records. Applies when the useCOQL parameter is false. |