Power BI Connector for Oracle Eloqua

Build 24.0.8963

Email

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963