ADO.NET Provider for Microsoft Office 365

Build 26.0.9655

TodoTasks

Individual tasks within a Microsoft To Do task list.

Columns

Name Type ReadOnly References Description
body_content String False

The text content of the task body.

body_contentType String False

The type of the content in the task body. The possible values are text and html.

bodyLastModifiedDateTime Datetime False

The date and time when the task body was last modified. By default, it is in UTC.

categories String False

The categories associated with the task. Each category corresponds to the displayName property of an outlookCategory that the user has defined.

completedDateTime_dateTime Datetime False

The date and time in the specified time zone that the task was finished.

completedDateTime_timeZone String False

The time zone of the completedDateTime property.

createdDateTime Datetime False

The date and time when the task was created. By default, it is in UTC.

dueDateTime_dateTime Datetime False

The date and time in the specified time zone that the task is to be finished.

dueDateTime_timeZone String False

The time zone of the dueDateTime property.

hasAttachments Bool False

Indicates whether the task has attachments.

importance String False

The importance of the task. The possible values are: low, normal, high.

isReminderOn Bool False

Set to true if an alert is set to remind the user of the task.

lastModifiedDateTime Datetime False

The date and time when the task was last modified. By default, it is in UTC.

recurrence_pattern_dayOfMonth Int False

The day of the month on which the task recurs. Required if type is absoluteMonthly or absoluteYearly.

recurrence_pattern_daysOfWeek String False

A collection of the days of the week on which the task recurs. The possible values are: sunday, monday, tuesday, wednesday, thursday, friday, saturday.

recurrence_pattern_firstDayOfWeek String False

The first day of the week. The possible values are: sunday, monday, tuesday, wednesday, thursday, friday, saturday.

recurrence_pattern_index String False

Specifies on which instance of the allowed days specified in daysOfWeek the task occurs. The possible values are: first, second, third, fourth, last.

recurrence_pattern_interval Int False

The number of units between occurrences, where units can be in days, weeks, months, or years, depending on the type.

recurrence_pattern_month Int False

The month in which the task recurs. This is a number from 1 to 12.

recurrence_pattern_type String False

The recurrence pattern type. The possible values are: daily, weekly, absoluteMonthly, relativeMonthly, absoluteYearly, relativeYearly.

recurrence_range_endDate Date False

The date to stop applying the recurrence pattern. Depending on the recurrence pattern of the event, the last occurrence of the meeting may not be this date.

recurrence_range_numberOfOccurrences Int False

The number of times to repeat the task.

recurrence_range_recurrenceTimeZone String False

Time zone for the startDate and endDate properties.

recurrence_range_startDate Date False

The date to start applying the recurrence pattern.

recurrence_range_type String False

The recurrence range type. The possible values are: endDate, noEnd, numbered.

reminderDateTime_dateTime Datetime False

The date and time in the specified time zone for a reminder alert of the task to occur.

reminderDateTime_timeZone String False

The time zone of the reminderDateTime property.

startDateTime_dateTime Datetime False

The date and time in the specified time zone at which the task is scheduled to start.

startDateTime_timeZone String False

The time zone of the startDateTime property.

status String False

Indicates the state or progress of the task. The possible values are: notStarted, inProgress, completed, waitingOnOthers, deferred.

title String False

A brief description of the task.

todotasklistid String False

The unique identifier of the task list this task belongs to.

userid String False

The identifier of the user associated with this task.

Id [KEY] String True

Unique identifier for the task. By default, this value changes when the item is moved from one list to another.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655