SSIS Components for Oracle Eloqua

Build 24.0.8963

EmailFolder

Retrieve Email Folders.

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 Description
ID [KEY] Long The unique identifier for the folder.
Name String The name of the folder.
IsSystem Boolean Identifies a system-generated folder.
Description String The description of the folder.
Permissions String The permissions of the folder.
CreatedAt Datetime Date the folder was created.
CreatedBy String The Id of the user who created the folder.
AccessedAt Datetime Date the folder was accessed.
CurrentStatus String The current status of the folder.
UpdatedAt Datetime Date the folder was last updated.
UpdatedBy String The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Depth String The depth of information requested from Eloqua.

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