invantive documentation
Invantive Support ForumsLog In / Sign Up

MAILS: Outlook Mails

insert update delete

  • Catalog: Outlook
  • Schema: Mails
  • Primary Keys: EntryID
  • Label: Mails

Can retrieve data and change data using insert, update and delete.

Summary

Outlook mails.

Parameters

Name Data Type Required Default Documentation
folderEntryId `` Unique ID of the folder as a reference to the table 'FOLDERS'.
includeFullBody `` Whether to include the full body text.
storeEntryId `` Unique ID of a store as a reference to the table 'FOLDERS' when queried with include external stores.

Table Columns

The columns of the table MAILS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
AlternateRecipientAllowed boolean
AutoForwarded boolean
BCC varchar2
BillingInformation varchar2
Body varchar2
Categories varchar2 Categories
CC varchar2
ConversationIndex varchar2
ConversationTopic varchar2
CreationTime datetime
DeferredDeliveryTime datetime
DeleteAfterSubmit boolean
EntryID varchar2(1024)
ExpiryTime datetime
FlagDueBy datetime
FlagRequest varchar2
FlagStatus numeric
FolderID varchar2(1024)
HTMLBody varchar2
Importance numeric
LastModificationTime datetime
MarkForDownload numeric
Mileage varchar2
NoAging boolean
OriginatorDeliveryReportRequested boolean
ReadReceiptRequested boolean
ReceivedByName varchar2
ReceivedOnBehalfOfName varchar2
ReceivedTime datetime
RecipientReassignmentProhibited boolean
ReminderOverrideDefault boolean
ReminderPlaySound boolean
ReminderSet boolean
ReminderSoundFile varchar2
ReminderTime datetime
RemoteStatus varchar2
ReplyRecipientNames varchar2
SenderEmailAddress varchar2
SenderEmailType varchar2
SenderName varchar2
Sensitivity numeric
SentOn datetime
SentOnBehalfOfName varchar2
Size numeric
StoreID varchar2(1024)
Subject varchar2
TaskCompletedDate datetime
TaskDueDate datetime
TaskStartDate datetime
To varchar2
ToDoTaskOrdinal datetime
UnRead boolean
VotingResponse varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: