Calls
Captures call interactions, logging duration, outcome, and related contacts for performance tracking.
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 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. |
| Owner_Id | String | False |
Identifier of the user who owns the call record. |
| Owner_FirstName | String | True |
First name of the user who owns the call record. |
| Owner_LastName | String | True |
Last name of the user who owns the call record. |
| Owner_Email | String | True |
Email address of the user who owns the call record. |
| Subject | String | False |
Subject or title of the call. |
| Call_Type | String | False |
Specifies whether the call was inbound or outbound. |
| Call_Purpose | String | False |
Purpose or reason for the call. |
| Who_Id_Id | String | False |
Identifier of the contact associated with the call. |
| What_Id_Id | String | False |
Identifier of the related record. |
| Call_Start_Time | Datetime | False |
Date and time when the call started. |
| Call_Duration | String | False |
Duration of the call in standard format. |
| Call_Duration_in_seconds | Int | False |
Duration of the call in seconds. |
| Description | String | False |
Details or notes about the call. |
| Call_Result | String | False |
Outcome or result of the call. |
| Created_By_Id | String | False |
Identifier of the user who created the call record. |
| Modified_By_Id | String | False |
Identifier of the user who last modified the call record. |
| Modified_By_FirstName | String | True |
First name of the user who last modified the call record. |
| Modified_By_LastName | String | True |
Last name of the user who last modified the call record. |
| Modified_By_Email | String | True |
Email address of the user who last modified the call record. |
| Created_Time | Datetime | False |
Date and time when the call record was created. |
| Modified_Time | Datetime | False |
Date and time when the call record was last modified. |
| Reminder | String | False |
Reminder set for the call, if any. |
| Tag | String | False |
Tags associated with the call record. |
| Outgoing_Call_Status | String | False |
Status of the outbound call. |
| Scheduled_In_CRM | String | True |
Indicates whether the call was scheduled within the CRM. |
| Id_CustomModule | Long | True |
Internal record identifier. |
| Last_Activity_Time | Datetime | False |
Date and time of the last activity on the call record. |
| Call_Agenda | String | False |
Agenda or planned topics for the call. |
| Caller_ID | String | True |
Caller identifier used during the call. |
| Dialled_Number | String | True |
Phone number dialed during the call. |
| Voice_Recording__s | String | False |
Link or reference to the call recording. |
| Record_Status__s | String | False |
Internal system status indicating the current lifecycle/state of the account record. |
| ModuleName | String | False |
Name of the CRM module the call record belongs to. |
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. |