RecurringTasks

Query, create, update and delete recurring task records.

Table Specific Information

Select

Id supports the '=' operator.
AttachmentLastModified supports the '<=,<,=,!=,>,>=' operator.
AttachmentPersonal supports the '=' operator.
Created supports the '<=,<,=,!=,>,>=' operator.
Edited supports the '<=,<,=,!=,>,>=' operator.
IsAllDay supports the '=' operator.
IsAlarmCleared supports the '=' operator.
IsAlarmed supports the '=' operator.
IsPrivate supports the '=' operator.
IsTimeless supports the '=' operator.
Subject supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
RecurSpecIsEndless supports the '=' operator.
RecurSpecSeriesEnd supports the '<=,<,=,!=,>,>=' operator.
RecurSpecSeriesStart supports the '<=,<,=,!=,>,>=' operator.

The driver uses the Act! CRM API to process search criteria that refer to the supported fields. The driver processes other filters client-side within the driver. For example, the following queries are processed server side:

SELECT * FROM RecurringTasks WHERE Id = '12345'
SELECT * FROM RecurringTasks WHERE Subject = 'Weekly review'

Insert

To insert a recurring task, you must specify at least one contact, the subject, and the recurrence pattern details.

INSERT INTO RecurringTasks (ContactsAggregate, Subject, RecurSpecRecurType, RecurSpecSeriesStart, RecurSpecIsEndless, RecurSpecFrequency, RecurSpecDayDayAsInt, RecurSpecDayDayType, RecurSpecDayDaysOfWeek) VALUES ('[{\"id\":\"972df268-a4db-41db-bc32-4af89ab3034b\"}]', 'Weekly Team Standup', 'Weekly', '2026-07-08T09:00:00Z', true, 1, 1, 'Named', 'Monday, Tuesday')

Update

Any column where ReadOnly=False can be updated. Specify the RecurringTasks Id when updating a recurring task.

UPDATE RecurringTasks SET Subject = 'Update xyaz' WHERE Id = '3f3d27e2-dfcc-42b5-b383-d8d44f5cced0'

Delete

RecurringTasks can be deleted by providing an Id and issuing a DELETE statement.

DELETE FROM RecurringTasks WHERE Id = '8912d252-b6ce-4442-a8d9-26b619f4ccbe'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	True	A unique identifier that represents the activity.
ActivityPriorityId	Integer	False	Activity Priority value.
ActivityPriorityName	String	False	Displays the priority of the activity.
ActivityTypeId	Integer	True	Displays the id of the type of the activity.
ActivityTypeName	String	False	Displays the type of the activity.
AttachmentDisplayName	String	True	Gets presentation name of the attachment.
AttachmentFileExtension	String	True	Gets the extension of the attachment.
AttachmentFileName	String	True	Gets a string representing the directory full path.
AttachmentFileSize	Integer	True	Gets the size (bytes) of the attachment.
AttachmentFileSizeDisplay	String	True	Gets the displayable text representation of the attachment.
AttachmentFileType	String	True	Gets the registered system file type name of the attachment.
AttachmentLastModified	Datetime	True	Gets the last modified date of the attachment.
AttachmentPersonal	Boolean	True	Indicates whether the attachment is bound for the personal supplemental files or the workgroup supplemental files.
BannerColor	String	False	The banner color.
CalendarUid	String	False	A unique calendar uid, common for all invited users.
CompaniesAggregate	String	False	List of companies that are associated to this activity.
ContactsAggregate	String	False	List of contacts that are associated to this activity. At least one contact is required.
Created	Datetime	True	The date and time the activity was created.
Details	String	False	Additional detailed information about the activity.
Duration	String	False	The difference between the start time and end time of the activity.
Edited	Datetime	True	The date and time the activity was last updated.
ExternalId	String	False	Provides a unique identifier to an external system.
GroupsAggregate	String	False	List of groups that are associated to this activity.
IsAllDay	Boolean	False	Indicates whether the activity takes up an entire day.
IsAlarmCleared	Boolean	False	Boolean value of IsAlarmCleared.
IsAlarmed	Boolean	False	Turns on/off an alarm for this activity.
IsPrivate	Boolean	False	Indicates elevated security that only the creator/owner has access to this activity.
IsRecurring	Boolean	True	True if the activity is recurring, otherwise false.
IsTimeless	Boolean	False	Indicates whether a specified action is to be completed at a specific time-of-day.
LeadMinutes	Integer	False	The number of minutes the alarm will sound before the activity is scheduled to start.
AlarmDue	String	False	Alarm due.
Location	String	False	Describes the physical location that the activity is to take place.
OpportunitiesAggregate	String	False	List of opportunities that are associated to this activity.
ScheduledBy	String	True	The contact who created this activity.
ScheduledById	String	False	The id of the activity organizer.
ScheduledFor	String	False	The name of the activity organizer.
ScheduledForId	String	False	The id of the activity organizer.
ScheduledWithCompany	String	True	Company name of the contact with whom this activity was scheduled.
ScheduledWithEmail	String	True	Business email address of the contact with whom this activity was scheduled.
ScheduledWithPhone	String	True	Phone number of the contact with whom this activity was scheduled.
ScheduledWithPhoneExt	String	True	Phone extension of the contact with whom this activity was scheduled.
Subject	String	False	A description of the action to be completed.
RecurSpecDayDayAsInt	Integer	False	An integer representation of the day of the week portion of a recurrence pattern.
RecurSpecDayDaysOfWeek	String	False	Representation of the day of the week portion of a recurrence pattern.
RecurSpecDayDayType	String	False	Describing the day-portion of the recurrence pattern.
RecurSpecDayOrdinal	String	False	Describes recurrence in relative terms for certain recurrence patterns (i.e. First, Third, Last).
RecurSpecDayTypedDay	String	False	Describing the TypedDay (Day, WeekDay or Weekend Day) for the recurrence pattern when DayType is TypedDay.
RecurSpecFrequency	Integer	False	Represents how often for the recurrence patterns.
RecurSpecIsEndless	Boolean	False	Flag denoting whether an end date has been specified for the pattern.
RecurSpecMonth	Integer	False	Represents the specific month for certain recurrence patterns.
RecurSpecRecurType	String	False	Represents a unit of time used to separate recurrences (i.e. Daily, Weekly, Monthly, Yearly).
RecurSpecSeriesEnd	Datetime	False	Specifying the ending time for a given day.
RecurSpecSeriesStart	Datetime	False	Specifying the starting time for a given day.