Reference

Table MyMessages

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_messages
INSERT send_mail
UPDATE
UPSERT
DELETE
LOOKUP get_my_message

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 MyMessages 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)
MyMessages
There are no parameters to configure.
SSIS API Source - Read from table or endpoint

Read/write to MyMessages 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)
MyMessages
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 messages for the current user

<p>Gets all messages for the current user's mailbox. Use <code>MyMessages</code> to list every message in the default folder.</p> 

SELECT * FROM MyMessages

Read a message by ID

<p>Gets a single message by ID. Use <code>WHERE Id='...'</code> with the message ID from the mailbox.</p> 

SELECT * FROM MyMessages
WHERE Id='AAXkADIwNzNhODMyLTZiMTQtNDhiMC02OWQzLTc5YTY5M2IyMjk0NABGAyAAAACbj2hVuNphT74wylrfU4ixBwAbUV6IxRnpQrqzrb2WfacdAAAAAAEMAAAbUV6IxRnpQrqzrb2WfacdAAAysBnxAAA='

Read messages ordered by sent time (ascending)

<p>Gets messages ordered by sent date/time ascending. Use <code>OrderBy='sentDateTime'</code> in the <code>WITH</code> clause.</p> 

SELECT * FROM MyMessages WITH (OrderBy='sentDateTime')

Read messages ordered by sent time (descending)

<p>Gets messages ordered by sent date/time descending. Use <code>OrderBy='sentDateTime desc'</code> in the <code>WITH</code> clause.</p> 

SELECT * FROM MyMessages WITH (OrderBy='sentDateTime desc')

Read messages ordered by received time (ascending)

<p>Gets messages ordered by received date/time ascending. Use <code>OrderBy='receivedDateTime'</code> in the <code>WITH</code> clause.</p> 

SELECT * FROM MyMessages WITH (OrderBy='receivedDateTime')

Read messages ordered by received time (descending)

<p>Gets messages ordered by received date/time descending. Use <code>OrderBy='receivedDateTime desc'</code> in the <code>WITH</code> clause.</p> 

SELECT * FROM MyMessages WITH (OrderBy='receivedDateTime desc')

Read messages ordered by sender name (ascending)

<p>Gets messages ordered by sender name ascending. Use <code>OrderBy='sender/emailAddress/name'</code> in the <code>WITH</code> clause.</p> 

SELECT * FROM MyMessages WITH (OrderBy='sender/emailAddress/name')

Read messages ordered by sender name (descending)

<p>Gets messages ordered by sender name descending. Use <code>OrderBy='sender/emailAddress/name desc'</code> in the <code>WITH</code> clause.</p> 

SELECT * FROM MyMessages WITH (OrderBy='sender/emailAddress/name desc')

Send an email

<p>Sends an email via the Office 365 API. You can set headers, HTML or text body, recipients, and attach local files. Use <code>BodyContentType</code> set to <code>Text</code> for plain text instead of HTML.</p> 

INSERT INTO MyMessages
(Subject, BodyContentType, BodyContent
, ToRecipients, CcRecipients, BccRecipients
, InternetMessageHeaders
, Attachments, Importance, IsDeliveryReceiptRequested, IsReadReceiptRequested
, SaveToSentItems)
VALUES
('Employee Reviews Scheduled', 'HTML', '<b>Hi All,</b> employee reviews have been scheduled. <span style="text-decoration: underline;">Please reflect this in your notes.</span>',
 '[{ "emailAddress": { "address": "john.doe@domain.com" }}, { "emailAddress": { "address": "jane.doe@domain.com" }}]',
 '[{ "emailAddress": { "address": "mary.dawson@domain.com" }}]',
 '[{ "emailAddress": { "address": "ryan.connor@domain.com" }}]',
 '[{ "name": "x-custom-header-group-name", "value": "Managers" }, { "name": "x-custom-header-group-id", "value":"MGR001" }]',
 '[
      {
        "@odata.type": "#microsoft.graph.fileAttachment",
        "name": "file1.txt",
        "contentType": "text/plain",
        "contentBytes": "<<c:\file1.txt,FUN_FILE_BASE64ENC>>"
      },
      {
        "@odata.type": "#microsoft.graph.fileAttachment",
        "name": "profile-picture.png",
        "contentType": "image/png",
        "contentBytes": "<<c:\profile-picture.png,FUN_FILE_BASE64ENC>>"
      }	  
  ]', 
 'normal', 'false', 'false', 'true')

SQL Server

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

Read messages for the current user

<p>Gets all messages for the current user's mailbox. Use <code>MyMessages</code> to list every message in the default folder.</p> 

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

EXEC (@MyQuery) AT [LS_TO_OUTLOOK_MAIL_OFFICE_365_IN_GATEWAY];

Read a message by ID

