Calendar
Create, update, query, and delete items in SharePoint Calendar lists.
Columns
Name | Type | ReadOnly | Description |
ID [KEY] | String | True |
The ID of the calendar entry. The format of the ID is: List|ItemID. |
List | String | False |
The name of the calendar list. |
Title | String | False |
The title of the entry. |
ParticipantsPicker | String | False |
The attendees of the calendar entry. |
FreeBusy | String | False |
A flag indicating the free or busy status during the event. |
Facilities | String | False |
The resources for this calendar entry. |
Location | String | False |
The location of the event. |
EventDate | Date | False |
The date the calendar entry starts. |
EndDate | Date | False |
The date the calendar entry ends. |
Description | String | False |
The description of the event. |
Duration | String | False |
The duration of the calendar entry. |
EventType | String | False |
The type of the event. |
IsAllDayEvent | String | False |
A flag indicating whether the entry is an all day event or not. |
fRecurrence | String | False |
A flag indicating whether this is a recurring event. |
Author | String | False |
The user that created the item. |
Editor | String | False |
The last user that modified the item. |
Modified | Date | False |
The date modified. |
Created | Date | False |
The date created. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
CAMLQuery | String |
The query to be used while listing the list items. |