MailFolders
MailFolders table for Exchange data provider.
Table Specific Information
Select
Get the mail folder collection directly under the root folder of the signed-in user. The returned collection includes any mail search folders directly under the root:
SELECT * FROM MailFolders SELECT * FROM MailFolders where userId ='1c67f23f-8681-4c67-9c19-253e628442d5'
Note: This operation does not return all mail folders in a mailbox, only the child folders of the root folder. To return all mail folders in a mailbox, each child folder must be traversed separately.
SELECT * FROM CData.MSGraph.MailFolders Where userId ='1c67f23f-8681-4c67-9c19-253e628442d5' and id = 'AQMkAGY1YTc5NjE4LWE4MWYtNDI3Yy1iYgBmYi1hNDk0ZmMxZTJjZDgALgAAAz6irHRWjXlFqioVZIpcig4BAG0Pxgnb-IlHsx0QnxhOmzcAAAIBGAAAAA==' SELECT * FROM CData.MSGraph.MailFolders Where userId ='1c67f23f-8681-4c67-9c19-253e628442d5' and id = (SELECT parentFolderId from CData.MSGraph.MailFolders where userId ='1c67f23f-8681-4c67-9c19-253e628442d5' and displayName = 'Inbox')
Columns
| Name | Type | ReadOnly | Description |
| id [KEY] | String | False | |
| childFolderCount | Int | False | |
| displayName | String | False | |
| parentFolderId | String | False | |
| totalItemCount | Int | False | |
| unreadItemCount | Int | False |
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 |
| userId | String |