Calls

Create, update, delete, and query information regarding calls.

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	False	The unique identifier for this record.
ContactName_Id	String	False	The Id of the contact of the call.
ContactName_FirstName	String	False	The First Name of the contact of the call.
ContactName_LastName	String	False	The Last Name of the contact of the call.
Subject	String	False	The subject of the call.
CallPurpose	String	False	The purpose of the call.
RelatedTo_Id	String	False	The Id of the person this call was related to.
CallType	String	False	The type of the call.
CallStartTime	Datetime	False	The time of the start of the call.
CallDuration	String	False	The duration of the call.
CallDuration_inseconds_	Int	False	The duration of the call in seconds.
Description	String	False	The description of the call.
CallResult	String	False	The result of the call.
Billable	Bool	False	Whether this call was billable or not.
CallOwner_Id	String	False	The Id of the owner of the call.
CreatedBy_Id	String	False	The Id of the User who created the record.
ModifiedBy_Id	String	False	The Id of the User who modified the record.
ModifiedBy_FirstName	String	False	The First Name of the User who modified the record.
ModifiedBy_LastName	String	False	The Last Name of the User who modified the record.
CreatedTime	Datetime	False	The time when the record was created.
Tag	String	False	The tags of the call.
ModifiedTime	Datetime	False	The time when the record was modified.
Reminder	String	False	The reminder set for this call.
CallStatus	String	True	The status of the call.
ModuleName	String	False	The name of the module this call belongs to.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
DuplicateCheckFields	String	The field/s to be used for checking in an upsert.
CustomViewId	Long	The custom view Id to be used for filtering this record. Will work when useCOQL=false.

Power BI Connector for Zoho CRM