<p>Gets a single message by ID. Use <code>WHERE Id='...'</code> with the message ID from the mailbox.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM MyMessages
WHERE Id=''AAXkADIwNzNhODMyLTZiMTQtNDhiMC02OWQzLTc5YTY5M2IyMjk0NABGAyAAAACbj2hVuNphT74wylrfU4ixBwAbUV6IxRnpQrqzrb2WfacdAAAAAAEMAAAbUV6IxRnpQrqzrb2WfacdAAAysBnxAAA=''';

EXEC (@MyQuery) AT [LS_TO_OUTLOOK_MAIL_OFFICE_365_IN_GATEWAY];

Read messages ordered by sent time (ascending)

<p>Gets messages ordered by sent date/time ascending. Use <code>OrderBy='sentDateTime'</code> in the <code>WITH</code> clause.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM MyMessages WITH (OrderBy=''sentDateTime'')';

EXEC (@MyQuery) AT [LS_TO_OUTLOOK_MAIL_OFFICE_365_IN_GATEWAY];

Read messages ordered by sent time (descending)

<p>Gets messages ordered by sent date/time descending. Use <code>OrderBy='sentDateTime desc'</code> in the <code>WITH</code> clause.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM MyMessages WITH (OrderBy=''sentDateTime desc'')';

EXEC (@MyQuery) AT [LS_TO_OUTLOOK_MAIL_OFFICE_365_IN_GATEWAY];

Read messages ordered by received time (ascending)

<p>Gets messages ordered by received date/time ascending. Use <code>OrderBy='receivedDateTime'</code> in the <code>WITH</code> clause.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM MyMessages WITH (OrderBy=''receivedDateTime'')';

EXEC (@MyQuery) AT [LS_TO_OUTLOOK_MAIL_OFFICE_365_IN_GATEWAY];

Read messages ordered by received time (descending)

<p>Gets messages ordered by received date/time descending. Use <code>OrderBy='receivedDateTime desc'</code> in the <code>WITH</code> clause.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM MyMessages WITH (OrderBy=''receivedDateTime desc'')';

EXEC (@MyQuery) AT [LS_TO_OUTLOOK_MAIL_OFFICE_365_IN_GATEWAY];

Read messages ordered by sender name (ascending)

<p>Gets messages ordered by sender name ascending. Use <code>OrderBy='sender/emailAddress/name'</code> in the <code>WITH</code> clause.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM MyMessages WITH (OrderBy=''sender/emailAddress/name'')';

EXEC (@MyQuery) AT [LS_TO_OUTLOOK_MAIL_OFFICE_365_IN_GATEWAY];

Read messages ordered by sender name (descending)

<p>Gets messages ordered by sender name descending. Use <code>OrderBy='sender/emailAddress/name desc'</code> in the <code>WITH</code> clause.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM MyMessages WITH (OrderBy=''sender/emailAddress/name desc'')';

EXEC (@MyQuery) AT [LS_TO_OUTLOOK_MAIL_OFFICE_365_IN_GATEWAY];

Send an email

<p>Sends an email via the Office 365 API. You can set headers, HTML or text body, recipients, and attach local files. Use <code>BodyContentType</code> set to <code>Text</code> for plain text instead of HTML.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO MyMessages
(Subject, BodyContentType, BodyContent
, ToRecipients, CcRecipients, BccRecipients
, InternetMessageHeaders
, Attachments, Importance, IsDeliveryReceiptRequested, IsReadReceiptRequested
, SaveToSentItems)
VALUES
(''Employee Reviews Scheduled'', ''HTML'', ''<b>Hi All,</b> employee reviews have been scheduled. <span style="text-decoration: underline;">Please reflect this in your notes.</span>'',
 ''[{ "emailAddress": { "address": "john.doe@domain.com" }}, { "emailAddress": { "address": "jane.doe@domain.com" }}]'',
 ''[{ "emailAddress": { "address": "mary.dawson@domain.com" }}]'',
 ''[{ "emailAddress": { "address": "ryan.connor@domain.com" }}]'',
 ''[{ "name": "x-custom-header-group-name", "value": "Managers" }, { "name": "x-custom-header-group-id", "value":"MGR001" }]'',
 ''[
      {
        "@odata.type": "#microsoft.graph.fileAttachment",
        "name": "file1.txt",
        "contentType": "text/plain",
        "contentBytes": "<<c:\file1.txt,FUN_FILE_BASE64ENC>>"
      },
      {
        "@odata.type": "#microsoft.graph.fileAttachment",
        "name": "profile-picture.png",
        "contentType": "image/png",
        "contentBytes": "<<c:\profile-picture.png,FUN_FILE_BASE64ENC>>"
      }	  
  ]'', 
 ''normal'', ''false'', ''false'', ''true'')';

EXEC (@MyQuery) AT [LS_TO_OUTLOOK_MAIL_OFFICE_365_IN_GATEWAY];