Reference

Table MyMailFolders

Description

No description available

Supported Operations

Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.
Method Supported Reference EndPoint
SELECT get_my_mailfolders
INSERT
UPDATE
UPSERT
DELETE
LOOKUP get_my_mailfolder

Examples

SSIS

Use Outlook Mail (Office 365) Connector in API Source component to read data or in API Destination component to read/write data:

Read from MyMailFolders table using API Source

API Source - Outlook Mail (Office 365)
Read and write Microsoft Outlook Mail (Office 365) data effortlessly. Send, manage, and sync messages, attachments, and folders — almost no coding required.
Outlook Mail (Office 365)
MyMailFolders
There are no parameters to configure.
SSIS API Source - Read from table or endpoint

Read/write to MyMailFolders table using API Destination

API Destination - Outlook Mail (Office 365)
Read and write Microsoft Outlook Mail (Office 365) data effortlessly. Send, manage, and sync messages, attachments, and folders — almost no coding required.
Outlook Mail (Office 365)
MyMailFolders
Select
There are no parameters to configure.
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Read mail folders

<p>Gets all mail folders for the current user. Use the returned folder ID in examples that need <code>MailFolderID</code>.</p> 

SELECT * FROM MyMailFolders

Read a mail folder by ID

<p>Gets a single mail folder by ID. Use <code>WHERE Id='...'</code> with the folder ID from Read mail folders.</p> 

SELECT * FROM MyMailFolders
WHERE (Id='AAMkADIwNzNhODMyLTZiMTQtNDhiMCz4OWQzLTc5YTY5M2IyMjk0NAYuAAAAAACbj2hVuNphT74wyYrfU4ixAQAbUV6IxRnpQrWzrb2WfacdAAAAAAEKAcA=')

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Read mail folders

<p>Gets all mail folders for the current user. Use the returned folder ID in examples that need <code>MailFolderID</code>.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM MyMailFolders';

EXEC (@MyQuery) AT [LS_TO_OUTLOOK_MAIL_OFFICE_365_IN_GATEWAY];

Read a mail folder by ID

<p>Gets a single mail folder by ID. Use <code>WHERE Id='...'</code> with the folder ID from Read mail folders.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM MyMailFolders
WHERE (Id=''AAMkADIwNzNhODMyLTZiMTQtNDhiMCz4OWQzLTc5YTY5M2IyMjk0NAYuAAAAAACbj2hVuNphT74wyYrfU4ixAQAbUV6IxRnpQrWzrb2WfacdAAAAAAEKAcA='')';

EXEC (@MyQuery) AT [LS_TO_OUTLOOK_MAIL_OFFICE_365_IN_GATEWAY];