Calls

Create, update, delete, and query the SuiteCRM project's Calls

Table Specific Information

Select

You can query the Calls table using any criteria in the WHERE clause. The connector will use the SuiteCRM API to filter the results.

SELECT * FROM Calls WHERE Name = 'test'

Insert

Create a Call by specifying any writable column.

INSERT INTO Calls (Id, Name) VALUES ('id', 'Energy')

Update

You can update any Call column that is writable, by specifying the Id.

UPDATE Calls SET Name = 'new name', Description = 'Desc' WHERE Id = 'Test123'

Delete

Delete a Call by specifying the Id.

DELETE FROM Calls WHERE Id = '10003'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	The unique identifier of the call.
Name	String	False	A brief description of the call.
DateEntered	Datetime	False	The date the record was created.
DateModified	Datetime	False	The date the record was last modified.
ModifiedUserId	String	False	The Id of the user who last modified the record.
ModifiedByName	String	True	The name of the user who last modified the record.
CreatedBy	String	False	The Id of the user who created the record.
CreatedByName	String	True	The name of the user who created the record.
Description	String	False	The full text of the note.
Deleted	Bool	False	Record deletion indicator.
CreatedByLink	String	True	Link to the record who created it
ModifiedUserLink	String	True	Link to the record who modified it.
AssignedUserId	String	False
AssignedUserName	String	True
AssignedUserLink	String	True	Link to the user which the record has been assigned to
SecurityGroups	String	True	The security group associated with the record.
DurationHours	String	False	The hours portion of the call duration.
DurationMinutes	String	False	The minutes portion of the call duration.
DateStart	Datetime	False
DateEnd	Datetime	False
ParentType	String	False	The type of the parent Sugar object related to the call.
ParentName	String	True	The name of the parent of this account.
Status	String	False	The status of the record.
Direction	String	False	Indicates whether call is inbound or outbound.
ParentId	String	False	The Id of the parent of this account.
ReminderChecked	Bool	False	The checkbox indicating whether or not the reminder value is set.
ReminderTime	String	False	When a reminder alert should be issued. -1 means no alert; otherwise, the number of seconds prior to the start.
EmailReminderChecked	Bool	False
EmailReminderTime	String	False	When a email reminder alert should be issued. -1 means no alert; otherwise, the number of seconds prior to the start.
EmailReminderSent	Bool	False	Whether the email reminder is already sent.
Reminders	String	False	List of reminders for the call
OutlookId	String	False	When the Suite Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item Id.
AcceptStatus	String	False
SetAcceptLinks	String	False
ContactName	String	False
Opportunities	String	True	The opportunities associated with the record.
Leads	String	True	The leads associated with the record.
Project	String	True	The project associated with the record.
Case	String	True
Accounts	String	True	The accounts associated with the record
Contacts	String	True	The contacts associated with the record
AosContracts	String	True
Users	String	True
Notes	String	True	The notes associated with the record.
ContactId	String	False	The Id of the contact for the call.
RepeatType	String	False	The type of recurrence.
RepeatInterval	String	False	The interval of recurrence.
RepeatDow	String	False	The days of week in recurrence.
RepeatUntil	String	False	Repeat until the specified date.
RepeatCount	String	False	Number of recurrences.
RepeatParentId	String	False	The Id of the first element of recurring records.
RecurringSource	String	False	The recurring source requesting the call
RescheduleHistory	String	False
RescheduleCount	String	False
CallsReschedule	String	True