Create, update, delete, and query Emails.
Table Specific Information
Select
The following limitation exists for filtering on datetime columns: The "=" operator cannot be used with datetime columns in the WHERE clause. However, the "<", ">", ">=", and "<=" operators can be used to filter on datetime columns.
Additionally, the UpdatedAt column only supports filtering with the '>' operator.
Oracle Eloqua also has limited support on multiple conditions. In many tables the AND condition between filters is not supported. If AND is included the server might not return any results, nor will it return an error.
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | Long | True |
The unique identifier of the email. |
| Name | String | False |
The name of the email. |
| EmailGroupId | Long | False |
The Id of the email group. |
| HtmlContent_ContentSource | String | False |
The raw HTML contentSorce for the content of the email. |
| HtmlContent_CssHeader | String | False |
The raw HTML cssHeader for the content of the email. |
| HtmlContent_DocType | String | False |
The raw HTML docType for the content of the email. |
| HtmlContent_DocumentDescription | String | False |
The raw HTML documentDescription for the content of the email. |
| HtmlContent_HtmlBody | String | False |
The raw HTML Body for the content of the email. |
| HtmlContent_MetaTags | String | True |
The raw HTML metaTags for the content of the email. |
| HtmlContent_Root | String | False |
The raw HTML root for the content of the email. |
| HtmlContent_SystemHeader | String | False |
The raw HTML systemHeader for the content of the email. |
| HtmlContent_Type | String | False |
The raw HTML type for the content of the email. |
| IsPlainTextEditable | Boolean | False |
Identifies whether the email is plaintext editable. |
| IsTracked | Boolean | False |
Identifies whether the email is tracked. |
| PlainText | String | False |
The plaintext version of the email. |
| BouncebackEmail | String | False |
The bounce-back email address. |
| ReplyToEmail | String | False |
The email address in the reply-to line of the email. |
| ReplyToName | String | False |
The name in the reply-to line of the email. |
| SenderEmail | String | False |
The email address of the sender. |
| SenderName | String | False |
The name of the sender. |
| SenderPlainTextOnly | Boolean | False |
Identifies whether the plaintext version should be sent. |
| Subject | String | False |
The subject of the email. |
| Description | String | False |
The description of the email. |
| FolderId | Long | False |
The Id of the folder for the email. |
| EmailHeaderId | Long | False |
The Id of the email header. |
| EmailFooterId | Long | False |
The Id of the email footer. |
| Permissions | String | False |
The permissions of the email. |
| CreatedAt | Datetime | True |
Date the email was created. |
| CreatedBy | String | True |
The Id of the user who created the email. |
| AccessedAt | Datetime | False |
Date the email was accessed. |
| CurrentStatus | String | False |
The current status of the email. |
| Depth | String | False |
The depth of the email. |
| UpdatedAt | Datetime | True |
Date the email was updated. |
| UpdatedBy | String | True |
The Id of the user who last updated the email. |