SSIS Components for Oracle Eloqua

Build 24.0.8963

EmailGroup

Create, update, delete, and query Email Groups.

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 group.

Name String False

The name of the email.

DisplayName String False

The display name of the email group.

EmailFooterId Long False

The Id of the email footer of the email group.

EmailIds String False

The Ids of the emails in the email group.

IsVisibleInOutlookPlugin Boolean False

Identifies whether the email group is visible in the Outlook plugin.

IsVisibleInPublicSubscriptionList Boolean False

Identifies whether the email group is visible in public subscription list.

SubscriptionLandingPageId Long False

The Id of the landing page used to subscribe to the email group.

SubscriptionListId Long False

The Id of the subscription list for the email group.

UnsubscriptionLandingPageId Long False

The Id of the landing page used to unsubscribe for the email group.

UnsubscriptionListId Long False

The Id of the unsubscription list for the email group.

UnsubscriptionListDataLookupId String False

The Id of the data lookup for the unsubscription list for the email group.

Description String False

The description of the email group.

FolderId Long False

The folder Id for the email group.

Permissions String False

The permissions list of the email group.

CreatedAt Datetime True

Date the email group was created.

CreatedBy String True

The Id of the user who created the email group.

AccessedAt Datetime False

Date the email group was accessed.

CurrentStatus String False

The current status of the email group.

Depth String False

The depth of the email group.

UpdatedAt Datetime True

Date the email group was updated.

UpdatedBy String True

The Id of the user who last updated the email group.

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