Folders
Create, update, delete, and query subfolders for a given folder.
Table Specific Information
Update and Delete
The add-in will need the FolderChangeKey to update or delete an item. However, if you are unsure of the FolderChangeKey, the add-in is able to retrieve it from the Exchange server automatically. Note that this may increase the time it take to perform a query.
Columns
| Name | Type | ReadOnly | Description |
| FolderId [KEY] | String | True |
Contains the unique identifier of an folder in the Exchange store. |
| FolderChangeKey | String | True |
Contains the unique change key of an folder in the Exchange store. |
| ParentFolderId | String | False |
Represents the unique identifier of the parent folder that contains the item or folder. |
| ParentFolderChangeKey | String | True |
Represents the unique change key of the parent folder that contains the item or folder. |
| FolderClass | String | False |
Represents the folder class for a given folder. |
| DisplayName | String | False |
Contains the display name of a folder. |
| TotalCount | Integer | True |
Represents the total count of items within a given folder. |
| ChildFolderCount | Integer | True |
Represents the number of child folders that are contained within a folder. |
| CanDelete | Boolean | True |
Indicates whether a managed folder can be deleted by a customer. |
| CanRenameOrMove | Boolean | True |
Indicates whether a given managed folder can be renamed or moved by the customer. |
| MustDisplayComment | Boolean | True |
Indicates whether the managed folder comment must be displayed. |
| HasQuota | Boolean | True |
Indicates whether the managed folder has a quota. |
| IsManagedFoldersRoot | Boolean | True |
Indicates whether the managed folder is the root for all managed folders. |
| ManagedFolderId | String | True |
Contains the folder Id of the managed folder. |
| Comment | String | True |
Contains the comment that is associated with a managed folder. |
| StorageQuota | Integer | True |
Describes the storage quota for the managed folder. |
| FolderSize | Integer | True |
Describes the total size of all the contents of a managed folder. |
| HomePage | String | True |
Specifies the URL that will be the default home page for the managed folder. |
| UnreadCount | Integer | True |
Represents the count of unread items within a given folder. |
| EffectiveRights_CreateAssociated | Boolean | True |
Indicates whether a client can create an associated contents table. |
| EffectiveRights_CreateContents | Boolean | True |
Indicates whether a client can create a contents table. |
| EffectiveRights_CreateHierarchy | Boolean | True |
Indicates whether a client can create a hierarchy table. |
| EffectiveRights_Delete | Boolean | True |
Indicates whether a client can delete a folder or item. |
| EffectiveRights_Modify | Boolean | True |
Indicates whether a client can modify a folder or item. |
| EffectiveRights_Read | Boolean | True |
Indicates whether a client can read a folder or item. |
| EffectiveRights_ViewPrivateItems | Boolean | True |
Indicates whether a private item can be viewed. |
| SharingEffectiveRights | String | False |
Indicates the permissions that the user has for the contact data that is being shared. |
| ParentFolderName | String | False |
Represents the distinguished folder Id of the parent folder. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| ImpersonationUser | String |
The Identifier of the user to impersonate. |
| ImpersonationType | String |
The type of Identifier used for the impersonation user (PrincipalName, SID, PrimarySmtpAddress, SmtpAddress). |
| Traversal | String |
Defines how a search is performed. One of [Shallow, Deep, SoftDeleted]. Default values is Shallow |
| SharedMailboxEmail | String |
The email of a shared mailbox. Use this to retrieve the shared folders. |
| Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |